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); }