/// <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 UpdateItem(Mod_TMQ_QUA_ITEM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMQ_QUA_ITEM set ");
strSql.Append("C_PARENTID=:C_PARENTID,");
strSql.Append("C_BRAND_NAME=:C_BRAND_NAME,");
strSql.Append("C_SPEC=:C_SPEC,");
strSql.Append("C_BATCH=:C_BATCH,");
strSql.Append("N_SHIPPEDQTY=:N_SHIPPEDQTY,");
strSql.Append("N_OBJECT_WGT=:N_OBJECT_WGT,");
strSql.Append("C_STL_CODE=:C_STL_CODE,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("C_EMP_NAME=:C_EMP_NAME,");
strSql.Append(" where C_ID=:C_ID and C_PARENTID=:C_PARENTID and C_BRAND_NAME=:C_BRAND_NAME and C_SPEC=:C_SPEC and C_BATCH=:C_BATCH and N_SHIPPEDQTY=:N_SHIPPEDQTY and N_OBJECT_WGT=:N_OBJECT_WGT and C_STL_CODE=:C_STL_CODE and C_EMP_ID=:C_EMP_ID and C_EMP_NAME=:C_EMP_NAME ");
OracleParameter[] parameters =
{
new OracleParameter(":C_PARENTID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BRAND_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BATCH", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SHIPPEDQTY", OracleDbType.Decimal, 15),
new OracleParameter(":N_OBJECT_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_STL_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_parentid;
parameters[1].Value = model.C_brand_name;
parameters[2].Value = model.C_spec;
parameters[3].Value = model.C_batch;
parameters[4].Value = model.N_shippedqty;
parameters[5].Value = model.N_object_wgt;
parameters[6].Value = model.C_stl_code;
parameters[7].Value = model.C_emp_id;
parameters[8].Value = model.C_emp_name;
parameters[9].Value = model.C_id;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public AjaxResult QualityPrdUpdate([FromBody] dynamic Json)
{
string ID = Json.ID; //产品ID
string ParentID = Json.ParentID; //主表ID
string Batch = Json.Batch; //批号
string BrandName = Json.BrandName; //牌号
string Spec = Json.Spec; //规格
string ShippedQty = Json.ShippedQty; //发货数量
string ObjectWgt = Json.ObjectWgt; //异议数量
string StlCode = Json.StlCode; //执行标准
AjaxResult result = new AjaxResult();
var vUser = GetUser();
if (vUser == null && ID == "")
{
result.Code = DoResult.Failed;
result.Result = "更新失败!";
return(result);
}
Mod_TMQ_QUA_ITEM mod = new Mod_TMQ_QUA_ITEM();
mod.C_id = ID;
if (!string.IsNullOrEmpty(ParentID))
{
mod.C_parentid = ParentID;
}
if (!string.IsNullOrEmpty(Batch))
{
mod.C_batch = Batch;
}
if (!string.IsNullOrEmpty(BrandName))
{
mod.C_brand_name = BrandName;
}
if (!string.IsNullOrEmpty(Spec))
{
mod.C_spec = Spec;
}
if (!string.IsNullOrEmpty(ShippedQty))
{
mod.N_shippedqty = decimal.Parse(ShippedQty);
}
if (!string.IsNullOrEmpty(ObjectWgt))
{
mod.N_object_wgt = decimal.Parse(ObjectWgt);
}
if (!string.IsNullOrEmpty(StlCode))
{
mod.C_stl_code = StlCode;
}
mod.C_emp_id = vUser.C_ID;
mod.C_emp_name = vUser.C_NAME;
if (qua.UpdateItem(mod))
{
result.Code = DoResult.Success;
result.Result = "更新成功!";
}
else
{
result.Code = DoResult.Failed;
result.Result = "更新失败!";
}
return(result);
}
public AjaxResult QualityPrdAdd([FromBody] dynamic Json)
{
string ParentID = Json.ParentID; //主表ID
string Batch = Json.Batch; //批号
string BrandName = Json.BrandName; //牌号
string Spec = Json.Spec; //规格
string ShippedQty = Json.ShippedQty; //发货数量
string ObjectWgt = Json.ObjectWgt; //异议数量
string StlCode = Json.StlCode; //执行标准
AjaxResult result = new AjaxResult();
var vUser = GetUser();
if (vUser == null)
{
result.Code = DoResult.Failed;
result.Result = "添加失败!";
return(result);
}
Mod_TMQ_QUA_ITEM mod = new Mod_TMQ_QUA_ITEM();
mod.C_id = Guid.NewGuid().ToString();
if (!string.IsNullOrEmpty(ParentID))
{
mod.C_parentid = ParentID;
}
if (!string.IsNullOrEmpty(Batch))
{
mod.C_batch = Batch;
}
if (!string.IsNullOrEmpty(BrandName))
{
mod.C_brand_name = BrandName;
}
if (!string.IsNullOrEmpty(Spec))
{
mod.C_spec = Spec;
}
if (!string.IsNullOrEmpty(ShippedQty))
{
mod.N_shippedqty = decimal.Parse(ShippedQty);
}
if (!string.IsNullOrEmpty(ObjectWgt))
{
mod.N_object_wgt = decimal.Parse(ObjectWgt);
}
if (!string.IsNullOrEmpty(StlCode))
{
mod.C_stl_code = StlCode;
}
mod.D_crt_dt = DateTime.Now;
mod.N_status = 0;
mod.C_emp_id = vUser.C_ID;
mod.C_emp_name = vUser.C_NAME;
mod.C_emp_dt = DateTime.Now;
if (qua.AddItem(mod) && qua.UpdateSumWgt(mod.C_parentid))
{
result.Code = DoResult.Success;
result.Result = mod.C_id;
}
else
{
result.Code = DoResult.Failed;
result.Result = "添加失败!";
}
return(result);
}
public bool UpdateItem(Mod_TMQ_QUA_ITEM model)
{
return(dal.UpdateItem(model));
}
public bool AddItem(Mod_TMQ_QUA_ITEM model)
{
return(dal.AddItem(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool AddItem(Mod_TMQ_QUA_ITEM model)
{
#region 新增字表
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tmq_qua_item(");
strSql.Append(@" c_id,
c_parentid,
c_brand_name,
c_spec,
c_batch,
n_shippedqty,
n_object_wgt,
c_stl_code,
c_emp_id,
c_emp_name,
n_status,
c_crt_id)values (
:c_id,
:c_parentid,
:c_brand_name,
:c_spec,
:c_batch,
:n_shippedqty,
:n_object_wgt,
:c_stl_code,
:c_emp_id,
:c_emp_name,
:n_status,
:c_crt_id)");
OracleParameter[] parameters =
{
new OracleParameter(":c_id", OracleDbType.Varchar2, 100),
new OracleParameter(":c_parentid", OracleDbType.Varchar2, 100),
new OracleParameter(":c_brand_name", OracleDbType.Varchar2, 100),
new OracleParameter(":c_spec", OracleDbType.Varchar2, 100),
new OracleParameter(":c_batch", OracleDbType.Varchar2, 100),
new OracleParameter(":n_shippedqty", OracleDbType.Decimal, 15),
new OracleParameter(":n_object_wgt", OracleDbType.Decimal, 15),
new OracleParameter(":c_stl_code", OracleDbType.Varchar2, 100),
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_crt_id", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_id;
parameters[1].Value = model.C_parentid;
parameters[2].Value = model.C_brand_name;
parameters[3].Value = model.C_spec;
parameters[4].Value = model.C_batch;
parameters[5].Value = model.N_shippedqty;
parameters[6].Value = model.N_object_wgt;
parameters[7].Value = model.C_stl_code;
parameters[8].Value = model.C_emp_id;
parameters[9].Value = model.C_emp_name;
parameters[10].Value = model.N_status;
parameters[11].Value = model.C_crt_id;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
#endregion
}
