protected void Page_Load(object sender, EventArgs e)
 {
     int id = 0;
     if (int.TryParse(Request.QueryString["id"], out id))
     {
         sr = ShouldReceiveOperation.GetShouldReceiveById(id);
     }
     FormDataBind();
 }
        public void CreateOrderShouldReceive(ShouldReceive sr)
        {
            SqlParameter[] param = new SqlParameter[] {
                SqlUtilities.GenerateInputIntParameter("@client_id",sr.ClientId),
                SqlUtilities.GenerateInputIntParameter("@order_id", sr.Order.Id),
                SqlUtilities.GenerateInputNVarcharParameter("@type", 50, sr.Type),
                SqlUtilities.GenerateInputParameter("@status", SqlDbType.Bit, sr.Status),
                SqlUtilities.GenerateInputIntParameter("@user_id", sr.UserId),
                SqlUtilities.GenerateInputIntParameter("@company_id", sr.CompanyId),
                SqlUtilities.GenerateInputDateTimeParameter("@create_time", sr.CreateTime),
                SqlUtilities.GenerateInputDateTimeParameter("@receive_time", sr.ReceiveTime),
                SqlUtilities.GenerateInputNVarcharParameter("@encode", 50, sr.Encode),
                SqlUtilities.GenerateInputParameter("@money", SqlDbType.Decimal, sr.Money),
                SqlUtilities.GenerateInputNVarcharParameter("@remark", 500, sr.Remark)
            };

            string sql = "INSERT INTO should_receive(client_id, order_id, type, status, user_id, company_id, create_time, receive_time, encode, money, remark) VALUES(@client_id, @order_id, @type, @status, @user_id, @company_id, @create_time, @receive_time, @encode, @money, @remark)";
            SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
        }
