/// <summary> /// 得到一个对象实体 /// </summary> public XHD.Model.ecs_sale_parameters GetModel(int sale_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select sale_id,c1,c2,szone,sone,stwo,sthree,sfour,sfive,ssix,zdy,cus_num1,sale_num1,cus_num2,sale_num2,cus_num3,sale_num3,cus_num4,sale_num4,cus_num5,sale_num5,sale_num6,cus_num6,cus_num7,sale_num7,cus_num0,sale_num0,cus_numc1,cus_numc2,sale_numc1,sale_numc2,cus_num1_2,sale_num1_2,cus_num2_2,sale_num2_2,cus_num3_2,sale_num3_2,cus_num4_2,sale_num4_2,cus_num5_2,sale_num5_2,sale_num6_2,cus_num6_2,cus_num0_2,sale_num0_2 from ecs_sale_parameters "); strSql.Append(" where sale_id=@sale_id"); MySqlParameter[] parameters = { new MySqlParameter("@sale_id", MySqlDbType.Int32) }; parameters[0].Value = sale_id; XHD.Model.ecs_sale_parameters model = new XHD.Model.ecs_sale_parameters(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XHD.Model.ecs_sale_parameters DataRowToModel(DataRow row) { XHD.Model.ecs_sale_parameters model = new XHD.Model.ecs_sale_parameters(); if (row != null) { if (row["sale_id"] != null && row["sale_id"].ToString() != "") { model.sale_id = int.Parse(row["sale_id"].ToString()); } if (row["c1"] != null && row["c1"].ToString() != "") { model.c1 = int.Parse(row["c1"].ToString()); } if (row["c2"] != null && row["c2"].ToString() != "") { model.c2 = int.Parse(row["c2"].ToString()); } if (row["szone"] != null && row["szone"].ToString() != "") { model.szone = int.Parse(row["szone"].ToString()); } if (row["sone"] != null && row["sone"].ToString() != "") { model.sone = int.Parse(row["sone"].ToString()); } if (row["stwo"] != null && row["stwo"].ToString() != "") { model.stwo = int.Parse(row["stwo"].ToString()); } if (row["sthree"] != null && row["sthree"].ToString() != "") { model.sthree = int.Parse(row["sthree"].ToString()); } if (row["sfour"] != null && row["sfour"].ToString() != "") { model.sfour = int.Parse(row["sfour"].ToString()); } if (row["sfive"] != null && row["sfive"].ToString() != "") { model.sfive = int.Parse(row["sfive"].ToString()); } if (row["ssix"] != null && row["ssix"].ToString() != "") { model.ssix = int.Parse(row["ssix"].ToString()); } if (row["zdy"] != null && row["zdy"].ToString() != "") { model.zdy = int.Parse(row["zdy"].ToString()); } if (row["cus_num1"] != null && row["cus_num1"].ToString() != "") { model.cus_num1 = int.Parse(row["cus_num1"].ToString()); } if (row["sale_num1"] != null && row["sale_num1"].ToString() != "") { model.sale_num1 = int.Parse(row["sale_num1"].ToString()); } if (row["cus_num2"] != null && row["cus_num2"].ToString() != "") { model.cus_num2 = int.Parse(row["cus_num2"].ToString()); } if (row["sale_num2"] != null && row["sale_num2"].ToString() != "") { model.sale_num2 = int.Parse(row["sale_num2"].ToString()); } if (row["cus_num3"] != null && row["cus_num3"].ToString() != "") { model.cus_num3 = int.Parse(row["cus_num3"].ToString()); } if (row["sale_num3"] != null && row["sale_num3"].ToString() != "") { model.sale_num3 = int.Parse(row["sale_num3"].ToString()); } if (row["cus_num4"] != null && row["cus_num4"].ToString() != "") { model.cus_num4 = int.Parse(row["cus_num4"].ToString()); } if (row["sale_num4"] != null && row["sale_num4"].ToString() != "") { model.sale_num4 = int.Parse(row["sale_num4"].ToString()); } if (row["cus_num5"] != null && row["cus_num5"].ToString() != "") { model.cus_num5 = int.Parse(row["cus_num5"].ToString()); } if (row["sale_num5"] != null && row["sale_num5"].ToString() != "") { model.sale_num5 = int.Parse(row["sale_num5"].ToString()); } if (row["sale_num6"] != null && row["sale_num6"].ToString() != "") { model.sale_num6 = int.Parse(row["sale_num6"].ToString()); } if (row["cus_num6"] != null && row["cus_num6"].ToString() != "") { model.cus_num6 = int.Parse(row["cus_num6"].ToString()); } if (row["cus_num7"] != null && row["cus_num7"].ToString() != "") { model.cus_num7 = int.Parse(row["cus_num7"].ToString()); } if (row["sale_num7"] != null && row["sale_num7"].ToString() != "") { model.sale_num7 = int.Parse(row["sale_num7"].ToString()); } if (row["cus_num0"] != null && row["cus_num0"].ToString() != "") { model.cus_num0 = int.Parse(row["cus_num0"].ToString()); } if (row["sale_num0"] != null && row["sale_num0"].ToString() != "") { model.sale_num0 = int.Parse(row["sale_num0"].ToString()); } if (row["cus_numc1"] != null && row["cus_numc1"].ToString() != "") { model.cus_numc1 = int.Parse(row["cus_numc1"].ToString()); } if (row["cus_numc2"] != null && row["cus_numc2"].ToString() != "") { model.cus_numc2 = int.Parse(row["cus_numc2"].ToString()); } if (row["sale_numc1"] != null && row["sale_numc1"].ToString() != "") { model.sale_numc1 = int.Parse(row["sale_numc1"].ToString()); } if (row["sale_numc2"] != null && row["sale_numc2"].ToString() != "") { model.sale_numc2 = int.Parse(row["sale_numc2"].ToString()); } if (row["cus_num1_2"] != null && row["cus_num1_2"].ToString() != "") { model.cus_num1_2 = int.Parse(row["cus_num1_2"].ToString()); } if (row["sale_num1_2"] != null && row["sale_num1_2"].ToString() != "") { model.sale_num1_2 = int.Parse(row["sale_num1_2"].ToString()); } if (row["cus_num2_2"] != null && row["cus_num2_2"].ToString() != "") { model.cus_num2_2 = int.Parse(row["cus_num2_2"].ToString()); } if (row["sale_num2_2"] != null && row["sale_num2_2"].ToString() != "") { model.sale_num2_2 = int.Parse(row["sale_num2_2"].ToString()); } if (row["cus_num3_2"] != null && row["cus_num3_2"].ToString() != "") { model.cus_num3_2 = int.Parse(row["cus_num3_2"].ToString()); } if (row["sale_num3_2"] != null && row["sale_num3_2"].ToString() != "") { model.sale_num3_2 = int.Parse(row["sale_num3_2"].ToString()); } if (row["cus_num4_2"] != null && row["cus_num4_2"].ToString() != "") { model.cus_num4_2 = int.Parse(row["cus_num4_2"].ToString()); } if (row["sale_num4_2"] != null && row["sale_num4_2"].ToString() != "") { model.sale_num4_2 = int.Parse(row["sale_num4_2"].ToString()); } if (row["cus_num5_2"] != null && row["cus_num5_2"].ToString() != "") { model.cus_num5_2 = int.Parse(row["cus_num5_2"].ToString()); } if (row["sale_num5_2"] != null && row["sale_num5_2"].ToString() != "") { model.sale_num5_2 = int.Parse(row["sale_num5_2"].ToString()); } if (row["sale_num6_2"] != null && row["sale_num6_2"].ToString() != "") { model.sale_num6_2 = int.Parse(row["sale_num6_2"].ToString()); } if (row["cus_num6_2"] != null && row["cus_num6_2"].ToString() != "") { model.cus_num6_2 = int.Parse(row["cus_num6_2"].ToString()); } if (row["cus_num0_2"] != null && row["cus_num0_2"].ToString() != "") { model.cus_num0_2 = int.Parse(row["cus_num0_2"].ToString()); } if (row["sale_num0_2"] != null && row["sale_num0_2"].ToString() != "") { model.sale_num0_2 = int.Parse(row["sale_num0_2"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(XHD.Model.ecs_sale_parameters model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ecs_sale_parameters("); strSql.Append("c1,c2,szone,sone,stwo,sthree,sfour,sfive,ssix,zdy,cus_num1,sale_num1,cus_num2,sale_num2,cus_num3,sale_num3,cus_num4,sale_num4,cus_num5,sale_num5,sale_num6,cus_num6,cus_num7,sale_num7,cus_num0,sale_num0,cus_numc1,cus_numc2,sale_numc1,sale_numc2,cus_num1_2,sale_num1_2,cus_num2_2,sale_num2_2,cus_num3_2,sale_num3_2,cus_num4_2,sale_num4_2,cus_num5_2,sale_num5_2,sale_num6_2,cus_num6_2,cus_num0_2,sale_num0_2)"); strSql.Append(" values ("); strSql.Append("@c1,@c2,@szone,@sone,@stwo,@sthree,@sfour,@sfive,@ssix,@zdy,@cus_num1,@sale_num1,@cus_num2,@sale_num2,@cus_num3,@sale_num3,@cus_num4,@sale_num4,@cus_num5,@sale_num5,@sale_num6,@cus_num6,@cus_num7,@sale_num7,@cus_num0,@sale_num0,@cus_numc1,@cus_numc2,@sale_numc1,@sale_numc2,@cus_num1_2,@sale_num1_2,@cus_num2_2,@sale_num2_2,@cus_num3_2,@sale_num3_2,@cus_num4_2,@sale_num4_2,@cus_num5_2,@sale_num5_2,@sale_num6_2,@cus_num6_2,@cus_num0_2,@sale_num0_2)"); MySqlParameter[] parameters = { new MySqlParameter("@c1", MySqlDbType.Int32, 10), new MySqlParameter("@c2", MySqlDbType.Int32, 10), new MySqlParameter("@szone", MySqlDbType.Int32, 10), new MySqlParameter("@sone", MySqlDbType.Int32, 10), new MySqlParameter("@stwo", MySqlDbType.Int32, 10), new MySqlParameter("@sthree", MySqlDbType.Int32, 10), new MySqlParameter("@sfour", MySqlDbType.Int32, 10), new MySqlParameter("@sfive", MySqlDbType.Int32, 10), new MySqlParameter("@ssix", MySqlDbType.Int32, 10), new MySqlParameter("@zdy", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num1", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num1", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num3", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num3", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num4", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num4", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num5", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num5", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num6", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num6", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num7", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num7", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num0", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num0", MySqlDbType.Int32, 10), new MySqlParameter("@cus_numc1", MySqlDbType.Int32, 10), new MySqlParameter("@cus_numc2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_numc1", MySqlDbType.Int32, 10), new MySqlParameter("@sale_numc2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num1_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num1_2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num2_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num2_2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num3_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num3_2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num4_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num4_2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num5_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num5_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num6_2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num6_2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num0_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num0_2", MySqlDbType.Int32, 10) }; parameters[0].Value = model.c1; parameters[1].Value = model.c2; parameters[2].Value = model.szone; parameters[3].Value = model.sone; parameters[4].Value = model.stwo; parameters[5].Value = model.sthree; parameters[6].Value = model.sfour; parameters[7].Value = model.sfive; parameters[8].Value = model.ssix; parameters[9].Value = model.zdy; parameters[10].Value = model.cus_num1; parameters[11].Value = model.sale_num1; parameters[12].Value = model.cus_num2; parameters[13].Value = model.sale_num2; parameters[14].Value = model.cus_num3; parameters[15].Value = model.sale_num3; parameters[16].Value = model.cus_num4; parameters[17].Value = model.sale_num4; parameters[18].Value = model.cus_num5; parameters[19].Value = model.sale_num5; parameters[20].Value = model.sale_num6; parameters[21].Value = model.cus_num6; parameters[22].Value = model.cus_num7; parameters[23].Value = model.sale_num7; parameters[24].Value = model.cus_num0; parameters[25].Value = model.sale_num0; parameters[26].Value = model.cus_numc1; parameters[27].Value = model.cus_numc2; parameters[28].Value = model.sale_numc1; parameters[29].Value = model.sale_numc2; parameters[30].Value = model.cus_num1_2; parameters[31].Value = model.sale_num1_2; parameters[32].Value = model.cus_num2_2; parameters[33].Value = model.sale_num2_2; parameters[34].Value = model.cus_num3_2; parameters[35].Value = model.sale_num3_2; parameters[36].Value = model.cus_num4_2; parameters[37].Value = model.sale_num4_2; parameters[38].Value = model.cus_num5_2; parameters[39].Value = model.sale_num5_2; parameters[40].Value = model.sale_num6_2; parameters[41].Value = model.cus_num6_2; parameters[42].Value = model.cus_num0_2; parameters[43].Value = model.sale_num0_2; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XHD.Model.ecs_sale_parameters model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ecs_sale_parameters set "); strSql.Append("c1=@c1,"); strSql.Append("c2=@c2,"); strSql.Append("szone=@szone,"); strSql.Append("sone=@sone,"); strSql.Append("stwo=@stwo,"); strSql.Append("sthree=@sthree,"); strSql.Append("sfour=@sfour,"); strSql.Append("sfive=@sfive,"); strSql.Append("ssix=@ssix,"); strSql.Append("zdy=@zdy,"); strSql.Append("cus_num1=@cus_num1,"); strSql.Append("sale_num1=@sale_num1,"); strSql.Append("cus_num2=@cus_num2,"); strSql.Append("sale_num2=@sale_num2,"); strSql.Append("cus_num3=@cus_num3,"); strSql.Append("sale_num3=@sale_num3,"); strSql.Append("cus_num4=@cus_num4,"); strSql.Append("sale_num4=@sale_num4,"); strSql.Append("cus_num5=@cus_num5,"); strSql.Append("sale_num5=@sale_num5,"); strSql.Append("sale_num6=@sale_num6,"); strSql.Append("cus_num6=@cus_num6,"); strSql.Append("cus_num7=@cus_num7,"); strSql.Append("sale_num7=@sale_num7,"); strSql.Append("cus_num0=@cus_num0,"); strSql.Append("sale_num0=@sale_num0,"); strSql.Append("cus_numc1=@cus_numc1,"); strSql.Append("cus_numc2=@cus_numc2,"); strSql.Append("sale_numc1=@sale_numc1,"); strSql.Append("sale_numc2=@sale_numc2,"); strSql.Append("cus_num1_2=@cus_num1_2,"); strSql.Append("sale_num1_2=@sale_num1_2,"); strSql.Append("cus_num2_2=@cus_num2_2,"); strSql.Append("sale_num2_2=@sale_num2_2,"); strSql.Append("cus_num3_2=@cus_num3_2,"); strSql.Append("sale_num3_2=@sale_num3_2,"); strSql.Append("cus_num4_2=@cus_num4_2,"); strSql.Append("sale_num4_2=@sale_num4_2,"); strSql.Append("cus_num5_2=@cus_num5_2,"); strSql.Append("sale_num5_2=@sale_num5_2,"); strSql.Append("sale_num6_2=@sale_num6_2,"); strSql.Append("cus_num6_2=@cus_num6_2,"); strSql.Append("cus_num0_2=@cus_num0_2,"); strSql.Append("sale_num0_2=@sale_num0_2"); strSql.Append(" where sale_id=@sale_id"); MySqlParameter[] parameters = { new MySqlParameter("@c1", MySqlDbType.Int32, 10), new MySqlParameter("@c2", MySqlDbType.Int32, 10), new MySqlParameter("@szone", MySqlDbType.Int32, 10), new MySqlParameter("@sone", MySqlDbType.Int32, 10), new MySqlParameter("@stwo", MySqlDbType.Int32, 10), new MySqlParameter("@sthree", MySqlDbType.Int32, 10), new MySqlParameter("@sfour", MySqlDbType.Int32, 10), new MySqlParameter("@sfive", MySqlDbType.Int32, 10), new MySqlParameter("@ssix", MySqlDbType.Int32, 10), new MySqlParameter("@zdy", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num1", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num1", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num3", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num3", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num4", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num4", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num5", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num5", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num6", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num6", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num7", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num7", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num0", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num0", MySqlDbType.Int32, 10), new MySqlParameter("@cus_numc1", MySqlDbType.Int32, 10), new MySqlParameter("@cus_numc2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_numc1", MySqlDbType.Int32, 10), new MySqlParameter("@sale_numc2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num1_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num1_2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num2_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num2_2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num3_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num3_2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num4_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num4_2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num5_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num5_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num6_2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num6_2", MySqlDbType.Int32, 10), new MySqlParameter("@cus_num0_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_num0_2", MySqlDbType.Int32, 10), new MySqlParameter("@sale_id", MySqlDbType.Int32, 10) }; parameters[0].Value = model.c1; parameters[1].Value = model.c2; parameters[2].Value = model.szone; parameters[3].Value = model.sone; parameters[4].Value = model.stwo; parameters[5].Value = model.sthree; parameters[6].Value = model.sfour; parameters[7].Value = model.sfive; parameters[8].Value = model.ssix; parameters[9].Value = model.zdy; parameters[10].Value = model.cus_num1; parameters[11].Value = model.sale_num1; parameters[12].Value = model.cus_num2; parameters[13].Value = model.sale_num2; parameters[14].Value = model.cus_num3; parameters[15].Value = model.sale_num3; parameters[16].Value = model.cus_num4; parameters[17].Value = model.sale_num4; parameters[18].Value = model.cus_num5; parameters[19].Value = model.sale_num5; parameters[20].Value = model.sale_num6; parameters[21].Value = model.cus_num6; parameters[22].Value = model.cus_num7; parameters[23].Value = model.sale_num7; parameters[24].Value = model.cus_num0; parameters[25].Value = model.sale_num0; parameters[26].Value = model.cus_numc1; parameters[27].Value = model.cus_numc2; parameters[28].Value = model.sale_numc1; parameters[29].Value = model.sale_numc2; parameters[30].Value = model.cus_num1_2; parameters[31].Value = model.sale_num1_2; parameters[32].Value = model.cus_num2_2; parameters[33].Value = model.sale_num2_2; parameters[34].Value = model.cus_num3_2; parameters[35].Value = model.sale_num3_2; parameters[36].Value = model.cus_num4_2; parameters[37].Value = model.sale_num4_2; parameters[38].Value = model.cus_num5_2; parameters[39].Value = model.sale_num5_2; parameters[40].Value = model.sale_num6_2; parameters[41].Value = model.cus_num6_2; parameters[42].Value = model.cus_num0_2; parameters[43].Value = model.sale_num0_2; parameters[44].Value = model.sale_id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }