Exemple #1
0
        public Model.MessageShow EditSaveMethod(Model.PlantStockBin data)
        {
            MessageShow msg = new MessageShow();

            if (data.id <= 0)//The current user already exists
            {
                if (this.SqlCount(string.Format("SELECT COUNT(1) FROM plant WHERE plantCode='{0}'", data.numberCode), null) > 0)
                {
                    msg.success = false;
                    msg.message = "此Bin已存在";
                }
                else
                {
                    string insertStr = "INSERT INTO plant(plantCode) VALUES(@numberCode)";
                    msg.success = this.SqlExecute <int>(insertStr, data) > 0;
                    msg.message = msg.success ? "添加成功" : "添加失败";
                }
            }
            else
            {
                msg.success = this.SqlExecute <int>("UPDATE plant SET plantCode=@numberCode WHERE id=@id", data) > 0;
                msg.message = msg.success ? "编辑成功" : "编辑失败";
            }
            return(msg);
        }
Exemple #2
0
 public Model.MessageShow EditSaveMethod(Model.PlantStockBin data)
 {
     return(dal.EditSaveMethod(data));
 }