/// <summary>
/// DataTable 转对象
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static MakeCollectionsModes ConvertDataTableToModel(string sql)
{
error = string.Empty;
DataTable dt = SqlHelper.GetTable(sql, ref error);
DataRow dr = dt.Rows[0];
MakeCollectionsModes makecollectionsmode = new MakeCollectionsModes();
makecollectionsmode.Id = dr["Id"] == null ? "" : dr["Id"].ToString();
makecollectionsmode.MakeCollectionsMode = dr["MakeCollectionsMode"] == null ? "" : dr["MakeCollectionsMode"].ToString();
return(makecollectionsmode);
}
private void LoadPage()
{
string sql = string.Empty;
string error = string.Empty;
if (ToolManager.CheckQueryString("Id"))
{
sql = string.Format(@" select * from MakeCollectionsMode where Id='{0}' ", ToolManager.GetQueryString("Id"));
this.trNumber.Visible = false;
//sql = string.Format(@" select * from MakeCollectionsMode where Id='{0}' ", "7");
MakeCollectionsModes makecollectionsmode = MakeCollectionsModeManager.ConvertDataTableToModel(sql);
this.txtNumber.Text = makecollectionsmode.Id;
this.txtMakeCollectionsMode.Text = makecollectionsmode.MakeCollectionsMode;
btnSubmit.Text = "修改";
}
else
{
btnSubmit.Text = "添加";
}
}
/// <summary>
/// 编辑收款方式
/// </summary>
/// <param name="user"></param>
/// <param name="error"></param>
/// <returns></returns>
public static bool EditMakeCollectionsMode(MakeCollectionsModes makecollectionsmode, ref string error)
{
sql = string.Format(@" update MakeCollectionsMode set MakeCollectionsMode='{0}' where Id='{1}'", makecollectionsmode.MakeCollectionsMode, makecollectionsmode.Id);
return(SqlHelper.ExecuteSql(sql, ref error));
}