/// <summary> /// 添加与编辑SYS_PARAMATERS记录 /// </summary> /// <param name="page">当前页面指针</param> /// <param name="model">SYS_PARAMATERS表实体</param> /// <param name="content">更新说明</param> /// <param name="isCache">是否更新缓存</param> /// <param name="isAddUseLog">是否添加用户操作日志</param> public void Save(Page page, SYS_PARAMATERS model, string content = null, bool isCache = true, bool isAddUseLog = true) { try { //保存 model.Save(); //判断是否启用缓存 if (CommonBll.IsUseCache() && isCache) { SetModelForCache(model); } if (isAddUseLog) { if (string.IsNullOrEmpty(content)) { content = "{0}" + (model.Id == 0 ? "添加" : "编辑") + "SYS_PARAMATERS记录成功,ID为【" + model.Id + "】"; } //添加用户访问记录 UseLogBll.GetInstence().Save(page, content); } } catch (Exception e) { var result = "执行SYS_PARAMATERSBll.Save()函数出错!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } }
/// <summary> /// 从IIS缓存中获取指定Id记录 /// </summary> /// <param name="id">主键Id</param> /// <returns>DataAccess.Model.SYS_PARAMATERS</returns> public DataAccess.Model.SYS_PARAMATERS GetModelForCache(long id) { try { //从缓存中读取指定Id记录 var model = GetModelForCache(x => x.Id == id); if (model == null) { //从数据库中读取 var tem = SYS_PARAMATERS.SingleOrDefault(x => x.Id == id); if (tem == null) { return(null); } else { //对查询出来的实体进行转换 model = Transform(tem); return(model); } } else { return(model); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取SYS_PARAMATERS表记录时出现异常", e); return(null); } }
/// <summary> /// 获取指定Id记录 /// </summary> /// <param name="id">主键Id</param> /// <param name="isCache">是否从缓存中读取</param> /// <returns>DataAccess.Model.SYS_PARAMATERS</returns> public DataAccess.Model.SYS_PARAMATERS GetModel(long id, bool isCache = true) { //判断是否使用缓存 if (CommonBll.IsUseCache() && isCache) { //从缓存中获取List var list = GetList(); if (list == null) { return(null); } else { //在List查询指定主键Id的记录 return(list.SingleOrDefault(x => x.Id == id)); } } else { //从数据库中直接读取 var model = SYS_PARAMATERS.SingleOrDefault(x => x.Id == id); if (model == null) { return(null); } else { //对查询出来的实体进行转换 return(Transform(model)); } } }
/// <summary> /// 将SYS_PARAMATERS记录实体(SubSonic实体)转换为普通的实体(DataAccess.Model.SYS_PARAMATERS) /// </summary> /// <param name="model">SubSonic插件生成的实体</param> /// <returns>DataAccess.Model.SYS_PARAMATERS</returns> public DataAccess.Model.SYS_PARAMATERS Transform(SYS_PARAMATERS model) { if (model == null) { return(null); } return(new DataAccess.Model.SYS_PARAMATERS { Id = model.Id, AREA_ID = model.AREA_ID, COL_ORDER_TYPE = model.COL_ORDER_TYPE, ORDER_PRICE_TYPE = model.ORDER_PRICE_TYPE, QUANTITY_TYPE = model.QUANTITY_TYPE, EXPECT_DATE_TYPE = model.EXPECT_DATE_TYPE, PRD_BOM_TYPE = model.PRD_BOM_TYPE, CRT_DATETIME = model.CRT_DATETIME, CRT_USER_ID = model.CRT_USER_ID, MOD_DATETIME = model.MOD_DATETIME, MOD_USER_ID = model.MOD_USER_ID, LAST_UPDATE = model.LAST_UPDATE, MEMO = model.MEMO, PALN_TYPE = model.PALN_TYPE, }); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 if (ddlAREA.SelectedValue.Trim() == "0") { return(ddlAREA.Label + "不能为空!"); } #endregion #region 赋值 //读取指定部门资料 var model = new SYS_PARAMATERS(x => x.Id == id); model.AREA_ID = ddlAREA.SelectedValue + ""; model.COL_ORDER_TYPE = ConvertHelper.Cint0(ddlCOL_ORDER_TYPE.SelectedValue.ToString()); model.ORDER_PRICE_TYPE = ConvertHelper.Cint0(ddlORDER_PRICE_TYPE.SelectedValue); model.QUANTITY_TYPE = ConvertHelper.Cint0(ddlQUANTITY_TYPE.SelectedValue); model.EXPECT_DATE_TYPE = ConvertHelper.Cint0(ddlEXPECT_DATE_TYPE.SelectedValue); model.PRD_BOM_TYPE = ConvertHelper.Cint0(ddlPRD_BOM_TYPE.SelectedValue); model.PALN_TYPE = ConvertHelper.Cint0(ddlPALN_TYPE.SelectedValue); model.CRT_DATETIME = DateTime.Now; model.CRT_USER_ID = ""; model.MOD_DATETIME = DateTime.Now; model.MOD_USER_ID = ""; model.LAST_UPDATE = DateTime.Now; model.MEMO = ""; #endregion //---------------------------------------------------------- //存储到数据库 SYS_PARAMATERSBll.GetInstence().Save(this, model); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 if (ddlAREA.SelectedValue.Trim() == "0") { return(ddlAREA.Label + "不能为空!"); } #endregion #region 赋值 //读取指定部门资料 var model = new SYS_PARAMATERS(x => x.Id == id); model.Area_Id = ddlAREA.SelectedValue + ""; model.Code = txt_key.Text; model.VALUE = value_droplist.SelectedValue; model.KEY_CN = key_cn.Text; model.MEMO = txt_memo.Text; //model.CRT_DATETIME = DateTime.Now; //model.CRT_USER_ID = ""; //model.MOD_DATETIME = DateTime.Now; //model.MOD_USER_ID = ""; //model.LAST_UPDATE = DateTime.Now; //model.MEMO = ""; #endregion //---------------------------------------------------------- //存储到数据库 SYS_PARAMATERSBll.GetInstence().Save(this, model); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// 判断指定主键Id的记录是否存在——在IIS缓存或数据库中查找 /// </summary> /// <param name="id">主键Id</param> /// <returns></returns> public bool Exist(int id) { if (id <= 0) { return(false); } //判断是否启用缓存 if (CommonBll.IsUseCache()) { return(Exist(x => x.Id == id)); } //从数据库中查找 return(SYS_PARAMATERS.Exists(x => x.Id == id)); }
/// <summary> /// 将SYS_PARAMATERS记录实体(SubSonic实体)转换为普通的实体(DataAccess.Model.SYS_PARAMATERS) /// </summary> /// <param name="model">SubSonic插件生成的实体</param> /// <returns>DataAccess.Model.SYS_PARAMATERS</returns> public DataAccess.Model.SYS_PARAMATERS Transform(SYS_PARAMATERS model) { if (model == null) { return(null); } return(new DataAccess.Model.SYS_PARAMATERS { Id = model.Id, Code = model.Code, VALUE = model.VALUE, KEY_CN = model.KEY_CN, MEMO = model.MEMO, Area_Id = model.Area_Id, }); }
/// <summary> /// 获取数据表中的某个值——从数据库中查询,如果使用了缓存,删除成功后会清空本表的所有缓存记录,然后重新加载进缓存 /// </summary> /// <param name="page">当前页面指针</param> /// <param name="expression">条件语句</param> /// <param name="isAddUseLog">是否添加用户操作日志</param> public void Delete(Page page, Expression <Func <SYS_PARAMATERS, bool> > expression, bool isAddUseLog = true) { //执行删除 SYS_PARAMATERS.Delete(expression); //判断是否启用缓存 if (CommonBll.IsUseCache()) { //清空当前表所有缓存记录 DelAllCache(); //重新载入缓存 GetList(); } if (isAddUseLog) { //添加用户操作记录 UseLogBll.GetInstence().Save(page, "{0}删除了SYS_PARAMATERS表记录!"); } }
/// <summary> /// 列表按键绑定——修改列表控件属性 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid1_PreRowDataBound(object sender, FineUI.GridPreRowEventArgs e) { //绑定是否显示状态列 int o = e.RowIndex; DataRowView row = e.DataItem as DataRowView; string shop_id = ((System.Data.DataRowView)(row)).Row.Table.Rows[e.RowIndex][Col_Order00Table.SHOP_ID].ToString(); var model = new SHOP00(x => x.SHOP_ID == shop_id); if (model != null) { // ((System.Data.DataRowView)(gr.DataItem)).Row[e.RowIndex] var tf = Grid1.FindColumn("SHOP_LIK") as FineUI.LinkButtonField; tf.Text = model.SHOP_NAME1; } string col_id = ((System.Data.DataRowView)(row)).Row.Table.Rows[e.RowIndex][Col_Order00Table.COL_ID].ToString(); var model_ARCHIVEORDERS = new Col_Order00(x => x.COL_ID == col_id); var model_SHOP = new SHOP00(x => x.SHOP_ID == shop_id); string area_id = model_SHOP.SHOP_Area_ID.ToString(); var model_SYS_PARAMATERS = new SYS_PARAMATERS(x => x.Area_Id == area_id); string type = ""; if (model_SYS_PARAMATERS != null) { var a_type = Grid1.FindColumn("ARCHIVEORDERS_TYPE") as FineUI.LinkButtonField; //if (model_SYS_PARAMATERS.COL_ORDER_TYPE == 0) //产品类型汇整 //{ if (model_ARCHIVEORDERS.PROD_TYPE == 0) { type = "自产型"; } if (model_ARCHIVEORDERS.PROD_TYPE == 1) { type = "供应型"; } if (model_ARCHIVEORDERS.PROD_TYPE == 2) { type = "委托加工型"; } //} //if (model_SYS_PARAMATERS.COL_ORDER_TYPE == 1) //产品类型汇整 //{ // if (model_ARCHIVEORDERS.PROD_TYPE == 1) { type = "普通订货"; } // if (model_ARCHIVEORDERS.PROD_TYPE == 2) { type = "客户订货"; } //} a_type.Text = type; //1=存档 2=已核准 3=作废 4=已汇整 [缺省值=0] string status = ((System.Data.DataRowView)(row)).Row.Table.Rows[e.RowIndex][Col_Order00Table.STATUS].ToString(); var astatus = Grid1.FindColumn("ARCHIVEORDERS_STATUS") as FineUI.LinkButtonField; if (status == "1") { astatus.Text = "存档"; } if (status == "2") { astatus.Text = "已核准"; } if (status == "3") { astatus.Text = "作废"; } if (status == "4") { astatus.Text = "已汇整"; } } //GridRow gr = Grid1.Rows[e.RowIndex]; // + 1 //if (((System.Data.DataRowView)(gr.DataItem)).Row.Table.Rows[e.RowIndex][MenuInfoTable.IsDisplay].ToString() == "0") //{ // var lbf = Grid1.FindColumn("IsDisplay") as LinkButtonField; // lbf.Icon = Icon.BulletCross; // lbf.CommandArgument = "1"; //} //else //{ // var lbf = Grid1.FindColumn("IsDisplay") as LinkButtonField; // lbf.Icon = Icon.BulletTick; // lbf.CommandArgument = "0"; //} ////绑定是否菜单列 //if (((System.Data.DataRowView)(gr.DataItem)).Row.Table.Rows[e.RowIndex][MenuInfoTable.IsMenu].ToString() == "0") //{ // var lbf = Grid1.FindColumn("IsMenu") as LinkButtonField; // lbf.Icon = Icon.BulletCross; // lbf.CommandArgument = "1"; //} //else //{ // var lbf = Grid1.FindColumn("IsMenu") as LinkButtonField; // lbf.Icon = Icon.BulletTick; // lbf.CommandArgument = "0"; //} //绑定是否编辑列 //var lbfEdit = Grid1.FindColumn("ButtonEdit") as LinkButtonField; //lbfEdit.Text = "编辑"; //lbfEdit.Enabled = MenuInfoBll.GetInstence().CheckControlPower(this, "ButtonEdit"); }
protected void Grid1_RowSelect(object sender, FineUI.GridRowSelectEventArgs e) { string str = GridViewHelper.GetSelectedKey(Grid1, true); string[] col_id_shop_id = str.Split(','); string shop_id = col_id_shop_id[1]; string col_id = col_id_shop_id[0]; DataTable dt_left = null; dt_left = Col_Order00Bll.GetInstence().GET_ARCHIVEORDERS_LEFT_LIST(col_id); Grid2.DataSource = dt_left; Grid2.DataBind(); Grid2.SelectedRowIndex = 0; string prod_id = GridViewHelper.GetSelectedKey(Grid2, true); DataTable dt_right = null; dt_right = Col_Order00Bll.GetInstence().GET_ARCHIVEORDERS_RIGHT_LIST(shop_id, prod_id, col_id); Grid3.DataSource = dt_right; Grid3.DataBind(); var PurchasePLANColumn0 = Grid3.FindColumn("SUP_QUAN0") as FineUI.RenderField; // HeaderText="生产量/采购量" var PurchasePLANColumn1 = Grid3.FindColumn("SUP_QUAN1") as FineUI.RenderField; // HeaderText="生产量/采购量" var model_ARCHIVEORDERS = new Col_Order00(x => x.COL_ID == col_id); var model_SHOP = new SHOP00(x => x.SHOP_ID == shop_id); string area_id = model_SHOP.SHOP_Area_ID.ToString(); var model_SYS_PARAMATERS = new SYS_PARAMATERS(x => x.AREA_ID == area_id); if (model_SYS_PARAMATERS != null) { if (model_SYS_PARAMATERS.COL_ORDER_TYPE == 0) //产品类型汇整 { if (model_ARCHIVEORDERS.PROD_TYPE == 0) { PurchasePLANColumn1.Hidden = true; PPhidId.Text = "0"; } if (model_ARCHIVEORDERS.PROD_TYPE == 1) { PurchasePLANColumn0.Hidden = true; PPhidId.Text = "1"; } if (model_ARCHIVEORDERS.PROD_TYPE == 2) { PurchasePLANColumn0.Hidden = true; PPhidId.Text = "1"; } } if (model_SYS_PARAMATERS.COL_ORDER_TYPE == 1) //产品类型汇整 { if (model_ARCHIVEORDERS.PROD_TYPE == 1) { PurchasePLANColumn0.Hidden = true; PPhidId.Text = "0"; } if (model_ARCHIVEORDERS.PROD_TYPE == 2) { PurchasePLANColumn0.Hidden = true; PPhidId.Text = "1"; } } } }
/// <summary> /// 从IIS缓存中获取SYS_PARAMATERS表记录 /// </summary> /// <param name="isCache">是否从缓存中读取</param> public IList <DataAccess.Model.SYS_PARAMATERS> GetList(bool isCache = true) { try { //判断是否使用缓存 if (CommonBll.IsUseCache() && isCache) { //检查指定缓存是否过期——缓存当天有效,第二天自动清空 if (CommonBll.CheckCacheIsExpired(const_CacheKey_Date)) { //删除缓存 DelAllCache(); } //从缓存中获取DataTable var obj = CacheHelper.GetCache(const_CacheKey); //如果缓存为null,则查询数据库 if (obj == null) { var list = GetList(false); //将查询出来的数据存储到缓存中 CacheHelper.SetCache(const_CacheKey, list); //存储当前时间 CacheHelper.SetCache(const_CacheKey_Date, DateTime.Now); return(list); } //缓存中存在数据,则直接返回 else { return((IList <DataAccess.Model.SYS_PARAMATERS>)obj); } } else { //定义临时实体集 IList <DataAccess.Model.SYS_PARAMATERS> list = null; //获取全表缓存加载条件表达式 var exp = GetExpression <SYS_PARAMATERS>(); //如果条件为空,则查询全表所有记录 if (exp == null) { //从数据库中获取所有记录 var all = SYS_PARAMATERS.All(); list = all == null ? null : Transform(all.ToList()); } else { //从数据库中查询出指定条件的记录,并转换为指定实体集 var all = SYS_PARAMATERS.Find(exp); list = all == null ? null : Transform(all); } return(list); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取SYS_PARAMATERS表记录时出现异常", e); } return(null); }
/// <summary> /// 更新IIS缓存中指定Id记录 /// </summary> /// <param name="model">记录实体</param> public void SetModelForCache(SYS_PARAMATERS model) { SetModelForCache(Transform(model)); }
/// <summary> /// 从IIS缓存中获取指定Id记录 /// </summary> /// <param name="conditionColName">条件列名</param> /// <param name="value">条件值</param> /// <returns>DataAccess.Model.SYS_PARAMATERS</returns> public DataAccess.Model.SYS_PARAMATERS GetModelForCache(string conditionColName, object value) { try { //从缓存中获取List var list = GetList(); DataAccess.Model.SYS_PARAMATERS model = null; Expression <Func <SYS_PARAMATERS, bool> > expression = null; //返回指定条件的实体 switch (conditionColName) { case "Id": model = list.SingleOrDefault(x => x.Id == (int)value); expression = x => x.Id == (int)value; break; case "Code": model = list.SingleOrDefault(x => x.Code == (string)value); expression = x => x.Code == (string)value; break; case "VALUE": model = list.SingleOrDefault(x => x.VALUE == (string)value); expression = x => x.VALUE == (string)value; break; case "KEY_CN": model = list.SingleOrDefault(x => x.KEY_CN == (string)value); expression = x => x.KEY_CN == (string)value; break; case "MEMO": model = list.SingleOrDefault(x => x.MEMO == (string)value); expression = x => x.MEMO == (string)value; break; case "Area_Id": model = list.SingleOrDefault(x => x.Area_Id == (string)value); expression = x => x.Area_Id == (string)value; break; default: return(null); } if (model == null) { //从数据库中读取 var tem = SYS_PARAMATERS.SingleOrDefault(expression); if (tem == null) { return(null); } else { //对查询出来的实体进行转换 model = Transform(tem); return(model); } } else { return(model); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取SYS_PARAMATERS表记录时出现异常", e); return(null); } }
/// <summary> /// 从IIS缓存中获取指定Id记录 /// </summary> /// <param name="conditionColName">条件列名</param> /// <param name="value">条件值</param> /// <returns>DataAccess.Model.SYS_PARAMATERS</returns> public DataAccess.Model.SYS_PARAMATERS GetModelForCache(string conditionColName, object value) { try { //从缓存中获取List var list = GetList(); DataAccess.Model.SYS_PARAMATERS model = null; Expression <Func <SYS_PARAMATERS, bool> > expression = null; //返回指定条件的实体 switch (conditionColName) { case "Id": model = list.SingleOrDefault(x => x.Id == (int)value); expression = x => x.Id == (int)value; break; case "AREA_ID": model = list.SingleOrDefault(x => x.AREA_ID == (string)value); expression = x => x.AREA_ID == (string)value; break; case "COL_ORDER_TYPE": model = list.SingleOrDefault(x => x.COL_ORDER_TYPE == (int)value); expression = x => x.COL_ORDER_TYPE == (int)value; break; case "ORDER_PRICE_TYPE": model = list.SingleOrDefault(x => x.ORDER_PRICE_TYPE == (int)value); expression = x => x.ORDER_PRICE_TYPE == (int)value; break; case "QUANTITY_TYPE": model = list.SingleOrDefault(x => x.QUANTITY_TYPE == (int)value); expression = x => x.QUANTITY_TYPE == (int)value; break; case "EXPECT_DATE_TYPE": model = list.SingleOrDefault(x => x.EXPECT_DATE_TYPE == (int)value); expression = x => x.EXPECT_DATE_TYPE == (int)value; break; case "PRD_BOM_TYPE": model = list.SingleOrDefault(x => x.PRD_BOM_TYPE == (int)value); expression = x => x.PRD_BOM_TYPE == (int)value; break; case "CRT_DATETIME": model = list.SingleOrDefault(x => x.CRT_DATETIME == (DateTime)value); expression = x => x.CRT_DATETIME == (DateTime)value; break; case "CRT_USER_ID": model = list.SingleOrDefault(x => x.CRT_USER_ID == (string)value); expression = x => x.CRT_USER_ID == (string)value; break; case "MOD_DATETIME": model = list.SingleOrDefault(x => x.MOD_DATETIME == (DateTime)value); expression = x => x.MOD_DATETIME == (DateTime)value; break; case "MOD_USER_ID": model = list.SingleOrDefault(x => x.MOD_USER_ID == (string)value); expression = x => x.MOD_USER_ID == (string)value; break; case "LAST_UPDATE": model = list.SingleOrDefault(x => x.LAST_UPDATE == (DateTime)value); expression = x => x.LAST_UPDATE == (DateTime)value; break; case "MEMO": model = list.SingleOrDefault(x => x.MEMO == (string)value); expression = x => x.MEMO == (string)value; break; case "PALN_TYPE": model = list.SingleOrDefault(x => x.PALN_TYPE == (int)value); expression = x => x.PALN_TYPE == (int)value; break; default: return(null); } if (model == null) { //从数据库中读取 var tem = SYS_PARAMATERS.SingleOrDefault(expression); if (tem == null) { return(null); } else { //对查询出来的实体进行转换 model = Transform(tem); return(model); } } else { return(model); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取SYS_PARAMATERS表记录时出现异常", e); return(null); } }
//protected void ButtonApproval_Click(object sender, EventArgs e) //{ // string str = GridViewHelper.GetSelectedKey(Grid1, true); // string[] col_id_shop_id = str.Split(','); // string shop_id = col_id_shop_id[1]; // string col_id = col_id_shop_id[0]; // string // int ex_int = OUT00Bll.GetInstence().SplitOrders(col_id,); // if (ex_int == 1) // { // Alert.Show("核准失败,请重新核准!"); // } // else // { // Alert.Show("核准成功!"); // } //} #region 列表属性绑定 #region 列表按键绑定——修改列表控件属性 /// <summary> /// 列表按键绑定——修改列表控件属性 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid1_PreRowDataBound(object sender, FineUI.GridPreRowEventArgs e) { //绑定是否显示状态列 int o = e.RowIndex; DataRowView row = e.DataItem as DataRowView; string shop_id = ((System.Data.DataRowView)(row)).Row.Table.Rows[e.RowIndex][Col_Order00Table.SHOP_ID].ToString(); var model = new SHOP00(x => x.SHOP_ID == shop_id); if (model != null) { // ((System.Data.DataRowView)(gr.DataItem)).Row[e.RowIndex] var tf = Grid1.FindColumn("SHOP_LIK") as FineUI.LinkButtonField; tf.Text = model.SHOP_NAME1; } string col_id = ((System.Data.DataRowView)(row)).Row.Table.Rows[e.RowIndex][Col_Order00Table.COL_ID].ToString(); var model_ARCHIVEORDERS = new Col_Order00(x => x.COL_ID == col_id); var model_SHOP = new SHOP00(x => x.SHOP_ID == shop_id); string area_id = model_SHOP.SHOP_Area_ID.ToString(); var model_SYS_PARAMATERS = new SYS_PARAMATERS(x => x.Area_Id == area_id); string type = ""; if (model_SYS_PARAMATERS != null) { var a_type = Grid1.FindColumn("ARCHIVEORDERS_TYPE") as FineUI.LinkButtonField; //if (model_SYS_PARAMATERS.COL_ORDER_TYPE == 0) //产品类型汇整 //{ // if (model_ARCHIVEORDERS.PROD_TYPE == 0) { type = "自产型"; } // if (model_ARCHIVEORDERS.PROD_TYPE == 1) { type = "供应型"; } // if (model_ARCHIVEORDERS.PROD_TYPE == 2) { type = "委托加工型"; } //} //if (model_SYS_PARAMATERS.COL_ORDER_TYPE == 1) //产品类型汇整 //{ // if (model_ARCHIVEORDERS.PROD_TYPE == 1) { type = "普通订货"; } // if (model_ARCHIVEORDERS.PROD_TYPE == 2) { type = "客户订货"; } //} a_type.Text = type; //1=存档 2=已核准 3=作废 4=已汇整 [缺省值=0] string status = ((System.Data.DataRowView)(row)).Row.Table.Rows[e.RowIndex][Col_Order00Table.STATUS].ToString(); var astatus = Grid1.FindColumn("ARCHIVEORDERS_STATUS") as FineUI.LinkButtonField; if (status == "1") { astatus.Text = "存档"; } if (status == "2") { astatus.Text = "已核准"; } if (status == "3") { astatus.Text = "作废"; } if (status == "4") { astatus.Text = "已汇整"; } } }