示例#1
1
 public List<ClientOrder> GetClientOrderByClientId(int clientId)
 {
     List<ClientOrder> result = new List<ClientOrder>();
     SqlParameter[] param = new SqlParameter[] {
         SqlUtilities.GenerateInputIntParameter("@client_id", clientId)
     };
     string sql = "SELECT id, client_id, client_address_id, real_name, phone, email, postcode, address, remark, create_time, country, city, encode FROM client_orders WHERE client_id = @client_id";
     using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
     {
         while (dr.Read())
         {
             ClientOrder co = new ClientOrder();
             co.Id = dr.GetInt32(0);
             co.ClientId = dr.GetInt32(1);
             co.ClientAddressId = dr.GetInt32(2);
             co.RealName = dr.GetString(3);
             co.Phone = dr.GetString(4);
             co.Email = dr.GetString(5);
             co.Postcode = dr.GetString(6);
             co.Address = dr.GetString(7);
             co.Remark = dr.GetString(8);
             co.CreateTime = dr.GetDateTime(9);
             co.Country = dr.GetString(10);
             co.City = dr.GetString(11);
             co.Encode = dr.GetString(12);
             result.Add(co);
         }
     }
     return result;
 }
示例#2
0
 public void CreateClientOrder(ClientOrder co)
 {
     SqlParameter[] param = new SqlParameter[] {
         SqlUtilities.GenerateInputIntParameter("@client_address_id",  co.ClientAddressId),
         SqlUtilities.GenerateInputIntParameter("@client_id", co.ClientId),
         SqlUtilities.GenerateInputNVarcharParameter("@real_name", 50, co.RealName),
         SqlUtilities.GenerateInputNVarcharParameter("@phone", 50, co.Phone),
         SqlUtilities.GenerateInputNVarcharParameter("@email", 50, co.Email),
         SqlUtilities.GenerateInputNVarcharParameter("@postcode", 50, co.Postcode),
         SqlUtilities.GenerateInputNVarcharParameter("@address", 200, co.Address),
         SqlUtilities.GenerateInputNVarcharParameter("@remark", 500, co.Remark),
         SqlUtilities.GenerateInputDateTimeParameter("@create_time", co.CreateTime),
         SqlUtilities.GenerateInputNVarcharParameter("@country", 50, co.Country),
         SqlUtilities.GenerateInputNVarcharParameter("@city", 50, co.City),
         SqlUtilities.GenerateInputNVarcharParameter("@encode", 50, co.Encode)
     };
     string sql = "INSERT INTO client_orders(client_id, client_address_id, real_name, phone, email, postcode, address, remark, create_time, country, city, encode) VALUES(@client_id, @client_address_id, @real_name, @phone, @email, @postcode, @address, @remark, @create_time, @country, @city ,@encode)";
     SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
 }
示例#3
0
        public PaginationQueryResult<ClientOrder> GetClientOrderByParameters(PaginationQueryCondition condition, int clientId, DateTime startDate, DateTime endDate)
        {
            PaginationQueryResult<ClientOrder> result = new PaginationQueryResult<ClientOrder>();

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

            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 (clientId >= 0)
            {
                sqlParam += " AND client_id = @client_id";
            }

            string sql = "SELECT TOP " + condition.PageSize + " id, client_id, client_address_id, real_name, phone, email, postcode, address, remark, create_time, country, city, encode FROM client_orders WHERE 1=1 " + sqlParam;
            if (condition.CurrentPage > 1)
            {
                sql += " AND id <(SELECT MIN(id) FROM (SELECT TOP " + condition.PageSize * (condition.CurrentPage - 1) + " id FROM client_orders WHERE 1=1" + sqlParam + " ORDER BY id DESC) AS O)";
            }
            sql += " ORDER BY id DESC; SELECT COUNT(1) FROM client_orders WHERE 1=1" + sqlParam;

            using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
            {
                while (dr.Read())
                {
                    ClientOrder co = new ClientOrder();
                    co.Id = dr.GetInt32(0);
                    co.ClientId = dr.GetInt32(1);
                    co.ClientAddressId = dr.GetInt32(2);
                    co.RealName = dr.GetString(3);
                    co.Phone = dr.GetString(4);
                    co.Email = dr.GetString(5);
                    co.Postcode = dr.GetString(6);
                    co.Address = dr.GetString(7);
                    co.Remark = dr.GetString(8);
                    co.CreateTime = dr.GetDateTime(9);
                    co.Country = dr.GetString(10);
                    co.City = dr.GetString(11);
                    co.Encode = dr.GetString(12);
                    result.Results.Add(co);
                }
                dr.NextResult();
                while (dr.Read())
                {
                    result.TotalCount = dr.GetInt32(0);
                }
            }

            return result;
        }
