/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMQ_QUA_MAIN GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select m.C_ID,m.C_NO,c_area_id, area.c_detailname areaname,c_distributor, c_directuser, c_contact, c_con_phone, c_grd,
c_prod_use, d_ship_start_dt, d_ship_end_dt, n_object_count_wgt, c_object_content, c_tech_desc, c_site_survey_content, n_parent_qua,
n_quest_qua, n_middle_qua, n_else_qua, c_dept, c_quality_dept, c_technology, c_qt, c_remark, c_cust_making, d_cust_making_dt,
c_quality_result, c_objection_type, c_ourreasons, d_feedback_area, c_effect_valid, c_precc_result, n_amount, d_compensation_dt,
c_state, N_CYCLE, c_month_average, c_salesman,c_salesid, n_flag, m.c_emp_id, m.c_emp_name, m.n_status, m.c_crt_id,D_EMP_DT,m.D_CRT_DT, decode(n_flag,1,'质量异议反馈',2,'客户信息反馈',3,'委托检验') n_flagname
, decode(m.n_status,-1,'未提交',0,'待处理',1,'审核中',2,'已完成') n_statusname from TMQ_QUA_MAIN m
left join (select t.* ,t.rowid from ts_dic t where t.c_typecode ='ConArea' and t.n_status=1) area
on m.c_area_id=area.c_detailcode ");
strSql.Append(" where m.C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TMQ_QUA_MAIN model = new Mod_TMQ_QUA_MAIN();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 页面数据转换成List
/// </summary>
/// <param name="vUser"></param>
/// <param name="mod"></param>
/// <returns></returns>
private List <Mod_TMQ_QUA_ITEM> AddListItem(CurrentUser vUser, Mod_TMQ_QUA_MAIN mod)
{
var ls = new List <Mod_TMQ_QUA_ITEM>();
for (int i = 0; i < rptList.Items.Count; i++)
{
Mod_TMQ_QUA_ITEM modItem = new Mod_TMQ_QUA_ITEM();
modItem.C_id = Guid.NewGuid().ToString();
modItem.C_brand_name = ((TextBox)rptList.Items[i].FindControl("txtBRAND_NAME")).Text;
modItem.C_spec = ((TextBox)rptList.Items[i].FindControl("txtSPEC")).Text;
modItem.C_batch = ((TextBox)rptList.Items[i].FindControl("txtBATCH")).Text;//
if (((TextBox)rptList.Items[i].FindControl("txtSHIPPEDQTY")).Text != "")
{
modItem.N_shippedqty = decimal.Parse(((TextBox)rptList.Items[i].FindControl("txtSHIPPEDQTY")).Text);//
}
if (((HtmlInputText)rptList.Items[i].FindControl("txtOBJECT_WGT")).Value != "")
{
modItem.N_object_wgt = decimal.Parse(((HtmlInputText)rptList.Items[i].FindControl("txtOBJECT_WGT")).Value);//
}
modItem.C_stl_code = ((TextBox)rptList.Items[i].FindControl("txtSTL_CODE")).Text;
modItem.C_crt_id = vUser.Id;
modItem.C_emp_dt = DateTime.Now;
modItem.C_emp_id = vUser.Id;
modItem.C_emp_name = vUser.Name;
modItem.C_parentid = mod.C_id;
modItem.D_crt_dt = DateTime.Now;
ls.Add(modItem);
}
return(ls);
}
public bool Submit(Mod_TMQ_QUA_MAIN model)
{
#region 更新数据
StringBuilder strSql = new StringBuilder();
strSql.Append(@"update TMQ_QUA_MAIN set
n_status=:n_status");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":n_status", OracleDbType.Decimal, 1),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.N_status;
parameters[1].Value = model.C_id;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
var BaseUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
if (BaseUser != null)
{
try
{
ltlUserID.Text = BaseUser.Id;
if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
{
Mod_TMQ_QUA_MAIN mod = qua.GetModel(Request.QueryString["ID"]);
if (mod != null)
{
string str = string.Empty;
switch (Convert.ToInt32(mod.N_flag))
{
case 1:
str = "质量异议反馈";
break;
case 2:
str = "客户信息反馈";
break;
case 3:
str = "委托检验";
break;
}
txtTitle.Text = mod.C_distributor + "(" + str + ")";//经销商
}
hidQualityID.Value = Request.QueryString["ID"];
GetFlow();
}
}
catch (Exception ex)
{
WebMsg.MessageBox(ex.Message);
}
}
else
{
WebMsg.CheckUserLogin();
}
}
}
//提交邢钢处理（客户）
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(hid.Value))
{
Mod_TMQ_QUA_MAIN mod = new Mod_TMQ_QUA_MAIN();
mod = qua.GetModel(hid.Value);
var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
if (vUser.Roles.Where(x => x.C_CODE == RoleCode).Any())
{
mod.N_status = 0;
}
if (qua.Update(mod))
{
this.btnAdd.Visible = false; //添加行
this.btndelrow.Visible = false; //删除行
this.btnsave.Visible = false; //保存
this.btnSubmit.Visible = false; //提交
btndoc.Visible = false; //文档
//btnAudit.Visible = false;//审批
btnCheck.Visible = false; //送审
WebMsg.MessageBox("提交成功");
//Page pa = (Page)System.Web.HttpContext.Current.CurrentHandler;
//ClientScript.RegisterClientScriptBlock(pa.GetType(), "aa", "<script language='javascript'>alert('提交成功!');</script>");
}
}
else
{
WebMsg.MessageBox("请点击保存");
}
}
catch (Exception ex)
{
WebMsg.MessageBox(ex.Message);
}
}
public AjaxResult QualityUpdate([FromBody] dynamic Json)
{
string SaveOrSubmit = Json.SaveOrSubmit; //1 保存 2 提交
string ID = Json.ID; //主表ID
string AreaID = Json.AreaID; //区域ID
string Distri = Json.Distri; //经销商
string tDirectuser = Json.tDirectuser; //直接用户
string Contact = Json.Contact; //联系人
string ConPhone = Json.ConPhone; //联系电话
string Grd = Json.Grd; //钢种
string Start = Json.Start; //发货时间
string End = Json.End; //到货时间
string ProUse = Json.ProUse; //产品用途
string SaleUser = Json.SaleUser; //业务员名称
string SaleUserID = Json.SaleUserID; //业务员ID
string ObjContent = Json.ObjContent; //投诉异议内容
string TechDesc = Json.TechDesc; //用户工艺流程
string Bz = Json.Bz; //备注信息
string SiteContent = Json.SiteContent; //现场调查情况
string ParentQua = Json.ParentQua; //母材
string QuestQua = Json.QuestQua; //问题样
string MidQua = Json.MidQua; //中间样
string ElseQua = Json.ElseQua; //其他样
string Dept = Json.Dept; //本部门
string QualityDept = Json.QualityDept; //质控部
string Technology = Json.Technology; //技术中心
string Qt = Json.Qt; //其他
string TypeID = Json.TypeID; //类型ID
string SumWGT = Json.SumWGT; //异议数量合计 明细异议数量 汇总和
string CustMaking = Json.CustMaking; //制单人
string CustMakingDT = Json.CustMakingDT; //制单日期
string QualityResult = Json.QualityResult; //质控部检验结果
string ObjectionType = Json.ObjectionType; //异议分类
string OurReaons = Json.OurReaons; //我方原因
string FeedBackArea = Json.FeedBackArea; //反馈区域时间
string EffectValid = Json.EffectValid; //效果验证
string PreccResult = Json.PreccResult; //处理结果
string Amount = Json.Amount; //赔付金额
string CompensationDt = Json.CompensationDt; //赔付时间
string State = Json.State; //状态
string Cycle = Json.Cycle; //处理周期
AjaxResult result = new AjaxResult();
var vUser = GetUser();
if (vUser == null)
{
result.Code = DoResult.Failed;
result.Result = "修改失败!";
return(result);
}
Mod_TMQ_QUA_MAIN mod = qua.GetModel(ID);
#region 更新字段
if (!string.IsNullOrEmpty(State))
{
mod.C_state = State;
}
if (!string.IsNullOrEmpty(Cycle))
{
mod.N_cycle = Decimal.Parse(Cycle);
}
if (!string.IsNullOrEmpty(AreaID))
{
mod.C_area_id = AreaID;
}
if (!string.IsNullOrEmpty(Distri))
{
mod.C_distributor = Distri;
}
if (!string.IsNullOrEmpty(tDirectuser))
{
mod.C_directuser = tDirectuser;
}
if (!string.IsNullOrEmpty(Contact))
{
mod.C_contact = Contact;
}
if (!string.IsNullOrEmpty(ConPhone))
{
mod.C_con_phone = ConPhone;
}
if (!string.IsNullOrEmpty(Grd))
{
mod.C_grd = Grd;
}
if (!string.IsNullOrEmpty(ProUse))
{
mod.C_prod_use = ProUse;
}
if (!string.IsNullOrEmpty(Start))
{
mod.D_ship_start_dt = DateTime.Parse(Start);
}
if (!string.IsNullOrEmpty(End))
{
mod.D_ship_end_dt = DateTime.Parse(End);
}
if (!string.IsNullOrEmpty(SaleUser))
{
mod.C_salesman = SaleUser;
}
if (!string.IsNullOrEmpty(SaleUserID))
{
mod.C_salesid = SaleUserID;
}
if (!string.IsNullOrEmpty(ObjContent))
{
mod.C_object_content = ObjContent;
}
if (!string.IsNullOrEmpty(TechDesc))
{
mod.C_tech_desc = TechDesc;
}
if (!string.IsNullOrEmpty(Bz))
{
mod.C_remark = Bz;
}
if (!string.IsNullOrEmpty(SiteContent))
{
mod.C_site_survey_content = SiteContent;
}
if (!string.IsNullOrEmpty(ParentQua))
{
mod.N_parent_qua = decimal.Parse(ParentQua);
}
if (!string.IsNullOrEmpty(QuestQua))
{
mod.N_quest_qua = decimal.Parse(QuestQua);
}
if (!string.IsNullOrEmpty(MidQua))
{
mod.N_middle_qua = decimal.Parse(MidQua);
}
if (!string.IsNullOrEmpty(ElseQua))
{
mod.N_else_qua = decimal.Parse(ElseQua);
}
if (!string.IsNullOrEmpty(Dept))
{
mod.C_dept = Dept;
}
if (!string.IsNullOrEmpty(QualityDept))
{
mod.C_quality_dept = QualityDept;
}
if (!string.IsNullOrEmpty(Technology))
{
mod.C_technology = Technology;
}
if (!string.IsNullOrEmpty(Qt))
{
mod.C_qt = Qt;
}
if (!string.IsNullOrEmpty(TypeID))
{
mod.N_flag = decimal.Parse(TypeID);
}
if (!string.IsNullOrEmpty(SumWGT))
{
mod.N_object_count_wgt = decimal.Parse(SumWGT);
}
if (!string.IsNullOrEmpty(CustMaking))
{
mod.C_cust_making = CustMaking;
}
if (!string.IsNullOrEmpty(CustMakingDT))
{
mod.D_cust_making_dt = DateTime.Parse(CustMakingDT);
}
if (!string.IsNullOrEmpty(QualityResult))
{
mod.C_quality_result = QualityResult;
}
if (!string.IsNullOrEmpty(ObjectionType))
{
mod.C_objection_type = ObjectionType;
}
if (!string.IsNullOrEmpty(OurReaons))
{
mod.C_ourreasons = OurReaons;
}
if (!string.IsNullOrEmpty(FeedBackArea))
{
mod.D_feedback_area = DateTime.Parse(FeedBackArea);
}
if (!string.IsNullOrEmpty(EffectValid))
{
mod.C_effect_valid = EffectValid;
}
if (!string.IsNullOrEmpty(PreccResult))
{
mod.C_precc_result = PreccResult;
}
if (!string.IsNullOrEmpty(Amount))
{
mod.N_amount = decimal.Parse(Amount);
}
if (!string.IsNullOrEmpty(CompensationDt))
{
mod.D_compensation_dt = DateTime.Parse(CompensationDt);
}
mod.C_emp_id = vUser.C_ID;
mod.C_emp_name = vUser.C_NAME;
if (!string.IsNullOrEmpty(SaveOrSubmit) && SaveOrSubmit == "2")
{
if (vUser.Roles.Where(x => x.C_CODE == RoleCode).Any())
{
mod.N_status = 0;
}
else if (vUser.Roles.Where(x => SaleCode.Contains(x.C_CODE)).Any())
{
mod.N_status = 1;
}
else if (vUser.Roles.Where(x => x.C_CODE == KFCode).Any())
{
mod.N_status = 2;
}
if (qua.Submit(mod))
{
result.Code = DoResult.Success;
result.Result = "提交成功";
}
else
{
result.Code = DoResult.Failed;
result.Result = "提交失败!";
}
}
else
{
#endregion
if (qua.Update(mod))
{
result.Code = DoResult.Success;
result.Result = "修改成功";
}
else
{
result.Code = DoResult.Failed;
result.Result = "修改失败!";
}
}
return(result);
}
public AjaxResult QualityAdd([FromBody] dynamic Json)
{
string AreaID = Json.AreaID; //区域ID
string Distri = Json.Distri; //经销商
string tDirectuser = Json.tDirectuser; //直接用户
string Contact = Json.Contact; //联系人
string ConPhone = Json.ConPhone; //联系电话
string Grd = Json.Grd; //钢种
string Start = Json.Start; //发货时间
string End = Json.End; //到货时间
string ProUse = Json.ProUse; //产品用途
string SaleUser = Json.SaleUser; //业务员名称
string SaleUserID = Json.SaleUserID; //业务员ID
string ObjContent = Json.ObjContent; //投诉异议内容
string TechDesc = Json.TechDesc; //用户工艺流程
string Bz = Json.Bz; //备注信息
string StlGrdType = Json.StlGrdType; //钢种类型
if (Start != "")
{
Start += " 00:00:00";
}
if (End != "")
{
End += " 00:00:00";
}
AjaxResult result = new AjaxResult();
var vUser = GetUser();
if (vUser == null)
{
result.Code = DoResult.Failed;
result.Result = "添加失败!";
return(result);
}
Mod_TMQ_QUA_MAIN mod = new Mod_TMQ_QUA_MAIN();
mod.C_id = Guid.NewGuid().ToString();
#region 新增字段
if (!string.IsNullOrEmpty(AreaID))
{
mod.C_area_id = AreaID;
}
if (!string.IsNullOrEmpty(Distri))
{
mod.C_distributor = Distri;
}
if (!string.IsNullOrEmpty(tDirectuser))
{
mod.C_directuser = tDirectuser;
}
if (!string.IsNullOrEmpty(Contact))
{
mod.C_contact = Contact;
}
if (!string.IsNullOrEmpty(ConPhone))
{
mod.C_con_phone = ConPhone;
}
if (!string.IsNullOrEmpty(Grd))
{
mod.C_grd = Grd;
}
if (!string.IsNullOrEmpty(Start))
{
mod.D_ship_start_dt = DateTime.Parse(Start);
}
if (!string.IsNullOrEmpty(End))
{
mod.D_ship_end_dt = DateTime.Parse(End);
}
if (!string.IsNullOrEmpty(ProUse))
{
mod.C_prod_use = ProUse;
}
if (!string.IsNullOrEmpty(SaleUser))
{
mod.C_salesman = SaleUser;
}
if (!string.IsNullOrEmpty(SaleUserID))
{
mod.C_salesid = SaleUserID;
}
if (!string.IsNullOrEmpty(ObjContent))
{
mod.C_object_content = ObjContent;
}
if (!string.IsNullOrEmpty(TechDesc))
{
mod.C_tech_desc = TechDesc;
}
if (!string.IsNullOrEmpty(Bz))
{
mod.C_remark = Bz;
}
mod.C_objection_type = StlGrdType;
mod.D_crt_dt = DateTime.Now;
mod.N_status = -1;
mod.C_emp_id = vUser.C_ID;
mod.C_emp_name = vUser.C_NAME;
mod.C_crt_id = vUser.C_ID;
#endregion
if (qua.Add(mod))
{
result.Code = DoResult.Success;
result.Result = mod.C_id;
}
else
{
result.Code = DoResult.Failed;
result.Result = "添加失败!";
}
return(result);
}
public bool Submit(Mod_TMQ_QUA_MAIN model)
{
return(dal.Submit(model));
}
public bool Update(Mod_TMQ_QUA_MAIN model)
{
return(dal.Update(model));
}
public bool Add(Mod_TMQ_QUA_MAIN model)
{
return(dal.Add(model));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMQ_QUA_MAIN DataRowToModel(DataRow row)
{
Mod_TMQ_QUA_MAIN model = new Mod_TMQ_QUA_MAIN();
if (row != null)
{
#region 转换实体
if (row["C_ID"] != null)
{
model.C_id = row["C_ID"].ToString();
}
if (row["C_NO"] != null)
{
model.C_No = row["C_NO"].ToString();
}
if (row["c_area_id"] != null)
{
model.C_area_id = row["c_area_id"].ToString();
}
if (row["c_distributor"] != null)
{
model.C_distributor = row["c_distributor"].ToString();
}
if (row["c_directuser"] != null)
{
model.C_directuser = row["c_directuser"].ToString();
}
if (row["areaname"] != null)
{
model.C_areaname = row["areaname"].ToString();
}
if (row["n_flagname"] != null)
{
model.N_flagname = row["n_flagname"].ToString();
}
if (row["n_statusname"] != null)
{
model.N_statusname = row["n_statusname"].ToString();
}
if (row["c_contact"] != null)
{
model.C_contact = row["c_contact"].ToString();
}
if (row["c_con_phone"] != null)
{
model.C_con_phone = row["c_con_phone"].ToString();
}
if (row["c_grd"] != null)
{
model.C_grd = row["c_grd"].ToString();
}
if (row["c_prod_use"] != null)
{
model.C_prod_use = row["c_prod_use"].ToString();
}
if (row["d_ship_start_dt"] != null && row["d_ship_start_dt"].ToString() != "")
{
model.D_ship_start_dt = DateTime.Parse(row["d_ship_start_dt"].ToString());
}
if (row["d_ship_end_dt"] != null && row["d_ship_end_dt"].ToString() != "")
{
model.D_ship_end_dt = DateTime.Parse(row["d_ship_end_dt"].ToString());
}
if (row["n_object_count_wgt"] != null && row["n_object_count_wgt"].ToString() != "")
{
model.N_object_count_wgt = decimal.Parse(row["n_object_count_wgt"].ToString());
}
if (row["c_object_content"] != null)
{
model.C_object_content = row["c_object_content"].ToString();
}
if (row["c_tech_desc"] != null)
{
model.C_tech_desc = row["c_tech_desc"].ToString();
}
if (row["c_site_survey_content"] != null)
{
model.C_site_survey_content = row["c_site_survey_content"].ToString();
}
if (row["n_parent_qua"] != null && row["n_parent_qua"].ToString() != "")
{
model.N_parent_qua = decimal.Parse(row["n_parent_qua"].ToString());
}
if (row["n_quest_qua"] != null && row["n_quest_qua"].ToString() != "")
{
model.N_quest_qua = decimal.Parse(row["n_quest_qua"].ToString());
}
if (row["n_middle_qua"] != null && row["n_middle_qua"].ToString() != "")
{
model.N_middle_qua = decimal.Parse(row["n_middle_qua"].ToString());
}
if (row["n_else_qua"] != null && row["n_else_qua"].ToString() != "")
{
model.N_else_qua = decimal.Parse(row["n_else_qua"].ToString());
}
if (row["c_dept"] != null)
{
model.C_dept = row["c_dept"].ToString();
}
if (row["c_quality_dept"] != null)
{
model.C_quality_dept = row["c_quality_dept"].ToString();
}
if (row["c_technology"] != null)
{
model.C_technology = row["c_technology"].ToString();
}
if (row["c_qt"] != null)
{
model.C_qt = row["c_qt"].ToString();
}
if (row["c_remark"] != null)
{
model.C_remark = row["c_remark"].ToString();
}
if (row["c_cust_making"] != null)
{
model.C_cust_making = row["c_cust_making"].ToString();
}
if (row["d_cust_making_dt"] != null && row["d_cust_making_dt"].ToString() != "")
{
model.D_cust_making_dt = DateTime.Parse(row["d_cust_making_dt"].ToString());
}
if (row["c_quality_result"] != null)
{
model.C_quality_result = row["c_quality_result"].ToString();
}
if (row["c_objection_type"] != null)
{
model.C_objection_type = row["c_objection_type"].ToString();
}
if (row["c_ourreasons"] != null)
{
model.C_ourreasons = row["c_ourreasons"].ToString();
}
if (row["d_feedback_area"] != null && row["d_feedback_area"].ToString() != "")
{
model.D_feedback_area = DateTime.Parse(row["d_feedback_area"].ToString());
}
if (row["c_effect_valid"] != null)
{
model.C_effect_valid = row["c_effect_valid"].ToString();
}
if (row["c_precc_result"] != null)
{
model.C_precc_result = row["c_precc_result"].ToString();
}
if (row["n_amount"] != null && row["n_amount"].ToString() != "")
{
model.N_amount = decimal.Parse(row["n_amount"].ToString());
}
if (row["d_compensation_dt"] != null && row["d_compensation_dt"].ToString() != "")
{
model.D_compensation_dt = DateTime.Parse(row["d_compensation_dt"].ToString());
}
if (row["c_state"] != null)
{
model.C_state = row["c_state"].ToString();
}
if (row["N_CYCLE"] != null && row["N_CYCLE"].ToString() != "")
{
model.N_cycle = decimal.Parse(row["N_CYCLE"].ToString());
}
if (row["c_month_average"] != null)
{
model.C_month_average = row["c_month_average"].ToString();
}
if (row["c_salesman"] != null)
{
model.C_salesman = row["c_salesman"].ToString();
}
if (row["c_salesid"] != null)
{
model.C_salesid = row["c_salesid"].ToString();
}
if (row["n_flag"] != null && row["n_flag"].ToString() != "")
{
model.N_flag = decimal.Parse(row["n_flag"].ToString());
}
if (row["c_emp_id"] != null)
{
model.C_emp_id = row["c_emp_id"].ToString();
}
if (row["c_emp_name"] != null)
{
model.C_emp_name = row["c_emp_name"].ToString();
}
if (row["n_status"] != null && row["n_status"].ToString() != "")
{
model.N_status = decimal.Parse(row["n_status"].ToString());
}
if (row["c_crt_id"] != null)
{
model.C_crt_id = row["c_crt_id"].ToString();
}
if (row["D_EMP_DT"] != null && row["D_EMP_DT"].ToString() != "")
{
model.D_emp_dt = DateTime.Parse(row["D_EMP_DT"].ToString());
}
if (row["D_CRT_DT"] != null && row["D_CRT_DT"].ToString() != "")
{
model.D_crt_dt = DateTime.Parse(row["D_CRT_DT"].ToString());
}
#endregion
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMQ_QUA_MAIN model)
{
#region 更新数据
StringBuilder strSql = new StringBuilder();
strSql.Append(@"update TMQ_QUA_MAIN set
c_area_id=:c_area_id,
c_distributor=:c_distributor,
c_directuser=:c_directuser,
c_contact=:c_contact,
c_con_phone=:c_con_phone,
c_grd=:c_grd,
c_prod_use=:c_prod_use,
d_ship_start_dt=:d_ship_start_dt,
d_ship_end_dt=:d_ship_end_dt,
n_object_count_wgt=:n_object_count_wgt,
c_object_content=:c_object_content,
c_tech_desc=:c_tech_desc,
c_site_survey_content=:c_site_survey_content,
n_parent_qua=:n_parent_qua,
n_quest_qua=:n_quest_qua,
n_middle_qua=:n_middle_qua,
n_else_qua=:n_else_qua,
c_dept=:c_dept,
c_quality_dept=:c_quality_dept,
c_technology=:c_technology,
c_qt=:c_qt,
c_remark=:c_remark,
c_cust_making=:c_cust_making,
d_cust_making_dt=:d_cust_making_dt,
c_quality_result=:c_quality_result,
c_objection_type=:c_objection_type,
c_ourreasons=:c_ourreasons,
d_feedback_area=:d_feedback_area,
c_effect_valid=:c_effect_valid,
c_precc_result=:c_precc_result,
n_amount=:n_amount,
d_compensation_dt=:d_compensation_dt,
c_state=:c_state,
n_cycle=:n_cycle,
c_month_average=:c_month_average,
c_salesman=:c_salesman,
n_flag=:n_flag,
c_emp_id=:c_emp_id,
c_emp_name=:c_emp_name,
n_status=:n_status,
c_salesid=:c_salesid");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":c_area_id", OracleDbType.Varchar2, 100),
new OracleParameter(":c_distributor", OracleDbType.Varchar2, 100),
new OracleParameter(":c_directuser", OracleDbType.Varchar2, 100),
new OracleParameter(":c_contact", OracleDbType.Varchar2, 100),
new OracleParameter(":c_con_phone", OracleDbType.Varchar2, 100),
new OracleParameter(":c_grd", OracleDbType.Varchar2, 100),
new OracleParameter(":c_prod_use", OracleDbType.Varchar2, 100),
new OracleParameter(":d_ship_start_dt", OracleDbType.Date),
new OracleParameter(":d_ship_end_dt", OracleDbType.Date),
new OracleParameter(":n_object_count_wgt", OracleDbType.Decimal, 15),
new OracleParameter(":c_object_content", OracleDbType.Varchar2, 1000),
new OracleParameter(":c_tech_desc", OracleDbType.Varchar2, 1000),
new OracleParameter(":c_site_survey_content", OracleDbType.Varchar2, 1000),
new OracleParameter(":n_parent_qua", OracleDbType.Decimal, 2),
new OracleParameter(":n_quest_qua", OracleDbType.Decimal, 2),
new OracleParameter(":n_middle_qua", OracleDbType.Decimal, 2),
new OracleParameter(":n_else_qua", OracleDbType.Decimal, 2),
new OracleParameter(":c_dept", OracleDbType.Varchar2, 100),
new OracleParameter(":c_quality_dept", OracleDbType.Varchar2, 100),
new OracleParameter(":c_technology", OracleDbType.Varchar2, 100),
new OracleParameter(":c_qt", OracleDbType.Varchar2, 100),
new OracleParameter(":c_remark", OracleDbType.Varchar2, 1000),
new OracleParameter(":c_cust_making", OracleDbType.Varchar2, 100),
new OracleParameter(":d_cust_making_dt", OracleDbType.Date),
new OracleParameter(":c_quality_result", OracleDbType.Varchar2, 100),
new OracleParameter(":c_objection_type", OracleDbType.Varchar2, 100),
new OracleParameter(":c_ourreasons", OracleDbType.Varchar2, 500),
new OracleParameter(":d_feedback_area", OracleDbType.Date),
new OracleParameter(":c_effect_valid", OracleDbType.Varchar2, 200),
new OracleParameter(":c_precc_result", OracleDbType.Varchar2, 500),
new OracleParameter(":n_amount", OracleDbType.Decimal, 15),
new OracleParameter(":d_compensation_dt", OracleDbType.Date),
new OracleParameter(":c_state", OracleDbType.Varchar2, 100),
new OracleParameter(":n_cycle", OracleDbType.Decimal, 2),
new OracleParameter(":c_month_average", OracleDbType.Varchar2, 100),
new OracleParameter(":c_salesman", OracleDbType.Varchar2, 100),
new OracleParameter(":n_flag", OracleDbType.Decimal, 1),
new OracleParameter(":c_emp_id", OracleDbType.Varchar2, 100),
new OracleParameter(":c_emp_name", OracleDbType.Varchar2, 100),
new OracleParameter(":n_status", OracleDbType.Decimal, 1),
new OracleParameter(":c_salesid", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_area_id;
parameters[1].Value = model.C_distributor;
parameters[2].Value = model.C_directuser;
parameters[3].Value = model.C_contact;
parameters[4].Value = model.C_con_phone;
parameters[5].Value = model.C_grd;
parameters[6].Value = model.C_prod_use;
parameters[7].Value = model.D_ship_start_dt;
parameters[8].Value = model.D_ship_end_dt;
parameters[9].Value = model.N_object_count_wgt;
parameters[10].Value = model.C_object_content;
parameters[11].Value = model.C_tech_desc;
parameters[12].Value = model.C_site_survey_content;
parameters[13].Value = model.N_parent_qua;
parameters[14].Value = model.N_quest_qua;
parameters[15].Value = model.N_middle_qua;
parameters[16].Value = model.N_else_qua;
parameters[17].Value = model.C_dept;
parameters[18].Value = model.C_quality_dept;
parameters[19].Value = model.C_technology;
parameters[20].Value = model.C_qt;
parameters[21].Value = model.C_remark;
parameters[22].Value = model.C_cust_making;
parameters[23].Value = model.D_cust_making_dt;
parameters[24].Value = model.C_quality_result;
parameters[25].Value = model.C_objection_type;
parameters[26].Value = model.C_ourreasons;
parameters[27].Value = model.D_feedback_area;
parameters[28].Value = model.C_effect_valid;
parameters[29].Value = model.C_precc_result;
parameters[30].Value = model.N_amount;
parameters[31].Value = model.D_compensation_dt;
parameters[32].Value = model.C_state;
parameters[33].Value = model.N_cycle;
parameters[34].Value = model.C_month_average;
parameters[35].Value = model.C_salesman;
parameters[36].Value = model.N_flag;
parameters[37].Value = model.C_emp_id;
parameters[38].Value = model.C_emp_name;
parameters[39].Value = model.N_status;
parameters[40].Value = model.C_salesid;
parameters[41].Value = model.C_id;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
#endregion
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMQ_QUA_MAIN model)
{
#region 新增主表
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMQ_QUA_MAIN(");
strSql.Append(@" c_area_id,
c_distributor,
c_directuser,
c_contact,
c_con_phone,
c_grd,
c_prod_use,
d_ship_start_dt,
d_ship_end_dt,
n_object_count_wgt,
c_object_content,
c_tech_desc,
c_site_survey_content,
n_parent_qua,
n_quest_qua,
n_middle_qua,
n_else_qua,
c_dept,
c_quality_dept,
c_technology,
c_qt,
c_remark,
c_cust_making,
d_cust_making_dt,
c_quality_result,
c_objection_type,
c_ourreasons,
d_feedback_area,
c_effect_valid,
c_precc_result,
n_amount,
d_compensation_dt,
c_state,
n_cycle,
c_month_average,
c_salesman,
n_flag,
c_emp_id,
c_emp_name,
n_status,
c_crt_id,
C_ID,C_SALESID) values ( :c_area_id,
:c_distributor,
:c_directuser,
:c_contact,
:c_con_phone,
:c_grd,
:c_prod_use,
:d_ship_start_dt,
:d_ship_end_dt,
:n_object_count_wgt,
:c_object_content,
:c_tech_desc,
:c_site_survey_content,
:n_parent_qua,
:n_quest_qua,
:n_middle_qua,
:n_else_qua,
:c_dept,
:c_quality_dept,
:c_technology,
:c_qt,
:c_remark,
:c_cust_making,
:d_cust_making_dt,
:c_quality_result,
:c_objection_type,
:c_ourreasons,
:d_feedback_area,
:c_effect_valid,
:c_precc_result,
:n_amount,
:d_compensation_dt,
:c_state,
:n_cycle,
:c_month_average,
:c_salesman,
:n_flag,
:c_emp_id,
:c_emp_name,
:n_status,
:c_crt_id,
:C_ID,:C_SALESID)");
OracleParameter[] parameters =
{
new OracleParameter(":c_area_id", OracleDbType.Varchar2,100), //区域ID
new OracleParameter(":c_distributor", OracleDbType.Varchar2,100), //经销商
new OracleParameter(":c_directuser", OracleDbType.Varchar2,100), //直接用户
new OracleParameter(":c_contact", OracleDbType.Varchar2,100), //联系人
new OracleParameter(":c_con_phone", OracleDbType.Varchar2,100), //联系电话
new OracleParameter(":c_grd", OracleDbType.Varchar2,100), //钢种大类
new OracleParameter(":c_prod_use", OracleDbType.Varchar2,100), //产品用途
new OracleParameter(":d_ship_start_dt", OracleDbType.Date), //发货开始时间
new OracleParameter(":d_ship_end_dt", OracleDbType.Date), //发货到货时间
new OracleParameter(":n_object_count_wgt", OracleDbType.Decimal,15), //异议数量合计
new OracleParameter(":c_object_content", OracleDbType.Varchar2,1000), //投诉异议内容/信息内容
new OracleParameter(":c_tech_desc", OracleDbType.Varchar2,1000), //用户工艺流程/生产工艺
new OracleParameter(":c_site_survey_content", OracleDbType.Varchar2,1000), //现场调查情况
new OracleParameter(":n_parent_qua", OracleDbType.Decimal,2), //母材支数(取样)/原始盘条样
new OracleParameter(":n_quest_qua", OracleDbType.Decimal,2), //问题样支数(取样)/问题产品
new OracleParameter(":n_middle_qua", OracleDbType.Decimal,2), //中间样支数(取样)/中间产品样
new OracleParameter(":n_else_qua", OracleDbType.Decimal,2), //其他支数(取样)
new OracleParameter(":c_dept", OracleDbType.Varchar2,100), //部门
new OracleParameter(":c_quality_dept", OracleDbType.Varchar2,100), //质控部
new OracleParameter(":c_technology", OracleDbType.Varchar2,100), //技术中心
new OracleParameter(":c_qt", OracleDbType.Varchar2,100), //其他
new OracleParameter(":c_remark", OracleDbType.Varchar2,1000), //备注
new OracleParameter(":c_cust_making", OracleDbType.Varchar2,100), //制单人
new OracleParameter(":d_cust_making_dt", OracleDbType.Date), //制单时间
new OracleParameter(":c_quality_result", OracleDbType.Varchar2,100), //质控部结果
new OracleParameter(":c_objection_type", OracleDbType.Varchar2,100), //钢种类型--------------****
new OracleParameter(":c_ourreasons", OracleDbType.Varchar2,500), //缺陷类别-------------------****
new OracleParameter(":d_feedback_area", OracleDbType.Date), //反馈区域时间
new OracleParameter(":c_effect_valid", OracleDbType.Varchar2,200), //效果验证
new OracleParameter(":c_precc_result", OracleDbType.Varchar2,500), //处理结果
new OracleParameter(":n_amount", OracleDbType.Decimal,15), //赔付金额
new OracleParameter(":d_compensation_dt", OracleDbType.Date), //赔付时间
new OracleParameter(":c_state", OracleDbType.Varchar2,100), //状态
new OracleParameter(":n_cycle", OracleDbType.Decimal,2), //处理周期
new OracleParameter(":c_month_average", OracleDbType.Varchar2,100), //月平均处理周期
new OracleParameter(":c_salesman", OracleDbType.Varchar2,100), //业务员
new OracleParameter(":n_flag", OracleDbType.Decimal,1), //标识：1 质量异议，2客户信息反馈 3:委托检验
new OracleParameter(":c_emp_id", OracleDbType.Varchar2,100), //系统操作人编号
new OracleParameter(":c_emp_name", OracleDbType.Varchar2,100), //系统操作人姓名
new OracleParameter(":n_status", OracleDbType.Decimal,1), //状态：-1未提交,0待处理,1审批中,2已完成
new OracleParameter(":c_crt_id", OracleDbType.Varchar2,100),//创建人ID
new OracleParameter(":C_ID", OracleDbType.Varchar2,100),
new OracleParameter(":C_SALESID", OracleDbType.Varchar2, 100)
}; //业务员ID
parameters[0].Value = model.C_area_id;
parameters[1].Value = model.C_distributor;
parameters[2].Value = model.C_directuser;
parameters[3].Value = model.C_contact;
parameters[4].Value = model.C_con_phone;
parameters[5].Value = model.C_grd;
parameters[6].Value = model.C_prod_use;
parameters[7].Value = model.D_ship_start_dt;
parameters[8].Value = model.D_ship_end_dt;
parameters[9].Value = model.N_object_count_wgt;
parameters[10].Value = model.C_object_content;
parameters[11].Value = model.C_tech_desc;
parameters[12].Value = model.C_site_survey_content;
parameters[13].Value = model.N_parent_qua;
parameters[14].Value = model.N_quest_qua;
parameters[15].Value = model.N_middle_qua;
parameters[16].Value = model.N_else_qua;
parameters[17].Value = model.C_dept;
parameters[18].Value = model.C_quality_dept;
parameters[19].Value = model.C_technology;
parameters[20].Value = model.C_qt;
parameters[21].Value = model.C_remark;
parameters[22].Value = model.C_cust_making;
parameters[23].Value = model.D_cust_making_dt;
parameters[24].Value = model.C_quality_result;
parameters[25].Value = model.C_objection_type;
parameters[26].Value = model.C_ourreasons;
parameters[27].Value = model.D_feedback_area;
parameters[28].Value = model.C_effect_valid;
parameters[29].Value = model.C_precc_result;
parameters[30].Value = model.N_amount;
parameters[31].Value = model.D_compensation_dt;
parameters[32].Value = model.C_state;
parameters[33].Value = model.N_cycle;
parameters[34].Value = model.C_month_average;
parameters[35].Value = model.C_salesman;
parameters[36].Value = model.N_flag;
parameters[37].Value = model.C_emp_id;
parameters[38].Value = model.C_emp_name;
parameters[39].Value = model.N_status;
parameters[40].Value = model.C_crt_id;
parameters[41].Value = model.C_id;
parameters[42].Value = model.C_salesid;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
#endregion
}
/// <summary>
/// 保存信息
/// </summary>
/// <param name="isShowMsg">是否显示弹出信息</param>
private void Save(bool isShowMsg)
{
var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
Mod_TMQ_QUA_MAIN mod = new Mod_TMQ_QUA_MAIN();
if (!string.IsNullOrEmpty(hid.Value))
{
mod = qua.GetModel(hid.Value);
hidQNO.Value = mod.C_No;
}
mod.C_emp_id = vUser.Id;
mod.C_emp_name = vUser.Name;
#region 保存信息
if (this.ddlArea.SelectedValue != "")
{
mod.C_area_id = ddlArea.SelectedItem.Text;
}
if (!string.IsNullOrEmpty(txtDistributor.Value))
{
mod.C_distributor = this.txtDistributor.Value.Trim();
}
if (!string.IsNullOrEmpty(txtDirectuser.Value))
{
mod.C_directuser = this.txtDirectuser.Value.Trim();
}
if (!string.IsNullOrEmpty(txtContact.Value))
{
mod.C_contact = txtContact.Value.Trim();
}
if (!string.IsNullOrEmpty(txtConPhone.Value))
{
mod.C_con_phone = txtConPhone.Value.Trim();
}
mod.C_grd = ddlGrd.SelectedItem.Text;
if (!string.IsNullOrEmpty(txtShipStart.Value))
{
mod.D_ship_start_dt = DateTime.Parse(txtShipStart.Value.Trim());
}
if (!string.IsNullOrEmpty(txtShipEnd.Value))
{
mod.D_ship_end_dt = DateTime.Parse(txtShipEnd.Value.Trim());
}
if (!string.IsNullOrEmpty(txtProUse.Value))
{
mod.C_prod_use = txtProUse.Value.Trim();
}
if (!string.IsNullOrEmpty(txtObjContent.Text))
{
mod.C_object_content = txtObjContent.Text.Trim();
}
if (!string.IsNullOrEmpty(txtTechDesc.Text))
{
mod.C_tech_desc = txtTechDesc.Text.Trim();
}
if (!string.IsNullOrEmpty(txtBz.Text))
{
mod.C_remark = txtBz.Text.Trim();
}
if (!string.IsNullOrEmpty(txtSite_SURVEY_CONTENT.Text))
{
mod.C_site_survey_content = txtSite_SURVEY_CONTENT.Text.Trim();
}
if (!string.IsNullOrEmpty(txtPARENT_QUA.Value))
{
mod.N_parent_qua = decimal.Parse(txtPARENT_QUA.Value.Trim());
}
if (!string.IsNullOrEmpty(txtQUEST_QUA.Value))
{
mod.N_quest_qua = decimal.Parse(txtQUEST_QUA.Value.Trim());
}
if (!string.IsNullOrEmpty(txtMIDDLE_QUA.Value))
{
mod.N_middle_qua = decimal.Parse(txtMIDDLE_QUA.Value.Trim());
}
if (!string.IsNullOrEmpty(txtELSE_QUA.Value))
{
mod.N_else_qua = decimal.Parse(txtELSE_QUA.Value.Trim());
}
if (!string.IsNullOrEmpty(txtDEPT.Value))
{
mod.C_dept = txtDEPT.Value.Trim();
}
if (!string.IsNullOrEmpty(txtQUALITY_DEPT.Value))
{
mod.C_quality_dept = txtQUALITY_DEPT.Value.Trim();
}
if (!string.IsNullOrEmpty(txtTECHNOLOGY.Value))
{
mod.C_technology = txtTECHNOLOGY.Value.Trim();
}
if (!string.IsNullOrEmpty(txtQT.Value))
{
mod.C_qt = txtQT.Value.Trim();
}
if (!string.IsNullOrEmpty(txtCUST_MAKING.Value))
{
mod.C_cust_making = txtCUST_MAKING.Value.Trim();
}
if (!string.IsNullOrEmpty(txtCUST_MAKING_DT.Value))
{
mod.D_cust_making_dt = DateTime.Parse(txtCUST_MAKING_DT.Value.Trim());
}
if (!string.IsNullOrEmpty(ddlType.SelectedValue) && this.ddlType.SelectedValue != "-1")
{
mod.N_flag = decimal.Parse(ddlType.SelectedValue);
}
if (!string.IsNullOrEmpty(txtSaleUser.Value))
{
mod.C_salesman = txtSaleUser.Value;
}
if (!string.IsNullOrEmpty(txtQUALITY_RESULT.Value))
{
mod.C_quality_result = txtQUALITY_RESULT.Value;
}
mod.C_objection_type = dropGrdType.SelectedValue;//钢种类型
if (dropQUEXIAN.SelectedValue != "-1")
{
mod.C_ourreasons = dropQUEXIAN.SelectedValue; //缺陷类别
}
if (!string.IsNullOrEmpty(txtPFDATE.Value)) //赔付日期
{
mod.D_compensation_dt = Convert.ToDateTime(txtPFDATE.Value);
}
if (!string.IsNullOrEmpty(txtPFMONEY.Value))//赔付金额
{
mod.N_amount = Convert.ToDecimal(txtPFMONEY.Value);
}
#endregion
if (!string.IsNullOrEmpty(hid.Value))
{
mod.C_id = hid.Value;
List <Mod_TMQ_QUA_ITEM> ls = AddListItem(vUser, mod);
mod.N_object_count_wgt = ls.Sum(x => x.N_object_wgt);
if (vUser.Roles.Where(x => x.C_CODE == RoleCode).Any())
{
mod.N_status = -1;
}
if (qua.AddListItem(ls, hid.Value) && qua.Update(mod) && isShowMsg)
{
Page pa = (Page)System.Web.HttpContext.Current.CurrentHandler;
ClientScript.RegisterClientScriptBlock(pa.GetType(), "aa", "<script language='javascript'>alert('修改成功');</script>");
}
}
else
{
if (vUser.Roles.Where(x => x.C_CODE == RoleCode).Any())
{
mod.N_status = -1;
}
mod.C_crt_id = vUser.Id;
mod.C_id = Guid.NewGuid().ToString();
List <Mod_TMQ_QUA_ITEM> ls = AddListItem(vUser, mod);
mod.N_object_count_wgt = ls.Sum(x => x.N_object_wgt);
if (qua.AddListItem(ls, mod.C_id) && qua.Add(mod) && isShowMsg)
{
Page pa = (Page)System.Web.HttpContext.Current.CurrentHandler;
ClientScript.RegisterClientScriptBlock(pa.GetType(), "aa", "<script language='javascript'>alert('添加成功');</script>");
}
hid.Value = mod.C_id;
hidQNO.Value = qua.GetModel(mod.C_id).C_No;
}
}
