public static ComplaintEntity getBycId(int cId)
{
DataRow dr = DbHelper.ExecuteDataRow("[dbo].[p_Complaint_getById]", cId);
ComplaintEntity clEnt = new ComplaintEntity();
if (dr != null)
{
clEnt.ComplaintId = cId;
if (dr["ComplaintDt"] != DBNull.Value)
clEnt.ComplaintDt = Convert.ToDateTime(dr["ComplaintDt"]);
if (dr["buyerid"] != DBNull.Value)
clEnt.BuyerId = Convert.ToInt32(dr["buyerid"]);
if (dr["productId"] != DBNull.Value)
clEnt.ProductId = Convert.ToInt32(dr["productId"]);
if (dr["ComplaintType"] != DBNull.Value)
clEnt.ComplaintType = Convert.ToInt32(dr["ComplaintType"]);
if (dr["DepartmentId"] != DBNull.Value)
clEnt.DepartmentId = Convert.ToInt32(dr["DepartmentId"]);
if (dr["DepartmentItemId"] != DBNull.Value)
clEnt.DepartmentItemId = Convert.ToInt32(dr["DepartmentItemId"]);
if (dr["ResponsibleId"] != DBNull.Value)
clEnt.ResponsibleId = Convert.ToInt32(dr["responsibleid"]);
if (dr["SellerId"] != DBNull.Value)
clEnt.SellerId = Convert.ToInt32(dr["SellerId"]);
if (dr["ComplaintLevel"] != DBNull.Value)
clEnt.ComplaintLevel = Convert.ToInt32(dr["ComplaintLevel"]);
clEnt.ComplaintResult = dr["ComplaintResult"].ToString();
clEnt.Remarks = dr["Remarks"].ToString();
if (dr["InputDt"] != DBNull.Value)
clEnt.InputDt = Convert.ToDateTime(dr["InputDt"]);
if (dr["adminid"] != DBNull.Value)
clEnt.adminId = Convert.ToInt32(dr["adminid"]);
}
return clEnt;
}
protected void btn_Save_Click(object sender, EventArgs e)
{
ComplaintEntity clEnt = new ComplaintEntity();
clEnt.ComplaintDt = ext_ComplaintDt.SelectedDate;
clEnt.BuyerId = Convert.ToInt32(ddl_buyer.SelectedValue);
int productId = 0;
int.TryParse(hid_proId.Value, out productId);
clEnt.ProductId = productId;
clEnt.ComplaintType = Convert.ToInt32(ddl_ComplainttypeSub.SelectedValue);
clEnt.DepartmentId = Convert.ToInt32(hid_departmentId.Value);
clEnt.DepartmentItemId = Convert.ToInt32(hid_DepartmentItemId.Value);
int rsId = 0;
//int.TryParse(ddl_responsibleid.SelectedValue, out rsId);
if (clEnt.DepartmentItemId == checker)
{
//int.TryParse(hid_resId.Value, out rsId);
int.TryParse(ViewState["resId"].ToString(),out rsId);
}
else
{
int.TryParse(ddl_responsibleid.SelectedValue, out rsId);
}
clEnt.ResponsibleId = rsId;
int sellerId = 0;
int.TryParse(ddl_sellerName.SelectedValue, out sellerId);
clEnt.SellerId = sellerId;
clEnt.ComplaintLevel = Convert.ToInt32(hid_severityLevel.Value);
clEnt.ComplaintResult =ddl_result.SelectedValue;
clEnt.Remarks = txt_remarks.Text;
clEnt.adminId = logic.sysAdmin.AdminID;
if (cId!=0)
{
clEnt.ComplaintId = cId;
logic.complaint.update(clEnt);
}
else
{
logic.complaint.insert(clEnt);
}
Library.Script.ClientMsgUrl("投诉信息保存成功!", "complaintList.aspx");
}
public static void update(ComplaintEntity clEnt)
{
Complaint.update(clEnt);
}
public static int insert(ComplaintEntity clEnt)
{
return Complaint.insert(clEnt);
}
public static void update(ComplaintEntity clEnt)
{
DbHelper.ExecuteNonQuery("[dbo].[p_Complaint_update]", clEnt.ComplaintId, clEnt.ComplaintDt, clEnt.BuyerId, clEnt.ProductId, clEnt.ComplaintType, clEnt.DepartmentId, clEnt.DepartmentItemId, clEnt.ResponsibleId, clEnt.SellerId, clEnt.ComplaintLevel, clEnt.ComplaintResult, clEnt.Remarks,clEnt.adminId);
}
public static int insert(ComplaintEntity clEnt)
{
return Convert.ToInt32(DbHelper.ExecuteScalar("[dbo].[p_Complaint_insert]", clEnt.BuyerId,clEnt.ComplaintDt,clEnt.ProductId,clEnt.ComplaintType,
clEnt.DepartmentId,clEnt.DepartmentItemId,clEnt.ResponsibleId,clEnt.SellerId,clEnt.ComplaintLevel,clEnt.ComplaintResult,clEnt.Remarks,clEnt.adminId));
}
