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