/// <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)); }
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)); }