Exemple #3
0
    protected void btnAuditThrough_Click(object sender, EventArgs e)
    {
        btnAuditThrough.Attributes.Add("onclick", "this.disabled=true;");
        Client client = order.Client;
        decimal oldClientBalance = client.Balance;
        decimal clientMoney = client.Balance + client.Credit;
        if (clientMoney < order.Costs)
        {
            lblMsg.Text = "该客户余额不足,不能审核通过!";
            return;
        }

        order.Status = OrderStatus.WAIT_CHECK;
        order.AuditTime = DateTime.Now;
        order.AuditUserId = user.Id;
        order.Reason = "";

        client.Balance = client.Balance - order.Costs;
        ClientOperation.UpdateClientBalance(client);
        OrderOperation.UpdateOrderStatus(order);
        OrderOperation.UpdateOrderAuditInfo(order);
        OrderOperation.UpdateOrderReason(order);

        if (client.Balance >= 0)
        {
            ShouldReceive sr = new ShouldReceive();
            sr.Remark = "";
            sr.Money = order.Costs;
            sr.ReceiveTime = DateTime.Now;
            sr.Type = "订单已收";
            sr.UserId = user.Id;
            sr.ClientId = order.Client.Id;
            sr.CompanyId = user.CompanyId;
            sr.CreateTime = DateTime.Now;
            sr.ReceiveTime = order.CreateTime;
            sr.Order = order;
            sr.Status = true;
            sr.Encode = StringHelper.GetEncodeNumber("SK");
            ShouldReceiveOperation.CreateOrderShouldReceive(sr);
        }
        else
        {
            ShouldReceive sr = new ShouldReceive();
            sr.Remark = "";
            if (oldClientBalance <= 0)
            {
                sr.Money = order.Costs;
            }
            else
            {
                sr.Money = order.Costs - oldClientBalance;

                ShouldReceive sred = new ShouldReceive();
                sred.Remark = "";
                sred.Money = oldClientBalance;
                sred.ReceiveTime = DateTime.Now;
                sred.Type = "订单已收";
                sred.UserId = user.Id;
                sred.ClientId = order.Client.Id;
                sred.CompanyId = user.CompanyId;
                sred.CreateTime = DateTime.Now;
                sred.ReceiveTime = order.ReceiveDate;
                sred.Order = order;
                sred.Status = true;
                sred.Encode = StringHelper.GetEncodeNumber("SK");
                ShouldReceiveOperation.CreateOrderShouldReceive(sred);
            }
            sr.ReceiveTime = DateTime.Now;
            sr.Type = "订单应收";
            sr.UserId = user.Id;
            sr.ClientId = order.Client.Id;
            sr.CompanyId = user.CompanyId;
            sr.CreateTime = DateTime.Now;
            sr.ReceiveTime = order.ReceiveDate;
            sr.Order = order;
            sr.Status = false;
            sr.Encode = StringHelper.GetEncodeNumber("YS");
            ShouldReceiveOperation.CreateOrderShouldReceive(sr);
        }

        decimal arrearageMoney = 0;

        string msg = "操作成功!";
        if (client.Balance < 0)
        {
            if (oldClientBalance <= 0)
            {
                arrearageMoney = order.Costs;
            }
            else
            {
                arrearageMoney = order.Costs - oldClientBalance;
            }
            EmailHelper.SendMailForArrearage(company, client, arrearageMoney, out msg);
        }

        Response.Write("<script language='javascript' type='text/javascript'>alert('" + msg + "');location.href='AuditOrderList.aspx';</script>");
    }
        public void UpdateShouldReceive(ShouldReceive sr)
        {
            SqlParameter[] param = new SqlParameter[] {
                SqlUtilities.GenerateInputIntParameter("@id",sr.Id),
                SqlUtilities.GenerateInputParameter("@money", SqlDbType.Decimal, sr.Money),
                SqlUtilities.GenerateInputParameter("@status", SqlDbType.Bit, sr.Status),
                SqlUtilities.GenerateInputNVarcharParameter("@type", 50, sr.Type),
                SqlUtilities.GenerateInputDateTimeParameter("@receive_time", sr.ReceiveTime),
            };

            string sql = "UPDATE should_receive SET money = @money, status = @status, type = @type, receive_time= @receive_time WHERE id = @id";
            SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
        }
 public ShouldReceive GetShouldReceivedByOrderId(int orderId)
 {
     ShouldReceive sr = null;
     SqlParameter[] param = new SqlParameter[] {
         SqlUtilities.GenerateInputIntParameter("@order_id", orderId)
     };
     string sql = "SELECT id, client_id, type, user_id, company_id, create_time, receive_time, encode, money, remark, order_id, status FROM should_receive WHERE order_id = @order_id AND status = 1";
     using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
     {
         while (dr.Read())
         {
             sr = new ShouldReceive();
             sr.Id = dr.GetInt32(0);
             sr.ClientId = dr.GetInt32(1);
             Client client = ClientOperation.GetClientById(sr.ClientId);
             sr.ClientName = client.RealName;
             sr.Type = dr.GetString(2);
             sr.UserId = dr.GetInt32(3);
             sr.CompanyId = dr.GetInt32(4);
             sr.CreateTime = dr.GetDateTime(5);
             sr.ReceiveTime = dr.GetDateTime(6);
             sr.Encode = dr.GetString(7);
             sr.Money = dr.GetDecimal(8);
             sr.Remark = dr.GetString(9);
             if (!dr.IsDBNull(10))
             {
                 sr.Order = OrderOperation.GetOrderById(dr.GetInt32(10));
             }
             sr.Status = dr.GetBoolean(11);
         }
     }
     return sr;
 }
 public PaginationQueryResult<ShouldReceive> GetShouldReceiveByParameter(PaginationQueryCondition condition, int compId, bool status, DateTime startDate, DateTime endDate)
 {
     SqlParameter[] param = new SqlParameter[] {
         SqlUtilities.GenerateInputIntParameter("@company_id", compId),
         SqlUtilities.GenerateInputParameter("@status", SqlDbType.Bit, status),
         SqlUtilities.GenerateInputDateTimeParameter("@start_date", startDate),
         SqlUtilities.GenerateInputDateTimeParameter("@end_date", endDate)
     };
     DateTime minTime = new DateTime(1999, 1, 1);
     string sqlParam = " AND status = @status AND company_id = @company_id";
     if (startDate > minTime && endDate > minTime)
     {
         sqlParam += " AND create_time BETWEEN @start_date AND @end_date";
     }
     else if (startDate > minTime && endDate <= minTime)
     {
         sqlParam += " AND create_time >= @start_date ";
     }
     else if (startDate <= minTime && endDate > minTime)
     {
         sqlParam += " AND create_time <= @end_date";
     }
     PaginationQueryResult<ShouldReceive> result = new PaginationQueryResult<ShouldReceive>();
     string sql = "SELECT TOP " + condition.PageSize + " id, client_id, type, user_id, company_id, create_time, receive_time, encode, money, remark, order_id, status FROM should_receive WHERE is_delete = 0" + sqlParam;
     if (condition.CurrentPage > 1)
     {
         sql += " AND id< (SELECT MIN(id) FROM (SELECT TOP " + condition.PageSize * (condition.CurrentPage - 1) + " id FROM should_receive  WHERE is_delete = 0 " + sqlParam + " ORDER BY id DESC) AS R )";
     }
     sql += " ORDER BY id DESC; SELECT COUNT(*) FROM should_receive WHERE is_delete = 0 " + sqlParam;
     using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
     {
         while (dr.Read())
         {
             ShouldReceive sr = new ShouldReceive();
             sr.Id = dr.GetInt32(0);
             sr.ClientId = dr.GetInt32(1);
             Client client = ClientOperation.GetClientById(sr.ClientId);
             sr.ClientName = client.RealName;
             sr.Type = dr.GetString(2);
             sr.UserId = dr.GetInt32(3);
             sr.CompanyId = dr.GetInt32(4);
             sr.CreateTime = dr.GetDateTime(5);
             sr.ReceiveTime = dr.GetDateTime(6);
             sr.Encode = dr.GetString(7);
             sr.Money = dr.GetDecimal(8);
             sr.Remark = dr.GetString(9);
             if (!dr.IsDBNull(10))
             {
                 sr.Order = OrderOperation.GetOrderById(dr.GetInt32(10));
             }
             sr.Status = dr.GetBoolean(11);
             result.Results.Add(sr);
         }
         dr.NextResult();
         while (dr.Read())
         {
             result.TotalCount = dr.GetInt32(0);
         }
     }
     return result;
 }
 public static void CreateOrderShouldReceive(ShouldReceive sr)
 {
     dal.CreateOrderShouldReceive(sr);
 }
 public static void UpdateShouldReceive(ShouldReceive sr)
 {
     dal.UpdateShouldReceive(sr);
 }
