void EditBody(Dictionary <object, object> SQLString, LineProductMesEntityu.LEDNewsPaperBodyEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("update MIKLED set "); strSql.Append("LED002=@LED002,"); strSql.Append("LED003=@LED003,"); strSql.Append("LED004=@LED004,"); strSql.Append("LED005=@LED005,"); strSql.Append("LED006=@LED006,"); strSql.Append("LED007=@LED007,"); strSql.Append("LED008=@LED008,"); strSql.Append("LED009=@LED009,"); strSql.Append("LED010=@LED010,"); strSql.Append("LED011=@LED011,"); strSql.Append("LED012=@LED012,"); strSql.Append("LED013=@LED013,"); strSql.Append("LED014=@LED014,"); strSql.Append("LED015=@LED015,"); strSql.Append("LED016=@LED016 "); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@LED003", SqlDbType.NVarChar, 20), new SqlParameter("@LED004", SqlDbType.NVarChar, 20), new SqlParameter("@LED005", SqlDbType.DateTime), new SqlParameter("@LED006", SqlDbType.DateTime), new SqlParameter("@LED007", SqlDbType.Decimal, 9), new SqlParameter("@LED008", SqlDbType.DateTime), new SqlParameter("@LED009", SqlDbType.DateTime), new SqlParameter("@LED010", SqlDbType.Decimal, 9), new SqlParameter("@LED011", SqlDbType.NVarChar, 100), new SqlParameter("@LED012", SqlDbType.NVarChar, 5), new SqlParameter("@idx", SqlDbType.Int, 4), new SqlParameter("@LED002", SqlDbType.NVarChar, 20), new SqlParameter("@LED013", SqlDbType.NVarChar, 20), new SqlParameter("@LED014", SqlDbType.Decimal), new SqlParameter("@LED015", SqlDbType.Decimal), new SqlParameter("@LED016", SqlDbType.Decimal) }; parameters [0].Value = model.LED003; parameters [1].Value = model.LED004; parameters [2].Value = model.LED005; parameters [3].Value = model.LED006; parameters [4].Value = model.LED007; parameters [5].Value = model.LED008; parameters [6].Value = model.LED009; parameters [7].Value = model.LED010; parameters [8].Value = model.LED011; parameters [9].Value = model.LED012; parameters [10].Value = model.idx; parameters [11].Value = model.LED002; parameters [12].Value = model.LED013; parameters [13].Value = model.LED014; parameters [14].Value = model.LED015; parameters [15].Value = model.LED016; SQLString.Add(strSql, parameters); }
void AddBody(Dictionary <object, object> SQLString, LineProductMesEntityu.LEDNewsPaperBodyEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("insert into MIKLED("); strSql.Append("LED001,LED002,LED003,LED004,LED005,LED006,LED007,LED008,LED009,LED010,LED011,LED012,LED013,LED014,LED015,LED016)"); strSql.Append(" values ("); strSql.Append("@LED001,@LED002,@LED003,@LED004,@LED005,@LED006,@LED007,@LED008,@LED009,@LED010,@LED011,@LED012,@LED013,@LED014,@LED015,@LED016)"); SqlParameter [] parameters = { new SqlParameter("@LED001", SqlDbType.NVarChar, 20), new SqlParameter("@LED002", SqlDbType.NVarChar, 20), new SqlParameter("@LED003", SqlDbType.NVarChar, 20), new SqlParameter("@LED004", SqlDbType.NVarChar, 20), new SqlParameter("@LED005", SqlDbType.DateTime), new SqlParameter("@LED006", SqlDbType.DateTime), new SqlParameter("@LED007", SqlDbType.Decimal, 9), new SqlParameter("@LED008", SqlDbType.DateTime), new SqlParameter("@LED009", SqlDbType.DateTime), new SqlParameter("@LED010", SqlDbType.Decimal, 9), new SqlParameter("@LED011", SqlDbType.NVarChar, 100), new SqlParameter("@LED012", SqlDbType.NVarChar, 5), new SqlParameter("@LED013", SqlDbType.NVarChar, 20), new SqlParameter("@LED014", SqlDbType.Decimal, 9), new SqlParameter("@LED015", SqlDbType.Decimal, 9), new SqlParameter("@LED016", SqlDbType.Decimal, 9) }; parameters [0].Value = model.LED001; parameters [1].Value = model.LED002; parameters [2].Value = model.LED003; parameters [3].Value = model.LED004; parameters [4].Value = model.LED005; parameters [5].Value = model.LED006; parameters [6].Value = model.LED007; parameters [7].Value = model.LED008; parameters [8].Value = model.LED009; parameters [9].Value = model.LED010; parameters [10].Value = model.LED011; parameters [11].Value = model.LED012; parameters [12].Value = model.LED013; parameters [13].Value = model.LED014; parameters [14].Value = model.LED015; parameters [15].Value = model.LED016; SQLString.Add(strSql, parameters); }
/// <summary> /// 编辑数据 /// </summary> /// <param name="model"></param> /// <param name="tableView"></param> /// <param name="idxList"></param> /// <returns></returns> public bool Edit(LineProductMesEntityu.LEDNewsPaperHeaderEntity model, DataTable tableView, DataTable tableViewOne, List <string> idxList, List <string> idxListOne) { Dictionary <object, object> SQLString = new Dictionary <object, object> ( ); EditHeader(SQLString, model); LineProductMesEntityu.LEDNewsPaperBodyEntity modelBody = new LineProductMesEntityu.LEDNewsPaperBodyEntity( ); modelBody.LED001 = model.LEC001; foreach (DataRow row in tableView.Rows) { modelBody.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( )); modelBody.LED002 = row ["LED002"].ToString( ); modelBody.LED003 = row ["LED003"].ToString( ); modelBody.LED004 = row ["LED004"].ToString( ); if (row ["LED005"] == null || row ["LED005"].ToString( ) == string.Empty) { modelBody.LED005 = null; } else { modelBody.LED005 = Convert.ToDateTime(row ["LED005"].ToString( )); } if (row ["LED006"] == null || row ["LED006"].ToString( ) == string.Empty) { modelBody.LED006 = null; } else { modelBody.LED006 = Convert.ToDateTime(row ["LED006"].ToString( )); } modelBody.LED007 = string.IsNullOrEmpty(row ["LED007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED007"].ToString( )); if (row ["LED008"] == null || row ["LED008"].ToString( ) == string.Empty) { modelBody.LED008 = null; } else { modelBody.LED008 = Convert.ToDateTime(row ["LED008"].ToString( )); } if (row ["LED009"] == null || row ["LED009"].ToString( ) == string.Empty) { modelBody.LED009 = null; } else { modelBody.LED009 = Convert.ToDateTime(row ["LED009"].ToString( )); } modelBody.LED010 = string.IsNullOrEmpty(row ["LED010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED010"].ToString( )); modelBody.LED011 = row ["LED011"].ToString( ); modelBody.LED012 = row ["LED012"].ToString( ); modelBody.LED013 = row ["LED013"].ToString( ); modelBody.LED014 = string.IsNullOrEmpty(row ["LED014"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED014"].ToString( )); modelBody.LED015 = string.IsNullOrEmpty(row ["LED015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED015"].ToString( )); modelBody.LED016 = string.IsNullOrEmpty(row ["LED016"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED016"].ToString( )); if (modelBody.idx < 1) { AddBody(SQLString, modelBody); } else { EditBody(SQLString, modelBody); } } foreach (string s in idxList) { Delete(SQLString, s); } LineProductMesEntityu.LEENewsPaperBodyEntity body = new LineProductMesEntityu.LEENewsPaperBodyEntity( ); body.LEE001 = model.LEC001; foreach (DataRow row in tableViewOne.Rows) { body.LEE002 = row ["LEE002"].ToString( ); body.LEE003 = row ["LEE003"].ToString( ); body.LEE004 = row ["LEE004"].ToString( ); body.LEE005 = row ["LEE005"].ToString( ); body.LEE006 = row ["LEE006"].ToString( ); body.LEE007 = string.IsNullOrEmpty(row ["LEE007"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEE007"].ToString( )); body.LEE008 = string.IsNullOrEmpty(row ["LEE008"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEE008"].ToString( )); body.LEE009 = string.IsNullOrEmpty(row ["LEE009"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEE009"].ToString( )); body.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( )); if (body.idx < 1) { AddBodyOne(SQLString, body); } else { EditBodyOne(SQLString, body); } } foreach (string s in idxListOne) { DeleteOne(SQLString, s); } return(SqlHelper.ExecuteSqlTranDic(SQLString)); }
/// <summary> /// 新增数据 /// </summary> /// <param name="model"></param> /// <param name="tableView"></param> /// <returns></returns> public bool Save(LineProductMesEntityu.LEDNewsPaperHeaderEntity model, DataTable tableView, DataTable tableViewOne) { Dictionary <object, object> SQLString = new Dictionary <object, object> ( ); model.LEC001 = getOddNum( ); UserInfoMation.oddNum = model.LEC001; model.LEC022 = UserInfoMation.userName; AddHeader(SQLString, model); LineProductMesEntityu.LEDNewsPaperBodyEntity modelBody = new LineProductMesEntityu.LEDNewsPaperBodyEntity( ); modelBody.LED001 = model.LEC001; foreach (DataRow row in tableView.Rows) { modelBody.LED002 = row ["LED002"].ToString( ); modelBody.LED003 = row ["LED003"].ToString( ); modelBody.LED004 = row ["LED004"].ToString( ); if (row ["LED005"] == null || row ["LED005"].ToString( ) == string.Empty) { modelBody.LED005 = null; } else { modelBody.LED005 = Convert.ToDateTime(row ["LED005"].ToString( )); } if (row ["LED006"] == null || row ["LED006"].ToString( ) == string.Empty) { modelBody.LED006 = null; } else { modelBody.LED006 = Convert.ToDateTime(row ["LED006"].ToString( )); } modelBody.LED007 = string.IsNullOrEmpty(row ["LED007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED007"].ToString( )); if (row ["LED008"] == null || row ["LED008"].ToString( ) == string.Empty) { modelBody.LED008 = null; } else { modelBody.LED008 = Convert.ToDateTime(row ["LED008"].ToString( )); } if (row ["LED009"] == null || row ["LED009"].ToString( ) == string.Empty) { modelBody.LED009 = null; } else { modelBody.LED009 = Convert.ToDateTime(row ["LED009"].ToString( )); } modelBody.LED010 = string.IsNullOrEmpty(row ["LED010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED010"].ToString( )); modelBody.LED011 = row ["LED011"].ToString( ); modelBody.LED012 = row ["LED012"].ToString( ); modelBody.LED013 = row ["LED013"].ToString( ); modelBody.LED014 = string.IsNullOrEmpty(row ["LED014"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED014"].ToString( )); modelBody.LED015 = string.IsNullOrEmpty(row ["LED015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED015"].ToString( )); modelBody.LED016 = string.IsNullOrEmpty(row ["LED016"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED016"].ToString( )); AddBody(SQLString, modelBody); } LineProductMesEntityu.LEENewsPaperBodyEntity body = new LineProductMesEntityu.LEENewsPaperBodyEntity( ); body.LEE001 = model.LEC001; foreach (DataRow row in tableViewOne.Rows) { body.LEE002 = row ["LEE002"].ToString( ); body.LEE003 = row ["LEE003"].ToString( ); body.LEE004 = row ["LEE004"].ToString( ); body.LEE005 = row ["LEE005"].ToString( ); body.LEE006 = row ["LEE006"].ToString( ); body.LEE007 = string.IsNullOrEmpty(row ["LEE007"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEE007"].ToString( )); body.LEE008 = string.IsNullOrEmpty(row ["LEE008"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEE008"].ToString( )); body.LEE009 = string.IsNullOrEmpty(row ["LEE009"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEE009"].ToString( )); AddBodyOne(SQLString, body); } return(SqlHelper.ExecuteSqlTranDic(SQLString)); }