protected void btnCreate_Click(object sender, EventArgs e) { AdminCookie cookie = (AdminCookie)RuleAuthorizationManager.GetCurrentSessionObject(Context, true); User user = UserOperation.GetUserByUsername(cookie.Username); string detail=Request.Form[txtDetail.ID].Trim(); if (string.IsNullOrEmpty(detail) || Validator.IsMatchLessThanChineseCharacter(detail, DETAIL_LENGTH)) { lblMsg.Text = "处理方式及过程不能为空,且长度不能超过"+DETAIL_LENGTH+"个字符!"; return; } WrongOrderDetail wod = new WrongOrderDetail(); wod.WrongOrderId = id; wod.Detail = detail; wod.CreateTime = DateTime.Now; wod.CreateUserId = user.Id; wod.Result = ddlStatus.SelectedItem.Text; WrongOrderOperation.CreateWrongOrderDetail(wod); WrongOrder wo = WrongOrderOperation.GetWrongOrderById(id); wo.Status = EnumConvertor.ConvertToWrongOrderStatus(byte.Parse(ddlStatus.SelectedItem.Value)); wo.LastUpdateCreateTime = DateTime.Now; WrongOrderOperation.UpdateWrongOrder(wo); string msg = "操作成功!"; if (chkIsMail.Checked) { Order order = OrderOperation.GetOrderById(wo.Order.Id); Company company = CompanyOperation.GetCompanyById(order.CompanyId); EmailHelper.SendMailForService(company, order.Client, wod, out msg); } Response.Write("<script language='javascript'>alert('"+msg+"');location.href='WrongOrder.aspx?id=" + id + "';</script>"); }
public void CreateWrongOrderDetail(WrongOrderDetail wod) { SqlParameter[] param = new SqlParameter[] { SqlUtilities.GenerateInputIntParameter("@wrong_order_id", wod.WrongOrderId), SqlUtilities.GenerateInputNVarcharParameter("@detail", 500, wod.Detail), SqlUtilities.GenerateInputDateTimeParameter("@create_time", wod.CreateTime), SqlUtilities.GenerateInputIntParameter("@create_user_id", wod.CreateUserId), SqlUtilities.GenerateInputNVarcharParameter("@result", 50, wod.Result) }; string sql = "INSERT INTO wrong_order_details(wrong_order_id, detail, result, create_time, create_user_id) VALUES(@wrong_order_id, @detail, @result, @create_time, @create_user_id)"; SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param); }
protected void Page_Load(object sender, EventArgs e) { if (!int.TryParse(Request.QueryString["id"], out id)) { Response.Write("<script language='javascript'>alert('参数错误!');history.go(-1);</script>"); } wod = WrongOrderOperation.GetWrongOrderDetailById(id); if (!IsPostBack) { FormDataBind(); } }
public static bool SendMailForService(Company company, Client client, WrongOrderDetail wod, out string msg) { StringBuilder sb = new StringBuilder(); WrongOrder wrongOrder = WrongOrderOperation.GetWrongOrderById(wod.WrongOrderId); sb.Append(" ���ķ�����Ϣ�и��£�<br/>"); sb.Append(" �����룺"+wrongOrder.BarCode+"<br/>"); sb.Append(" �������ݣ�"+wrongOrder.Reason+"<br/>"); sb.Append(" �����ʽ�����̣�"+wod.Detail+"<br/>"); sb.Append(" ��������"+wod.Result+"<br/>"); sb.Append(" �����ˣ�"+UserOperation.GetUserById(wod.CreateUserId).RealName+"<br/>"); return SendMail(company, client, "�ͻ������и���", sb.ToString(), out msg); }
public void UpdateWrongOrderDetail(WrongOrderDetail wod) { SqlParameter[] param = new SqlParameter[] { SqlUtilities.GenerateInputIntParameter("id", wod.Id), SqlUtilities.GenerateInputNVarcharParameter("@detail", 500, wod.Detail), SqlUtilities.GenerateInputNVarcharParameter("@result", 50, wod.Result) }; string sql = "UPDATE wrong_order_details SET detail = @detail, result = @result WHERE id = @id"; SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param); }
public List<WrongOrderDetail> GetWrongOrderDetailByWrongOrderId(int woId) { List<WrongOrderDetail> result = new List<WrongOrderDetail>(); SqlParameter[] param = new SqlParameter[] { SqlUtilities.GenerateInputIntParameter("@wrong_order_id", woId) }; string sql = "SELECT id, wrong_order_id, detail, result, create_time, create_user_id FROM wrong_order_details WHERE is_delete = 0 AND wrong_order_id = @wrong_order_id "; using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param)) { while (dr.Read()) { WrongOrderDetail wod = new WrongOrderDetail(); wod.Id = dr.GetInt32(0); wod.WrongOrderId = dr.GetInt32(1); wod.Detail = dr.GetString(2); wod.Result = dr.GetString(3); wod.CreateTime = dr.GetDateTime(4); wod.CreateUserId = dr.GetInt32(5); result.Add(wod); } } return result; }
public WrongOrderDetail GetWrongOrderDetailById(int id) { WrongOrderDetail wod = null; SqlParameter[] param = new SqlParameter[] { SqlUtilities.GenerateInputIntParameter("@id", id) }; string sql = " SELECT id, wrong_order_id, detail, result, create_time, create_user_id FROM wrong_order_details WHERE id = @id"; using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param)) { while (dr.Read()) { wod = new WrongOrderDetail(); wod.Id = dr.GetInt32(0); wod.WrongOrderId = dr.GetInt32(1); wod.Detail = dr.GetString(2); wod.Result = dr.GetString(3); wod.CreateTime = dr.GetDateTime(4); wod.CreateUserId = dr.GetInt32(5); } } return wod; }
public static void CreateWrongOrderDetail(WrongOrderDetail wod) { dal.CreateWrongOrderDetail(wod); }
public static void UpdateWrongOrderDetail(WrongOrderDetail wod) { dal.UpdateWrongOrderDetail(wod); }