protected void Page_Load(object sender, EventArgs e)
{
if (int.TryParse(Request.QueryString["id"], out id))
{
wo = WrongOrderOperation.GetWrongOrderById(id);
result = WrongOrderOperation.GetWrongOrderDetailByWrongOrderId(id);
}
if (!IsPostBack)
{
FormDataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (int.TryParse(Request.QueryString["id"], out id))
{
wo = WrongOrderOperation.GetWrongOrderById(id);
result = WrongOrderOperation.GetWrongOrderDetailByWrongOrderId(id);
}
if (!IsPostBack)
{
FormDataBind();
}
AdminCookie cookie = (AdminCookie)RuleAuthorizationManager.GetCurrentSessionObject(Context, true);
user = UserOperation.GetUserByUsername(cookie.Username);
}
public void CreateWrongOrder(WrongOrder wo)
{
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@order_id", wo.Order.Id),
SqlUtilities.GenerateInputIntParameter("@company_id", wo.CompanyId),
SqlUtilities.GenerateInputNVarcharParameter("@company_name", 50, wo.CompanyName),
SqlUtilities.GenerateInputNVarcharParameter("@encode", 50,wo.Encode),
SqlUtilities.GenerateInputParameter("@status", SqlDbType.TinyInt, (byte)wo.Status),
SqlUtilities.GenerateInputNVarcharParameter("@reason", 500, wo.Reason),
SqlUtilities.GenerateInputNVarcharParameter("@type", 50, wo.Type),
SqlUtilities.GenerateInputDateTimeParameter("@create_time",wo.CreateTime),
SqlUtilities.GenerateInputDateTimeParameter("@last_update_time",wo.LastUpdateCreateTime),
SqlUtilities.GenerateInputIntParameter("@create_user_id", wo.CreateUserId)
};
string sql = "INSERT INTO wrong_orders(order_id, company_id, company_name, encode, status, reason, type, create_time, create_user_id, last_update_time) VALUES(@order_id, @company_id, @company_name, @encode, @status, @reason, @type, @create_time, @create_user_id, @last_update_time)";
SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
public PaginationQueryResult<WrongOrder> GetWrongOrderByClientId(PaginationQueryCondition condition, int clientId)
{
PaginationQueryResult<WrongOrder> result = new PaginationQueryResult<WrongOrder>();
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@client_id", clientId)
};
string sql = "SELECT TOP " + condition.PageSize + " WO.id, WO.order_id, WO.company_id, WO.company_name, WO.encode, WO.status, WO.reason, WO.[type], WO.create_time, WO.create_user_id, WO.last_update_time FROM wrong_orders AS WO INNER JOIN orders AS O ON WO.order_id = O.id WHERE O.client_id = @client_id AND WO.is_delete = 0 AND O.is_delete = 0";
if (condition.CurrentPage > 1)
{
sql += " AND WO.id< (SELECT MIN(id) FROM (SELECT TOP " + condition.PageSize * (condition.CurrentPage - 1) + " WO.id FROM wrong_orders AS WO INNER JOIN orders AS O ON WO.order_id = O.id WHERE O.client_id = @client_id AND WO.is_delete = 0 AND O.is_delete = 0 ORDER BY WO.id DESC) AS W)";
}
sql += " ORDER BY id DESC; SELECT COUNT(*) FROM wrong_orders AS WO INNER JOIN orders AS O ON WO.order_id = O.id WHERE O.client_id = @client_id AND WO.is_delete = 0 AND O.is_delete = 0";
using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
{
while (dr.Read())
{
WrongOrder wo = new WrongOrder();
wo.Id = dr.GetInt32(0);
if (!dr.IsDBNull(1))
{
Order order = new OrderDAL().GetOrderById(dr.GetInt32(1));
wo.Order = order;
}
wo.CompanyId = dr.GetInt32(2);
wo.CompanyName = dr.GetString(3);
wo.Encode = dr.GetString(4);
wo.Status = EnumConvertor.ConvertToWrongOrderStatus(dr.GetByte(5));
wo.Reason = dr.GetString(6);
wo.Type = dr.GetString(7);
wo.CreateTime = dr.GetDateTime(8);
wo.CreateUserId = dr.GetInt32(9);
wo.LastUpdateCreateTime = dr.GetDateTime(10);
result.Results.Add(wo);
}
dr.NextResult();
while (dr.Read())
{
result.TotalCount = dr.GetInt32(0);
}
}
return result;
}
protected void btnCreate_Click(object sender, EventArgs e)
{
string orderEncode = Request.Form[txtOrderEncode.ID].Trim();
string reason = Request.Form[txtReason.ID].Trim();
if (string.IsNullOrEmpty(orderEncode) || Validator.IsMatchLessThanChineseCharacter(orderEncode, ORDER_ENCODE_LENGTH))
{
lblMsg.Text = "定单号不能为空，且长度不能超过"+ORDER_ENCODE_LENGTH+"个字符！";
return;
}
Order order = OrderOperation.GetOrderByEncode(orderEncode);
if (!string.IsNullOrEmpty(orderEncode) && order == null)
{
lblMsg.Text = "此订单号不存在！";
return;
}
if (string.IsNullOrEmpty(reason) || Validator.IsMatchLessThanChineseCharacter(reason, WRONG_ORDER_REASON_LENGTH))
{
lblMsg.Text = "问题内容不能为空，且长度不能超过"+WRONG_ORDER_REASON_LENGTH+"个字符！";
return;
}
WrongOrder wo = new WrongOrder();
wo.CompanyId = user.CompanyId;
wo.CompanyName = CompanyOperation.GetCompanyById(user.CompanyId).Name;
wo.CreateTime = DateTime.Now;
wo.LastUpdateCreateTime = DateTime.Now;
wo.CreateUserId = user.Id;
wo.Encode = StringHelper.GetEncodeNumber("WT");
wo.Reason = reason;
wo.Status = WrongOrderStatus.SEARCHED;
wo.Type = slWrongType.Value;
wo.Order = order;
WrongOrderOperation.CreateWrongOrder(wo);
wo=WrongOrderOperation.GetWrongOrderByEncode(wo.Encode);
Response.Write("<script language='javascript' type='text/javascript'>alert('添加成功！');location.href='WrongOrder.aspx?id="+wo.Id+"';</script>");
}
public void UpdateWrongOrder(WrongOrder wo)
{
SqlParameter[] param = null;
string sql = "";
if (wo.Order != null)
{
param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@id", wo.Id),
SqlUtilities.GenerateInputIntParameter("@order_id", wo.Order.Id),
SqlUtilities.GenerateInputParameter("@status", SqlDbType.TinyInt, (byte)wo.Status),
SqlUtilities.GenerateInputNVarcharParameter("@reason", 500, wo.Reason),
SqlUtilities.GenerateInputDateTimeParameter("@last_update_time",wo.LastUpdateCreateTime),
SqlUtilities.GenerateInputNVarcharParameter("@type", 50, wo.Type)
};
sql = "UPDATE wrong_orders SET order_id = @order_id, status = @status, reason = @reason, type = @type, last_update_time = @last_update_time WHERE id = @id";
}
else
{
param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@id", wo.Id),
SqlUtilities.GenerateInputParameter("@status", SqlDbType.TinyInt, (byte)wo.Status),
SqlUtilities.GenerateInputNVarcharParameter("@reason", 500, wo.Reason),
SqlUtilities.GenerateInputDateTimeParameter("@last_update_time",wo.LastUpdateCreateTime),
SqlUtilities.GenerateInputNVarcharParameter("@type", 50, wo.Type)
};
sql = "UPDATE wrong_orders SET status = @status, reason = @reason, type = @type, last_update_time = @last_update_time WHERE id = @id";
}
SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
public WrongOrder GetWrongOrderById(int id)
{
WrongOrder wo = null;
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@id", id)
};
string sql = "SELECT id, order_id, company_id, company_name, encode, status, reason, type, create_time, create_user_id, last_update_time FROM wrong_orders WHERE id = @id";
using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
{
while (dr.Read())
{
wo = new WrongOrder();
wo.Id = dr.GetInt32(0);
if (!dr.IsDBNull(1))
{
Order order = new OrderDAL().GetOrderById(dr.GetInt32(1));
wo.Order = order;
}
wo.CompanyId = dr.GetInt32(2);
wo.CompanyName = dr.GetString(3);
wo.Encode = dr.GetString(4);
wo.Status = EnumConvertor.ConvertToWrongOrderStatus(dr.GetByte(5));
wo.Reason = dr.GetString(6);
wo.Type = dr.GetString(7);
wo.CreateTime = dr.GetDateTime(8);
wo.CreateUserId = dr.GetInt32(9);
wo.LastUpdateCreateTime = dr.GetDateTime(10);
}
}
return wo;
}
public PaginationQueryResult<WrongOrder> GetWrongOrderByCompanyIdAndDate(PaginationQueryCondition condition, int companyId, DateTime startDate, DateTime endDate)
{
PaginationQueryResult<WrongOrder> result = new PaginationQueryResult<WrongOrder>();
DateTime minTime = new DateTime(1999, 1, 1);
string sqlTime = "";
if (startDate > minTime && endDate > minTime)
{
sqlTime = " AND create_time BETWEEN @start_date AND @end_date";
}
else if (startDate > minTime && endDate <= minTime)
{
sqlTime = " AND create_time >= @start_date ";
}
else
{
sqlTime = " AND create_time <= @end_date";
}
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@company_id", companyId),
SqlUtilities.GenerateInputDateTimeParameter("@start_date", startDate),
SqlUtilities.GenerateInputDateTimeParameter("@end_date", endDate)
};
string sql = "SELECT TOP " + condition.PageSize + " id, order_id, company_id, company_name, encode, status, reason, type, create_time, create_user_id, last_update_time FROM wrong_orders WHERE is_delete = 0 AND company_id = @company_id" + sqlTime;
if (condition.CurrentPage > 1)
{
sql += " AND id< (SELECT MIN(id) FROM (SELECT TOP " + condition.PageSize * (condition.CurrentPage - 1) + " id FROM wrong_orders WHERE is_delete = 0 AND company_id = @company_id "+sqlTime+" ORDER BY id DESC) AS W)";
}
sql += " ORDER BY id DESC; SELECT COUNT(*) FROM wrong_orders WHERE is_delete = 0 AND company_id = @company_id"+sqlTime;
using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
{
while (dr.Read())
{
WrongOrder wo = new WrongOrder();
wo.Id = dr.GetInt32(0);
if (!dr.IsDBNull(1))
{
Order order = new OrderDAL().GetOrderById(dr.GetInt32(1));
wo.Order = order;
}
wo.CompanyId = dr.GetInt32(2);
wo.CompanyName = dr.GetString(3);
wo.Encode = dr.GetString(4);
wo.Status = EnumConvertor.ConvertToWrongOrderStatus(dr.GetByte(5));
wo.Reason = dr.GetString(6);
wo.Type = dr.GetString(7);
wo.CreateTime = dr.GetDateTime(8);
wo.CreateUserId = dr.GetInt32(9);
wo.LastUpdateCreateTime = dr.GetDateTime(10);
result.Results.Add(wo);
}
dr.NextResult();
while (dr.Read())
{
result.TotalCount = dr.GetInt32(0);
}
}
return result;
}
public static void CreateWrongOrder(WrongOrder wo)
{
dal.CreateWrongOrder(wo);
}
public static void UpdateWrongOrder(WrongOrder wo)
{
dal.UpdateWrongOrder(wo);
}
