protected void btnCreate_Click(object sender, EventArgs e)
{
string clientName = Request.Form[txtClientName.ID].Trim();
if (string.IsNullOrEmpty(clientName) || clientName == "请输入客户姓名拼音的首字母" || Validator.IsMatchLessThanChineseCharacter(clientName, CLIENT_NAME_LENGTH))
{
lblMsg.Text = "客户姓名不能为空，且长度不能超过" + CLIENT_NAME_LENGTH + "个字符！";
return;
}
Client client = ClientOperation.GetClientByRealName(clientName);
if (client == null)
{
lblMsg.Text = "客户不存在！";
return;
}
string phone = Request.Form[txtPhone.ID].Trim();
string address = Request.Form[txtFetchAddress.ID].Trim();
string strDate = Request.Form[txtFetchTime.ID].Trim();
string strHour = slHour.Value;
string strMinute = slMinute.Value;
string remark = Request.Form[txtRemark.ID].Trim();
if (string.IsNullOrEmpty(phone) || Validator.IsMatchLessThanChineseCharacter(phone, PHONE_LENGTH))
{
lblMsg.Text = "联系电话不能为空，且长度不能超过" + PHONE_LENGTH + "个字符！";
return;
}
if (string.IsNullOrEmpty(address) || Validator.IsMatchLessThanChineseCharacter(address, ADDRESS_LENGTH))
{
lblMsg.Text = "取件地址不能为空，且长度不能超过" + ADDRESS_LENGTH + "个字符！";
return;
}
DateTime fetchDate = new DateTime(1999, 1, 1);
if (string.IsNullOrEmpty(strDate) || !DateTime.TryParse(strDate, out fetchDate))
{
lblMsg.Text = "预约时间不能为空，且只能为时间格式！";
return;
}
if (!string.IsNullOrEmpty(remark) && Validator.IsMatchLessThanChineseCharacter(remark, REMARK_LENGTH))
{
lblMsg.Text = "备注长度不能超过" + REMARK_LENGTH + "个字符！";
return;
}
FetchArrange fa = new FetchArrange();
fa.Address = address;
fa.CreateTime = DateTime.Now;
fa.FetchTime = new DateTime(fetchDate.Year, fetchDate.Month, fetchDate.Day, int.Parse(strHour), int.Parse(strMinute), 0);
fa.Phone = phone;
fa.ClientId = client.Id;
fa.CompanyId = client.CompanyId;
fa.Remark = remark;
fa.UserId = user.Id;
fa.Type = OrderType.COMPANY_ORDER;
FetchArrangeOperation.CreateFetchArrange(fa);
Response.Write("<script language='javascript'>alert('添加成功！');location.href='FetchArrangeList.aspx';</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
int id = 0;
if(int.TryParse(Request.QueryString["id"], out id))
{
fa = FetchArrangeOperation.GetFetchArrangeById(id);
}
if (!IsPostBack)
{
FormDataBind();
}
}
public void CreateFetchArrange(FetchArrange fa)
{
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@client_id", fa.ClientId),
SqlUtilities.GenerateInputIntParameter("@user_id", fa.UserId),
SqlUtilities.GenerateInputIntParameter("@company_id", fa.CompanyId),
SqlUtilities.GenerateInputParameter("@type", SqlDbType.TinyInt, (byte)fa.Type),
SqlUtilities.GenerateInputNVarcharParameter("@address", 200, fa.Address),
SqlUtilities.GenerateInputNVarcharParameter("@phone", 50, fa.Phone),
SqlUtilities.GenerateInputDateTimeParameter("@fetch_time", fa.FetchTime),
SqlUtilities.GenerateInputDateTimeParameter("@create_time", fa.CreateTime),
SqlUtilities.GenerateInputNVarcharParameter("@remark", 500, fa.Remark)
};
string sql = "INSERT INTO fetch_arranges(client_id, user_id, company_id, type, address, phone, fetch_time, create_time, remark) VALUES( @client_id, @user_id, @company_id, @type, @address, @phone, @fetch_time, @create_time, @remark)";
SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
public PaginationQueryResult<FetchArrange> GetFetchArrangeByCompanyId(PaginationQueryCondition condition, int companyId)
{
PaginationQueryResult<FetchArrange> result = new PaginationQueryResult<FetchArrange>();
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@company_id", companyId)
};
string sql = "SELECT TOP " + condition.PageSize + " id, client_id, type, address, phone, fetch_time, create_time, company_id, remark, user_id FROM fetch_arranges WHERE company_id = @company_id AND is_delete = 0";
if (condition.CurrentPage > 1)
{
sql += " AND id< (SELECT MIN(id) FROM(SELECT TOP " + condition.PageSize * (condition.CurrentPage - 1) + " id FROM fetch_arranges WHERE company_id = @company_id AND is_delete = 0 ORDER BY id DESC) AS F)";
}
sql += " ORDER BY id DESC; SELECT COUNT(*) FROM fetch_arranges WHERE company_id = @company_id AND is_delete = 0";
using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
{
while (dr.Read())
{
FetchArrange fa = new FetchArrange();
fa.Id = dr.GetInt32(0);
fa.ClientId = dr.GetInt32(1);
fa.ClientName = new ClientDAL().GetClientById(fa.ClientId).RealName;
fa.Type = EnumConvertor.ConvertToOrderType(dr.GetByte(2));
fa.Address = dr.GetString(3);
fa.Phone = dr.GetString(4);
fa.FetchTime = dr.GetDateTime(5);
fa.CreateTime = dr.GetDateTime(6);
fa.CompanyId = dr.GetInt32(7);
fa.Remark = dr.GetString(8);
if (!dr.IsDBNull(9))
{
fa.UserId = dr.GetInt32(9);
}
result.Results.Add(fa);
}
dr.NextResult();
while (dr.Read())
{
result.TotalCount = dr.GetInt32(0);
}
}
return result;
}
public static void UpdateFetchArrange(FetchArrange fa)
{
dal.UpdateFetchArrange(fa);
}
public static void CreateFetchArrange(FetchArrange fa)
{
dal.CreateFetchArrange(fa);
}
public void UpdateFetchArrange(FetchArrange fa)
{
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@id", fa.Id),
SqlUtilities.GenerateInputNVarcharParameter("@address", 200, fa.Address),
SqlUtilities.GenerateInputNVarcharParameter("@phone", 50, fa.Phone),
SqlUtilities.GenerateInputDateTimeParameter("@fetch_time", fa.FetchTime),
SqlUtilities.GenerateInputNVarcharParameter("@remark", 500, fa.Remark)
};
string sql = "UPDATE fetch_arranges SET address = @address, phone = @phone, fetch_time = @fetch_time, remark = @remark WHERE id = @id";
SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
public FetchArrange GetFetchArrangeById(int id)
{
FetchArrange fa = null;
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@id", id)
};
string sql = "SELECT id, client_id, type, address, phone, fetch_time, create_time, company_id, remark, user_id FROM fetch_arranges WHERE id = @id";
using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
{
while (dr.Read())
{
fa = new FetchArrange();
fa.Id = dr.GetInt32(0);
fa.ClientId = dr.GetInt32(1);
fa.ClientName = new ClientDAL().GetClientById(fa.ClientId).RealName;
fa.Type = EnumConvertor.ConvertToOrderType(dr.GetByte(2));
fa.Address = dr.GetString(3);
fa.Phone = dr.GetString(4);
fa.FetchTime = dr.GetDateTime(5);
fa.CreateTime = dr.GetDateTime(6);
fa.CompanyId = dr.GetInt32(7);
fa.Remark = dr.GetString(8);
if (!dr.IsDBNull(9))
{
fa.UserId = dr.GetInt32(9);
}
}
}
return fa;
}
