public bool Update(RecordsHyperSurveyModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update ARCHIVE_HYPER_SURVEY set "); builder.Append("IDCardNo=@IDCardNo,"); builder.Append("EatPersonSum=@EatPersonSum,"); builder.Append("EatChildSum=@EatChildSum,"); builder.Append("EatSaltQuantity=@EatSaltQuantity,"); builder.Append("EatSoyQuntity=@EatSoyQuntity, "); builder.Append("OutKey=@OutKey "); builder.Append(" where ID=@ID "); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@IDCardNo", MySqlDbType.String, 18), new MySqlParameter("@EatPersonSum", MySqlDbType.Int32), new MySqlParameter("@EatChildSum", MySqlDbType.Int32), new MySqlParameter("@EatSaltQuantity", MySqlDbType.Decimal), new MySqlParameter("@EatSoyQuntity", MySqlDbType.Decimal), new MySqlParameter("@OutKey", MySqlDbType.Int32, 4), new MySqlParameter("@ID", MySqlDbType.Int32, 8) }; cmdParms[0].Value = model.IDCardNo; cmdParms[1].Value = model.EatPersonSum; cmdParms[2].Value = model.EatChildSum; cmdParms[3].Value = model.EatSaltQuantity; cmdParms[4].Value = model.EatSoyQuntity; cmdParms[5].Value = model.OutKey; cmdParms[6].Value = model.ID; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public int Add(RecordsHyperSurveyModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into ARCHIVE_HYPER_SURVEY("); builder.Append("IDCardNo,EatPersonSum,EatChildSum,EatSaltQuantity,EatSoyQuntity,OutKey )"); builder.Append(" values ("); builder.Append("@IDCardNo,@EatPersonSum,@EatChildSum,@EatSaltQuantity,@EatSoyQuntity,@OutKey )"); builder.Append(";select @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@IDCardNo", MySqlDbType.String, 18), new MySqlParameter("@EatPersonSum", MySqlDbType.Int32), new MySqlParameter("@EatChildSum", MySqlDbType.Int32), new MySqlParameter("@EatSaltQuantity", MySqlDbType.Decimal), new MySqlParameter("@EatSoyQuntity", MySqlDbType.Decimal), new MySqlParameter("@OutKey", MySqlDbType.Int32, 4) }; cmdParms[0].Value = model.IDCardNo; cmdParms[1].Value = model.EatPersonSum; cmdParms[2].Value = model.EatChildSum; cmdParms[3].Value = model.EatSaltQuantity; cmdParms[4].Value = model.EatSoyQuntity; cmdParms[5].Value = model.OutKey; object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
public List <RecordsHyperSurveyModel> DataTableToList(DataTable dt) { List <RecordsHyperSurveyModel> list = new List <RecordsHyperSurveyModel>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { RecordsHyperSurveyModel item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public RecordsHyperSurveyModel DataRowToModel(DataRow row) { RecordsHyperSurveyModel HyperSurveyModel = new RecordsHyperSurveyModel(); if (row != null) { if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != "")) { HyperSurveyModel.ID = int.Parse(row["ID"].ToString()); } if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value)) { HyperSurveyModel.IDCardNo = row["IDCardNo"].ToString(); } if (((row["EatPersonSum"] != null) && (row["EatPersonSum"] != DBNull.Value)) && (row["EatPersonSum"].ToString() != "")) { HyperSurveyModel.EatPersonSum = new int?(int.Parse(row["EatPersonSum"].ToString())); } if (((row["EatChildSum"] != null) && (row["EatChildSum"] != DBNull.Value)) && (row["EatChildSum"].ToString() != "")) { HyperSurveyModel.EatChildSum = new int?(int.Parse(row["EatChildSum"].ToString())); } if (((row["EatSaltQuantity"] != null) && (row["EatSaltQuantity"] != DBNull.Value)) && (row["EatSaltQuantity"].ToString() != "")) { HyperSurveyModel.EatSaltQuantity = new decimal?(decimal.Parse(row["EatSaltQuantity"].ToString())); } if (((row["EatSoyQuntity"] != null) && (row["EatSoyQuntity"] != DBNull.Value)) && (row["EatSoyQuntity"].ToString() != "")) { HyperSurveyModel.EatSoyQuntity = new decimal?(decimal.Parse(row["EatSoyQuntity"].ToString())); } if (((row["OutKey"] != null) && (row["OutKey"] != DBNull.Value)) && (row["OutKey"].ToString() != "")) { HyperSurveyModel.OutKey = int.Parse(row["OutKey"].ToString()); } } return(HyperSurveyModel); }
public void InitEveryThing() { this.HyperSurveyModel = new RecordsHyperSurveyBLL().GetModel(PhysicalInfoFactory.ID); this.HyperFoodsModel = new RecordsHyperFoodsBLL().GetModelList(string.Format("IDCardNo = '{0}' and OutKey={1}", this.Model.IDCardNo, PhysicalInfoFactory.ID)); if (this.HyperSurveyModel == null) { HyperSurveyModel = new RecordsHyperSurveyModel(); HyperSurveyModel.IDCardNo = Model.IDCardNo; } this.tbName.Text = Model.CustomerName; this.bindingManagersurvey = new SimpleBindingManager <RecordsHyperSurveyModel>(this.inputRangessurvey, this.inputrange_str, this.HyperSurveyModel); this.bindingManagersurvey.SimpleBindingInt(this.txbPersonSum, "EatPersonSum", true); this.bindingManagersurvey.SimpleBindingInt(this.txbPersonChild, "EatChildSum", true); this.bindingManagersurvey.SimpleBinding(this.txbSalt, "EatSaltQuantity", true); this.bindingManagersurvey.SimpleBinding(this.txbSoy, "EatSoyQuntity", true); for (int k = 0; k < this.foodControl.Count; k++) { if (k < HyperFoodsModel.Count) { switch (HyperFoodsModel[k].FoodName) { case "咸蛋": this.foodControl[0].Source = this.HyperFoodsModel[k]; break; case "咸鱼": this.foodControl[1].Source = this.HyperFoodsModel[k]; break; case "虾皮": this.foodControl[2].Source = this.HyperFoodsModel[k]; break; case "虾米": this.foodControl[3].Source = this.HyperFoodsModel[k]; break; case "方便面": this.foodControl[4].Source = this.HyperFoodsModel[k]; break; case "豆腐乳": this.foodControl[5].Source = this.HyperFoodsModel[k]; break; case "咸菜": this.foodControl[6].Source = this.HyperFoodsModel[k]; break; case "辣椒酱": this.foodControl[7].Source = this.HyperFoodsModel[k]; break; case "虾酱": this.foodControl[8].Source = this.HyperFoodsModel[k]; break; case "甜面酱": this.foodControl[9].Source = this.HyperFoodsModel[k]; break; case "豆瓣酱": this.foodControl[10].Source = this.HyperFoodsModel[k]; break; default: break; } } } for (int k = 0; k < this.foodControl.Count; k++) { if (this.foodControl[k].Source == null) { RecordsHyperFoodsModel recordsHyperFoodsModel = new RecordsHyperFoodsModel { IDCardNo = this.Model.IDCardNo, ModelState = RecordsStateModel.AddToDB }; this.foodControl[k].Source = recordsHyperFoodsModel; } else { this.foodControl[k].Source.ModelState = RecordsStateModel.UpdateInDB; } } this.EveryThingIsOk = true; }
public bool Update(RecordsHyperSurveyModel model) { return(this.dal.Update(model)); }
public int Add(RecordsHyperSurveyModel model) { return(this.dal.Add(model)); }