コード例 #1
0
        /// <summary>
        ///寄件添加
        /// </summary>
        /// <returns></returns>
        public int AddShipp(ShippingInforModel dis)
        {
            string sql = $"insert into ShippingInfo(ShippingOrder,ShippingName,ShippingPhone,ShippingAddress,ReceiveName,ReceivePhone,ReceiveAddress,ShippingRemark,Status,CreateTime,UpdateTime,CreaterId,UpdaterId) values('{dis.ShippingOrder}','{dis.ShippingName}','{dis.ShippingPhone}','{dis.ShippingAddress}','{dis.ReceiveName}','{dis.ReceivePhone}','{dis.ReceiveAddress}','{dis.ShippingRemark}',1,GETDATE(),GETDATE(),1,1)";

            return(DBHelper.ExecuteNonQuery(sql));
        }
コード例 #2
0
        public int ADD(ShippingInforModel m)
        {
            string sql = string.Format("insert into ShippingInfo values('{0}','{1}','{2}',{3}','{4}','{5}','{6}','{7}','{8}')", m.ShippingId, m.ShippingOrder, m.ShippingName, m.ShippingPhone, m.ShippingAddress, m.ReceiveName, m.ReceivePhone, m.ReceiveAddress, m.ShippingRemark);

            return(DBHelper.ExecuteNonQuery(sql));
        }