public FormSanitationCheck( ) { InitializeComponent( ); header = new MulaolaoLibrary.SanitationCheckHeaderEntity( ); body = new MulaolaoLibrary.SanitationCheckBodyEntity( ); _bll = new MulaolaoBll.Bll.SanitationCheckBll( ); GridViewMoHuSelect.SetFilter(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, View1, View2 }); GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, View1, View2 }); toolStrip1.Items.Remove(toolReview); toolStrip1.Items.Remove(toolMaintain); toolStrip1.Items.Remove(toolLibrary); toolStrip1.Items.Remove(toolStorage); toolStrip1.Items.Remove(toolcopy); controlClear( ); controlUnEnable( ); Edit1.DataSource = _bll.getTableWork( ); Edit1.DisplayMember = "DAA002"; Edit1.ValueMember = "DAA002"; Edit2.DataSource = _bll.getTableGroup( ); Edit2.DisplayMember = "DAA002"; Edit2.ValueMember = "DAA002"; }
/// <summary> /// 编辑数据 /// </summary> /// <param name="model"></param> /// <param name="table"></param> /// <param name="idxList"></param> /// <returns></returns> public bool Edit(MulaolaoLibrary.SanitationCheckHeaderEntity model, DataTable table, List <string> idxList) { Hashtable SQLString = new Hashtable( ); EditHeader(SQLString, model); MulaolaoLibrary.SanitationCheckBodyEntity entity = new MulaolaoLibrary.SanitationCheckBodyEntity( ); entity.SAD001 = model.SAC001; foreach (DataRow row in table.Rows) { entity.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"]); entity.SAD002 = row ["SAD002"].ToString( ); entity.SAD003 = row ["SAD003"].ToString( ); entity.SAD004 = row ["SAD004"].ToString( ); if (row ["SAD005"] == null || row ["SAD005"].ToString( ) == string.Empty) { entity.SAD005 = null; } else { entity.SAD005 = Convert.ToInt32(row ["SAD005"].ToString( )); } if (row ["SAD006"] == null || row ["SAD006"].ToString( ) == string.Empty) { entity.SAD006 = null; } else { entity.SAD006 = Convert.ToInt32(row ["SAD006"].ToString( )); } entity.SAD007 = row ["SAD007"].ToString( ); entity.SAD008 = row ["SAD008"].ToString( ); entity.SAD009 = row ["SAD009"].ToString( ); //if ( row [ "SAD019" ] == null || row [ "SAD019" ] . ToString ( ) == string . Empty ) // entity . SAD019 = null; //else // entity . SAD019 = ( byte? [ ] ) ( row [ "SAD019" ] ); if (entity.idx > 0) { EditBody(SQLString, entity); } else { AddBody(SQLString, entity); } } foreach (string s in idxList) { DeleteBody(SQLString, s); } return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 保存数据 /// </summary> /// <param name="model"></param> /// <param name="table"></param> /// <returns></returns> public bool Save(MulaolaoLibrary.SanitationCheckHeaderEntity model, DataTable table) { Hashtable SQLString = new Hashtable( ); model.SAC001 = getCode( ); AddHeader(SQLString, model); MulaolaoLibrary.SanitationCheckBodyEntity entity = new MulaolaoLibrary.SanitationCheckBodyEntity( ); entity.SAD001 = model.SAC001; foreach (DataRow row in table.Rows) { entity.SAD002 = row ["SAD002"].ToString( ); entity.SAD003 = row ["SAD003"].ToString( ); entity.SAD004 = row ["SAD004"].ToString( ); if (row ["SAD005"] == null || row ["SAD005"].ToString( ) == string.Empty) { entity.SAD005 = null; } else { entity.SAD005 = Convert.ToInt32(row ["SAD005"].ToString( )); } if (row ["SAD006"] == null || row ["SAD006"].ToString( ) == string.Empty) { entity.SAD006 = null; } else { entity.SAD006 = Convert.ToInt32(row ["SAD006"].ToString( )); } entity.SAD007 = row ["SAD007"].ToString( ); entity.SAD008 = row ["SAD008"].ToString( ); entity.SAD009 = row ["SAD009"].ToString( ); //if ( row [ "SAD019" ] == null || row [ "SAD019" ] . ToString ( ) == string . Empty ) // entity . SAD019 = null; //else // entity . SAD019 = ( byte? [ ] ) ( row [ "SAD019" ] ); AddBody(SQLString, entity); } return(SqlHelper.ExecuteSqlTran(SQLString)); }
void AddHeader(Hashtable SQLString, MulaolaoLibrary.SanitationCheckHeaderEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("insert into R_SAC("); strSql.Append("SAC001,SAC002,SAC003,SAC004)"); strSql.Append(" values ("); strSql.Append("@SAC001,@SAC002,@SAC003,@SAC004)"); SqlParameter [] parameters = { new SqlParameter("@SAC001", SqlDbType.NVarChar, 20), new SqlParameter("@SAC002", SqlDbType.NVarChar, 20), new SqlParameter("@SAC003", SqlDbType.Date, 3), new SqlParameter("@SAC004", SqlDbType.Date, 3) }; parameters [0].Value = model.SAC001; parameters [1].Value = model.SAC002; parameters [2].Value = model.SAC003; parameters [3].Value = model.SAC004; SQLString.Add(strSql, parameters); }
void EditHeader(Hashtable SQLString, MulaolaoLibrary.SanitationCheckHeaderEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("update R_SAC set "); strSql.Append("SAC002=@SAC002,"); strSql.Append("SAC003=@SAC003,"); strSql.Append("SAC004=@SAC004 "); strSql.Append("WHERE SAC001=@SAC001"); SqlParameter [] parameters = { new SqlParameter("@SAC001", SqlDbType.NVarChar, 20), new SqlParameter("@SAC002", SqlDbType.NVarChar, 20), new SqlParameter("@SAC003", SqlDbType.Date, 3), new SqlParameter("@SAC004", SqlDbType.Date, 3) }; parameters [0].Value = model.SAC001; parameters [1].Value = model.SAC002; parameters [2].Value = model.SAC003; parameters [3].Value = model.SAC004; SQLString.Add(strSql, parameters); }
/// <summary> /// 编辑数据 /// </summary> /// <param name="model"></param> /// <param name="table"></param> /// <param name="idxList"></param> /// <returns></returns> public bool Edit(MulaolaoLibrary.SanitationCheckHeaderEntity model, DataTable table, List <string> idxList) { return(dal.Edit(model, table, idxList)); }
/// <summary> /// 保存数据 /// </summary> /// <param name="model"></param> /// <param name="table"></param> /// <returns></returns> public bool Save(MulaolaoLibrary.SanitationCheckHeaderEntity model, DataTable table) { return(dal.Save(model, table)); }