【山巅远眺】
学习思路:但是不想用无参数的查询方法,就在U层没有传数据,但是在D层用了有参数的查询方法。
设计理念:设一个用户看不到的参数。但是需要在数据库里添加一个标识字段。我这里是10001. 用户只需要看到后面的五项数据即可!
SQL语句中的 where SerialID = 10001,很巧妙!有偷梁换柱、狸猫换太子的功效!
【披荆斩棘】
当窗体加载时
private void UIFormBasicInformationSetting_Load(object sender, EventArgs e)
{
#region 控件的可用性
btnSave.Enabled = false;
txtTmpCost.Enabled = false;
txtUnitTime.Enabled = false;
txtLeastTime.Enabled = false;
txtReadyTime.Enabled = false;
txtLeastCost.Enabled = false;
#endregion
#region 加载基本数据表中的信息
Entity.BasicDataInfo BasicDataInfo = new Entity.BasicDataInfo();
BasicDataInfo.SerialID = 10001;
Facade.QueryFacade facadeShowBasicDataInfo = new Facade.QueryFacade();
List<Entity.BasicDataInfo> List = new List<Entity.BasicDataInfo>();
List = facadeShowBasicDataInfo.showBasicDataInfo(BasicDataInfo);
txtTmpCost.Text = List[0].TmpCost.ToString();
txtUnitTime.Text = List[0].UnitTime.ToString();
txtLeastTime.Text = List[0].LeastTime.ToString();
txtReadyTime.Text = List[0].ReadyTime.ToString();
txtLeastCost.Text = List[0].LeastCost.ToString();
#endregion
}
D层代码
#region 基本数据设定:更新数据
public bool updateBasicDataInfo(Entity.BasicDataInfo BasicDataInfo)
{
bool result = false;
SqlHelper.SqlHelperAll sqlHelperUpdateBasicDataInfo = new SqlHelper.SqlHelperAll();
string sql = "update BasicData_Info set TmpCost=@TmpCost,UnitTime=@UnitTime,LeastTime=@LeastTime,ReadyTiime=@ReadyTiime,LeastCost=@LeastCost where SerialID = 10001";
SqlParameter[] sqlParams = { new SqlParameter("@SerialID", BasicDataInfo.SerialID), new SqlParameter("@TmpCost", BasicDataInfo.TmpCost), new SqlParameter("@UnitTime", BasicDataInfo.UnitTime), new SqlParameter("@LeastTime", BasicDataInfo.LeastTime), new SqlParameter("@ReadyTiime", BasicDataInfo.ReadyTime), new SqlParameter("@LeastCost", BasicDataInfo.LeastCost) };
int res = sqlHelperUpdateBasicDataInfo.ExecuteNonQuery(sql,CommandType.Text,sqlParams);
if (res>0)
{
result = true;
}
return result;
}
#endregion
【筋斗云】