Exemple #9
0
        public List<ShouldReceive> GetShouldReceiveStatistic(DateTime startDate, DateTime endDate, int companyId, int clientId, int userId)
        {
            List<ShouldReceive> result = new List<ShouldReceive>();

            SqlParameter[] param = new SqlParameter[] {
                SqlUtilities.GenerateInputDateTimeParameter("@start_date", startDate),
                SqlUtilities.GenerateInputDateTimeParameter("@end_date", endDate),
                SqlUtilities.GenerateInputIntParameter("@client_id", clientId),
                SqlUtilities.GenerateInputIntParameter("@company_id", companyId),
                SqlUtilities.GenerateInputIntParameter("@user_id", userId)
            };

            string sqlParam = "";
            DateTime minTime = new DateTime(1999, 1, 1);
            if (startDate > minTime && endDate > minTime)
            {
                sqlParam += " AND create_time BETWEEN @start_date AND @end_date";
            }
            else if (startDate > minTime && endDate <= minTime)
            {
                sqlParam += " AND create_time >= @start_date ";
            }
            else if (startDate <= minTime && endDate > minTime)
            {
                sqlParam += " AND create_time <= @end_date";
            }

            if (companyId > 0)
            {
                sqlParam += " AND company_id = @company_id";
            }
            if (clientId >= 0)
            {
                sqlParam += " AND client_id = @client_id";
            }
            if (userId > 0)
            {
                sqlParam += " AND user_id = @user_id";
            }

            string sql = "SELECT client_id, SUM(money) AS money FROM should_receive WHERE is_delete = 0 AND status = 0 " + sqlParam + " GROUP BY client_id";

            using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
            {
                while (dr.Read())
                {
                    ShouldReceive sr = new ShouldReceive();
                    sr.ClientId = dr.GetInt32(0);
                    sr.Money = dr.GetDecimal(1);
                    result.Add(sr);
                }
            }

            return result;
        }