void AddBodyOne(Dictionary <object, object> SQLString, LineProductMesEntityu.LEHNewsBodyEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("insert into MIKLEH("); strSql.Append("LEH001,LEH002,LEH003,LEH004,LEH005,LEH006,LEH007,LEH008,LEH009,LEH010)"); strSql.Append(" values ("); strSql.Append("@LEH001,@LEH002,@LEH003,@LEH004,@LEH005,@LEH006,@LEH007,@LEH008,@LEH009,@LEH010)"); SqlParameter [] parameters = { new SqlParameter("@LEH001", SqlDbType.NVarChar, 20), new SqlParameter("@LEH002", SqlDbType.NVarChar, 20), new SqlParameter("@LEH003", SqlDbType.NVarChar, 20), new SqlParameter("@LEH004", SqlDbType.NVarChar, 50), new SqlParameter("@LEH005", SqlDbType.NVarChar, 50), new SqlParameter("@LEH006", SqlDbType.NVarChar, 10), new SqlParameter("@LEH007", SqlDbType.Int, 4), new SqlParameter("@LEH008", SqlDbType.Decimal, 9), new SqlParameter("@LEH009", SqlDbType.Int, 4), new SqlParameter("@LEH010", SqlDbType.NVarChar, 100) }; parameters [0].Value = model.LEH001; parameters [1].Value = model.LEH002; parameters [2].Value = model.LEH003; parameters [3].Value = model.LEH004; parameters [4].Value = model.LEH005; parameters [5].Value = model.LEH006; parameters [6].Value = model.LEH007; parameters [7].Value = model.LEH008; parameters [8].Value = model.LEH009; parameters [9].Value = model.LEH010; SQLString.Add(strSql, parameters); }
void EidtBodyOne(Dictionary <object, object> SQLString, LineProductMesEntityu.LEHNewsBodyEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("update MIKLEH set "); strSql.Append("LEH002=@LEH002,"); strSql.Append("LEH003=@LEH003,"); strSql.Append("LEH004=@LEH004,"); strSql.Append("LEH005=@LEH005,"); strSql.Append("LEH006=@LEH006,"); strSql.Append("LEH007=@LEH007,"); strSql.Append("LEH008=@LEH008,"); strSql.Append("LEH009=@LEH009,"); strSql.Append("LEH010=@LEH010 "); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@LEH002", SqlDbType.NVarChar, 20), new SqlParameter("@LEH003", SqlDbType.NVarChar, 20), new SqlParameter("@LEH004", SqlDbType.NVarChar, 50), new SqlParameter("@LEH005", SqlDbType.NVarChar, 50), new SqlParameter("@LEH006", SqlDbType.NVarChar, 10), new SqlParameter("@LEH007", SqlDbType.Int, 4), new SqlParameter("@LEH008", SqlDbType.Decimal, 9), new SqlParameter("@LEH009", SqlDbType.Int, 4), new SqlParameter("@LEH010", SqlDbType.NVarChar, 50), new SqlParameter("@idx", SqlDbType.Int, 4) }; parameters [0].Value = model.LEH002; parameters [1].Value = model.LEH003; parameters [2].Value = model.LEH004; parameters [3].Value = model.LEH005; parameters [4].Value = model.LEH006; parameters [5].Value = model.LEH007; parameters [6].Value = model.LEH008; parameters [7].Value = model.LEH009; parameters [8].Value = model.LEH010; parameters [9].Value = model.idx; SQLString.Add(strSql, parameters); }
/// <summary> /// 编辑数据 /// </summary> /// <param name="model"></param> /// <param name="tableView"></param> /// <param name="idxList"></param> /// <returns></returns> public bool Edit(LineProductMesEntityu.LEDNewsHeaderEntity model, DataTable tableView, DataTable tableViewTwo, List <string> idxList, List <string> idxListOne) { Dictionary <object, object> SQLString = new Dictionary <object, object> ( ); EditHeader(SQLString, model); LineProductMesEntityu.LEDNewsBodyEntity modelBody = new LineProductMesEntityu.LEDNewsBodyEntity( ); modelBody.LEG001 = model.LEF001; foreach (DataRow row in tableView.Rows) { modelBody.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( )); modelBody.LEG002 = row ["LEG002"].ToString( ); modelBody.LEG003 = row ["LEG003"].ToString( ); modelBody.LEG004 = row ["LEG004"].ToString( ); if (row ["LEG005"] == null || row ["LEG005"].ToString( ) == string.Empty) { modelBody.LEG005 = null; } else { modelBody.LEG005 = Convert.ToDateTime(row ["LEG005"].ToString( )); } if (row ["LEG006"] == null || row ["LEG006"].ToString( ) == string.Empty) { modelBody.LEG006 = null; } else { modelBody.LEG006 = Convert.ToDateTime(row ["LEG006"].ToString( )); } modelBody.LEG007 = string.IsNullOrEmpty(row ["LEG007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG007"].ToString( )); if (row ["LEG008"] == null || row ["LEG008"].ToString( ) == string.Empty) { modelBody.LEG008 = null; } else { modelBody.LEG008 = Convert.ToDateTime(row ["LEG008"].ToString( )); } if (row ["LEG009"] == null || row ["LEG009"].ToString( ) == string.Empty) { modelBody.LEG009 = null; } else { modelBody.LEG009 = Convert.ToDateTime(row ["LEG009"].ToString( )); } modelBody.LEG010 = string.IsNullOrEmpty(row ["LEG010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG010"].ToString( )); modelBody.LEG011 = row ["LEG011"].ToString( ); modelBody.LEG012 = row ["LEG012"].ToString( ); modelBody.LEG013 = row ["LEG013"].ToString( ); modelBody.LEG014 = string.IsNullOrEmpty(row ["LEG014"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG014"].ToString( )); modelBody.LEG015 = string.IsNullOrEmpty(row ["LEG015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG015"].ToString( )); modelBody.LEG016 = string.IsNullOrEmpty(row ["LEG016"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG016"].ToString( )); if (row ["LEG017"] == null || row ["LEG017"].ToString( ) == string.Empty) { modelBody.LEG017 = null; } else { modelBody.LEG017 = Convert.ToDecimal(row ["LEG017"].ToString( )); } if (modelBody.idx < 1) { AddBody(SQLString, modelBody); } else { EditBody(SQLString, modelBody); } } foreach (string s in idxList) { Delete(SQLString, s); } LineProductMesEntityu.LEHNewsBodyEntity body = new LineProductMesEntityu.LEHNewsBodyEntity( ); body.LEH001 = model.LEF001; foreach (DataRow row in tableViewTwo.Rows) { body.LEH002 = row ["LEH002"].ToString( ); body.LEH003 = row ["LEH003"].ToString( ); body.LEH004 = row ["LEH004"].ToString( ); body.LEH005 = row ["LEH005"].ToString( ); body.LEH006 = row ["LEH006"].ToString( ); body.LEH007 = string.IsNullOrEmpty(row ["LEH007"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEH007"].ToString( )); body.LEH008 = string.IsNullOrEmpty(row ["LEH008"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEH008"].ToString( )); body.LEH009 = string.IsNullOrEmpty(row ["LEH009"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEH009"].ToString( )); body.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( )); body.LEH010 = row ["LEH010"].ToString( ); if (body.idx < 1) { AddBodyOne(SQLString, body); } else { EidtBodyOne(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.LEDNewsHeaderEntity model, DataTable tableView, DataTable tableViewTwo) { Dictionary <object, object> SQLString = new Dictionary <object, object> ( ); model.LEF001 = getOddNum( ); model.LEF022 = UserInfoMation.userName; UserInfoMation.oddNum = model.LEF001; AddHeader(SQLString, model); LineProductMesEntityu.LEDNewsBodyEntity modelBody = new LineProductMesEntityu.LEDNewsBodyEntity( ); modelBody.LEG001 = model.LEF001; foreach (DataRow row in tableView.Rows) { modelBody.LEG002 = row ["LEG002"].ToString( ); modelBody.LEG003 = row ["LEG003"].ToString( ); modelBody.LEG004 = row ["LEG004"].ToString( ); if (row ["LEG005"] == null || row ["LEG005"].ToString( ) == string.Empty) { modelBody.LEG005 = null; } else { modelBody.LEG005 = Convert.ToDateTime(row ["LEG005"].ToString( )); } if (row ["LEG006"] == null || row ["LEG006"].ToString( ) == string.Empty) { modelBody.LEG006 = null; } else { modelBody.LEG006 = Convert.ToDateTime(row ["LEG006"].ToString( )); } modelBody.LEG007 = string.IsNullOrEmpty(row ["LEG007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG007"].ToString( )); if (row ["LEG008"] == null || row ["LEG008"].ToString( ) == string.Empty) { modelBody.LEG008 = null; } else { modelBody.LEG008 = Convert.ToDateTime(row ["LEG008"].ToString( )); } if (row ["LEG009"] == null || row ["LEG009"].ToString( ) == string.Empty) { modelBody.LEG009 = null; } else { modelBody.LEG009 = Convert.ToDateTime(row ["LEG009"].ToString( )); } modelBody.LEG010 = string.IsNullOrEmpty(row ["LEG010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG010"].ToString( )); modelBody.LEG011 = row ["LEG011"].ToString( ); modelBody.LEG012 = row ["LEG012"].ToString( ); modelBody.LEG013 = row ["LEG013"].ToString( ); modelBody.LEG014 = string.IsNullOrEmpty(row ["LEG014"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG014"].ToString( )); modelBody.LEG015 = string.IsNullOrEmpty(row ["LEG015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG015"].ToString( )); modelBody.LEG016 = string.IsNullOrEmpty(row ["LEG016"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG016"].ToString( )); if (row ["LEG017"] == null || row ["LEG017"].ToString( ) == string.Empty) { modelBody.LEG017 = null; } else { modelBody.LEG017 = Convert.ToDecimal(row ["LEG017"].ToString( )); } AddBody(SQLString, modelBody); } LineProductMesEntityu.LEHNewsBodyEntity body = new LineProductMesEntityu.LEHNewsBodyEntity( ); body.LEH001 = model.LEF001; foreach (DataRow row in tableViewTwo.Rows) { body.LEH002 = row ["LEH002"].ToString( ); body.LEH003 = row ["LEH003"].ToString( ); body.LEH004 = row ["LEH004"].ToString( ); body.LEH005 = row ["LEH005"].ToString( ); body.LEH006 = row ["LEH006"].ToString( ); body.LEH007 = string.IsNullOrEmpty(row ["LEH007"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEH007"].ToString( )); body.LEH008 = string.IsNullOrEmpty(row ["LEH008"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEH008"].ToString( )); body.LEH009 = string.IsNullOrEmpty(row ["LEH009"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEH009"].ToString( )); body.LEH010 = row ["LEH010"].ToString( ); AddBodyOne(SQLString, body); } return(SqlHelper.ExecuteSqlTranDic(SQLString)); }