示例#4
0
        public List<ClientOrder> GetClientOrderListByParameters(int clientId, DateTime startDate, DateTime endDate)
        {
            List<ClientOrder> result = new List<ClientOrder>();

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

            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 (clientId >= 0)
            {
                sqlParam += " AND client_id = @client_id";
            }

            string sql = "SELECT id, client_id, client_address_id, real_name, phone, email, postcode, address, remark, create_time, country, city, encode FROM client_orders WHERE 1=1" + sqlParam + " ORDER BY create_time ASC";

            using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
            {
                while (dr.Read())
                {
                    ClientOrder co = new ClientOrder();
                    co.Id = dr.GetInt32(0);
                    co.ClientId = dr.GetInt32(1);
                    co.ClientAddressId = dr.GetInt32(2);
                    co.RealName = dr.GetString(3);
                    co.Phone = dr.GetString(4);
                    co.Email = dr.GetString(5);
                    co.Postcode = dr.GetString(6);
                    co.Address = dr.GetString(7);
                    co.Remark = dr.GetString(8);
                    co.CreateTime = dr.GetDateTime(9);
                    co.Country = dr.GetString(10);
                    co.City = dr.GetString(11);
                    co.Encode = dr.GetString(12);
                    //ClientAddress ca = new ClientAddress();
                    //ca = new ClientAddressDAL().GetClientAddressById(co.ClientAddressId);
                    //if (ca != null)
                    //{
                    //    co.PostAddress = ca.Address + ", " + ca.Province;
                    //}
                    //else
                    //{
                    //    co.PostAddress = "";
                    //}
                    Client client = new ClientDAL().GetClientById(co.ClientId);
                    if (client != null)
                    {
                        Company comp = new CompanyDAL().GetCompanyById(client.CompanyId);
                        if (comp != null)
                        {
                            switch (comp.Name)
                            {
                                case "亿度物流宁波总公司":
                                    co.PostAddress = "站前路238 (NB)";
                                    break;
                                case "亿度物流义乌分公司":
                                    co.PostAddress = "站前路238 (YW)";
                                    break;
                                case "亿度物流杭州分公司":
                                    co.PostAddress = "站前路238 (HZ)";
                                    break;
                                case "亿度物流上海分公司":
                                    co.PostAddress = "站前路238 (SH)";
                                    break;
                                case "亿度物流深圳分公司":
                                    co.PostAddress = "站前路238 (SZ)";
                                    break;
                                default:
                                    co.PostAddress = "站前路238";
                                    break;
                            }
                        }
                    }
                    result.Add(co);
                }
            }
            return result;
        }
 public static void CreateClientOrder(ClientOrder co)
 {
     dal.CreateClientOrder(co);
 }
    protected void btnCreate_Click(object sender, EventArgs e)
    {
        //int clientAddressId = 0;
        //if (ddlClientAddress.SelectedItem==null || !int.TryParse(ddlClientAddress.SelectedItem.Value, out clientAddressId))
        //{
        //    lblMsg.Text = "请添加并选择发件人!";
        //    return;
        //}

        string countryName = Request.Form[txtCountry.ID].Trim();
        if (string.IsNullOrEmpty(countryName) || Validator.IsMatchLessThanChineseCharacter(countryName, CONTACT_WAY_LENGTH))
        {
            lblMsg.Text = "收件人国家不能为空,且不能超过" + CONTACT_WAY_LENGTH + "个字符!";
            return;
        }

        string toUsername = Request.Form[txtToUsername.ID].Trim();
        if (string.IsNullOrEmpty(toUsername) || Validator.IsMatchLessThanChineseCharacter(toUsername, CONTACT_WAY_LENGTH))
        {
            lblMsg.Text = "收件人姓名不能为空,且不能超过" + CONTACT_WAY_LENGTH + "个字符!";
            return;
        }
        string toPhone = Request.Form[txtToPhone.ID].Trim();
        if (!string.IsNullOrEmpty(toPhone) && Validator.IsMatchLessThanChineseCharacter(toPhone, CONTACT_WAY_LENGTH))
        {
            lblMsg.Text = "收件人电话不能超过" + CONTACT_WAY_LENGTH + "个字符!";
            return;
        }
        string toEmail = Request.Form[txtToEmail.ID].Trim();
        if (!string.IsNullOrEmpty(toEmail) && Validator.IsMatchLessThanChineseCharacter(toEmail, CONTACT_WAY_LENGTH))
        {
            lblMsg.Text = "收件人邮箱不能超过" + CONTACT_WAY_LENGTH + "个字符!";
            return;
        }
        string toCity = Request.Form[txtToCity.ID].Trim();
        if (!string.IsNullOrEmpty(toCity) && Validator.IsMatchLessThanChineseCharacter(toCity, CONTACT_WAY_LENGTH))
        {
            lblMsg.Text = "收件人城市不能超过" + CONTACT_WAY_LENGTH + "个字符!";
            return;
        }

        string toPostcode = Request.Form[txtToPostcode.ID].Trim();
        if (!string.IsNullOrEmpty(toPostcode) && Validator.IsMatchLessThanChineseCharacter(toPostcode, CONTACT_WAY_LENGTH))
        {
            lblMsg.Text = "收件人邮编不能超过" + CONTACT_WAY_LENGTH + "个字符!";
            return;
        }
        string toAddress = Request.Form[txtToAddress.ID].Trim();
        if (string.IsNullOrEmpty(toAddress) || Validator.IsMatchLessThanChineseCharacter(toAddress, NOTE_ADDRESS_LENGTH))
        {
            lblMsg.Text = "收件人详址不能为空,且长度不能超过" + NOTE_ADDRESS_LENGTH + "个字符!";
            return;
        }
        string remark = Request.Form[txtRemark.ID].Trim();
        if (!string.IsNullOrEmpty(remark) && Validator.IsMatchLessThanChineseCharacter(remark, REMARK_LENGTH))
        {
            lblMsg.Text = "备注长度不能超过" + REMARK_LENGTH + "个字符!";
            return;
        }

        ClientOrder co = new ClientOrder();
        co.Address = toAddress;
        co.ClientAddressId = 0;
        //co.ClientAddressId = int.Parse(ddlClientAddress.SelectedItem.Value);
        co.ClientId = clientSession.Id;
        co.CreateTime = DateTime.Now;
        co.Email = toEmail;
        co.Phone = toPhone;
        co.Postcode = toPostcode;
        co.RealName = toUsername;
        co.Remark = remark;
        co.Country = countryName;
        co.City = toCity;
        co.Encode = StringHelper.GetEncodeNumber("YD");
        ClientOrderOperation.CreateClientOrder(co);

        lblMsg.Text = "添加成功!";

        txtCountry.Value = "";
        txtRemark.Text = "";
        txtToAddress.Value = "";
        txtToCity.Value = "";
        txtToEmail.Value = "";
        txtToPhone.Value = "";
        txtToPostcode.Value = "";
        txtToUsername.Value = "";
    }