Esempio n. 1
0
        public int CWarehouseUpt(Model.CWarehouse Model)
        {
            string sql = $"update CWarehouse set WMid={Model.WMid},WModd='{Model.WModd}',WMWname='{Model.WMWname}',WMGpic='{Model.WMGpic}',WMGname='{Model.WMGname}',WMGsize='{Model.WMGsize}',WMGodd='{Model.WMGodd}',WMnum='{Model.WMnum}',WMtime='{Model.WMtime}'";
            int    i   = DapperHelper.Execute(sql);

            return(i);
        }
Esempio n. 2
0
        public int CWarehouseAdd(Model.CWarehouse Model)
        {
            string sql = $"insert into CWarehouse values({Model.WMid},'{Model.WModd}','{Model.WMWname}','{Model.WMGpic}','{Model.WMGname}','{Model.WMGsize}','{Model.WMGodd}','{Model.WMnum}','{Model.WMtime}')";

            return(DapperHelper.Add(sql));
        }