DAL/DalSend.cs

（开头部分） 9KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using MODEL;
namespace DAL
{
    public class DalSend
    {
        /// <summary>
        /// 增加
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static Boolean AddSend(ModelSend model)
        {
            int i = Dal.SqlHelpers.ExecuteNonQuery(CommandType.Text, "insert into mis_send(EXPRESS_NO,EXPRESS_SENDER,EXPRESS_SENDER_PHONE,EXPRESS_SENDER_ADDRESS,"
                +"EXPRESS_RECIPIENT,EXPRESS_RECIPIENT_ADDRESS,EXPRESS_RECIPIENT_PHONE,EXPRESS_AMOUNT,EXPRESS_WEIGHT,STATUS,DCS,CREATER,EXPRESS_DELIVERY,RECIPIENTS) values('"+model.EXPRESS_NO+"',"
                +"'"+model.EXPRESS_SENDER+"','"+model.EXPRESS_SENDER_PHONE+"','"+model.EXPRESS_SENDER_ADDRESS+"','"+model.EXPRESS_RECIPIENT+"','"+model.EXPRESS_RECIPIENT_ADDRESS+"','"+model.EXPRESS_RECIPIENT_PHONE+"',"
                +"'"+model.EXPRESS_AMOUNT+"','"+model.EXPRESS_WEIGHT+"','"+model.STATUS+"','"+model.DCS+"','"+model.CREATER+"','"+model.EXPRESS_DELIVERY+"','"+model.RECIPIENTS+"')");
            if (i > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static Boolean DeleteSend(ModelSend model)
        {
            int i = Dal.SqlHelpers.ExecuteNonQuery(CommandType.Text,"update mis_send set status=-1 where sid='"+model.SID+"'");
            if (i > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static Boolean ModifySend(ModelSend model)
        {
            int i = Dal.SqlHelpers.ExecuteNonQuery(CommandType.Text, "update mis_send set express_no='" + model.EXPRESS_NO + "',EXPRESS_SENDER='" + model.EXPRESS_SENDER + "',EXPRESS_SENDER_PHONE='" + model.EXPRESS_SENDER_PHONE + "',"
                + "EXPRESS_SENDER_ADDRESS='" + model.EXPRESS_SENDER_ADDRESS + "',EXPRESS_RECIPIENT='" + model.EXPRESS_RECIPIENT + "',EXPRESS_RECIPIENT_ADDRESS='" + model.EXPRESS_RECIPIENT_ADDRESS + "',"
                + "EXPRESS_RECIPIENT_PHONE='" + model.EXPRESS_RECIPIENT_PHONE + "',EXPRESS_AMOUNT='" + model.EXPRESS_AMOUNT + "',EXPRESS_WEIGHT='" + model.EXPRESS_WEIGHT + "',STATUS='" + model.STATUS + "',"
                + "DCS='" + model.DCS + "',CREATER='" + model.CREATER + "',EXPRESS_DELIVERY='" + model.EXPRESS_DELIVERY + "',RECIPIENTS='" + model.RECIPIENTS + "' where sid='" + model.SID + "'");
            if (i > 0)
后面还有 150 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。