/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMC_ROLL_APPLY_ITEM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMC_ROLL_APPLY_ITEM(");
strSql.Append("C_ID,C_PKID,C_NEEDAREA,C_NEEDCUST,C_ZYAREA,C_ZYCUST,C_SPEC,C_STL_GRD,C_WGT,C_QUA,C_REMARK,C_VFREE1,C_VFREE2,C_VFREE3,C_VFREE4,C_VFREE5,C_ZYCON)");
strSql.Append(" values (");
strSql.Append(":C_ID,:C_PKID,:C_NEEDAREA,:C_NEEDCUST,:C_ZYAREA,:C_ZYCUST,:C_SPEC,:C_STL_GRD,:C_WGT,:C_QUA,:C_REMARK,:C_VFREE1,:C_VFREE2,:C_VFREE3,:C_VFREE4,:C_VFREE5,:C_ZYCON)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEEDAREA", OracleDbType.Varchar2, 200),
new OracleParameter(":C_NEEDCUST", OracleDbType.Varchar2, 200),
new OracleParameter(":C_ZYAREA", OracleDbType.Varchar2, 200),
new OracleParameter(":C_ZYCUST", OracleDbType.Varchar2, 200),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_WGT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_QUA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_VFREE1", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VFREE2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VFREE3", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VFREE4", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VFREE5", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYCON", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_PKID;
parameters[2].Value = model.C_NEEDAREA;
parameters[3].Value = model.C_NEEDCUST;
parameters[4].Value = model.C_ZYAREA;
parameters[5].Value = model.C_ZYCUST;
parameters[6].Value = model.C_SPEC;
parameters[7].Value = model.C_STL_GRD;
parameters[8].Value = model.C_WGT;
parameters[9].Value = model.C_QUA;
parameters[10].Value = model.C_REMARK;
parameters[11].Value = model.C_VFREE1;
parameters[12].Value = model.C_VFREE2;
parameters[13].Value = model.C_VFREE3;
parameters[14].Value = model.C_VFREE4;
parameters[15].Value = model.C_VFREE5;
parameters[16].Value = model.C_ZYCON;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
bool result = false;
for (int i = 0; i < rptList.Items.Count; i++)
{
HtmlInputCheckBox cbxselect = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxselect");
if (cbxselect.Checked)
{
Literal ltlsalearea = (Literal)rptList.Items[i].FindControl("ltlsalearea");
Literal ltlbatch = (Literal)rptList.Items[i].FindControl("ltlbatch");
Literal ltlstlgrd = (Literal)rptList.Items[i].FindControl("ltlstlgrd");
Literal ltlspec = (Literal)rptList.Items[i].FindControl("ltlspec");
Literal ltlN_WGT = (Literal)rptList.Items[i].FindControl("ltlN_WGT");
Literal ltllev = (Literal)rptList.Items[i].FindControl("ltllev");
Literal ltlpack = (Literal)rptList.Items[i].FindControl("ltlpack");
Literal ltlmatcode = (Literal)rptList.Items[i].FindControl("ltlmatcode");
Literal ltlC_CUST_NAME = (Literal)rptList.Items[i].FindControl("ltlC_CUST_NAME");
Literal ltlstdcode = (Literal)rptList.Items[i].FindControl("ltlstdcode");
Literal ltlC_CON_NO = (Literal)rptList.Items[i].FindControl("ltlC_CON_NO");
var mod = new Mod_TMC_ROLL_APPLY_ITEM()
{
C_ID = Guid.NewGuid().ToString("N"),
C_PKID = ltlID.Text,
C_NEEDAREA = dropneedarea.SelectedValue, //需求区域
C_NEEDCUST = txtC_CGC.Value.Trim() == "" ? ltlC_CUST_NAME.Text : txtC_CGC.Value.Trim(), //需求客户
C_QUA = txtNeedCon.Text.Trim() == "" ? ltlC_CON_NO.Text : txtNeedCon.Text.Trim(), //需求合同
C_ZYAREA = ltlsalearea.Text, //原资源区域
C_ZYCUST = ltlC_CUST_NAME.Text, //原资源客户信息
C_SPEC = ltlspec.Text,
C_STL_GRD = ltlstlgrd.Text,
C_WGT = Convert.ToDecimal(ltlN_WGT.Text),
C_VFREE1 = ltlbatch.Text, //批次
C_VFREE2 = ltlmatcode.Text, //物料编码
C_VFREE3 = cbxselect.Value, //线材主键
C_VFREE4 = ltlpack.Text, //包装
C_VFREE5 = ltllev.Text, //质量
C_REMARK = ltlstdcode.Text, //执行标准
C_ZYCON = ltlC_CON_NO.Text //原资源合同
};
result = tmc_roll_apply_item.Add(mod);
}
}
if (result)
{
Response.Write("<script>window.parent.document.getElementById('imgbtnJz').click();window.parent.close();</script>");
}
}
catch (Exception ex)
{
WebMsg.MessageBox(ex.Message);
}
}
//删除行
protected void btnDel_Click(object sender, EventArgs e)
{
List <Mod_TMC_ROLL_APPLY_ITEM> list = new List <Mod_TMC_ROLL_APPLY_ITEM>();
for (int i = 0; i < rptList.Items.Count; i++)
{
HtmlInputCheckBox cbxselect = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxselect");
if (cbxselect.Checked)
{
var mod = new Mod_TMC_ROLL_APPLY_ITEM()
{
C_ID = cbxselect.Value
};
list.Add(mod);
}
}
if (tmc_roll_apply_item.DelList(list))
{
GetList();
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMC_ROLL_APPLY_ITEM GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_PKID,C_NEEDAREA,C_NEEDCUST,C_ZYAREA,C_ZYCUST,C_SPEC,C_STL_GRD,C_WGT,C_QUA,C_REMARK,C_VFREE1,C_VFREE2,C_VFREE3,C_VFREE4,C_VFREE5,D_MOD from TMC_ROLL_APPLY_ITEM ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
};
Mod_TMC_ROLL_APPLY_ITEM model = new Mod_TMC_ROLL_APPLY_ITEM();
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>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMC_ROLL_APPLY_ITEM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMC_ROLL_APPLY_ITEM set ");
strSql.Append("C_ID=:C_ID,");
strSql.Append("C_PKID=:C_PKID,");
strSql.Append("C_NEEDAREA=:C_NEEDAREA,");
strSql.Append("C_NEEDCUST=:C_NEEDCUST,");
strSql.Append("C_ZYAREA=:C_ZYAREA,");
strSql.Append("C_ZYCUST=:C_ZYCUST,");
strSql.Append("C_SPEC=:C_SPEC,");
strSql.Append("C_STL_GRD=:C_STL_GRD,");
strSql.Append("C_WGT=:C_WGT,");
strSql.Append("C_QUA=:C_QUA,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_VFREE1=:C_VFREE1,");
strSql.Append("C_VFREE2=:C_VFREE2,");
strSql.Append("C_VFREE3=:C_VFREE3,");
strSql.Append("C_VFREE4=:C_VFREE4,");
strSql.Append("C_VFREE5=:C_VFREE5,");
strSql.Append("D_MOD=:D_MOD");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PKID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEEDAREA", OracleDbType.Varchar2, 200),
new OracleParameter(":C_NEEDCUST", OracleDbType.Varchar2, 200),
new OracleParameter(":C_ZYAREA", OracleDbType.Varchar2, 200),
new OracleParameter(":C_ZYCUST", OracleDbType.Varchar2, 200),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_WGT", OracleDbType.Decimal, 100),
new OracleParameter(":C_QUA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_VFREE1", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VFREE2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VFREE3", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VFREE4", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VFREE5", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD", OracleDbType.Date)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_PKID;
parameters[2].Value = model.C_NEEDAREA;
parameters[3].Value = model.C_NEEDCUST;
parameters[4].Value = model.C_ZYAREA;
parameters[5].Value = model.C_ZYCUST;
parameters[6].Value = model.C_SPEC;
parameters[7].Value = model.C_STL_GRD;
parameters[8].Value = model.C_WGT;
parameters[9].Value = model.C_QUA;
parameters[10].Value = model.C_REMARK;
parameters[11].Value = model.C_VFREE1;
parameters[12].Value = model.C_VFREE2;
parameters[13].Value = model.C_VFREE3;
parameters[14].Value = model.C_VFREE4;
parameters[15].Value = model.C_VFREE5;
parameters[16].Value = model.D_MOD;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMC_ROLL_APPLY_ITEM DataRowToModel(DataRow row)
{
Mod_TMC_ROLL_APPLY_ITEM model = new Mod_TMC_ROLL_APPLY_ITEM();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_PKID"] != null)
{
model.C_PKID = row["C_PKID"].ToString();
}
if (row["C_NEEDAREA"] != null)
{
model.C_NEEDAREA = row["C_NEEDAREA"].ToString();
}
if (row["C_NEEDCUST"] != null)
{
model.C_NEEDCUST = row["C_NEEDCUST"].ToString();
}
if (row["C_ZYAREA"] != null)
{
model.C_ZYAREA = row["C_ZYAREA"].ToString();
}
if (row["C_ZYCUST"] != null)
{
model.C_ZYCUST = row["C_ZYCUST"].ToString();
}
if (row["C_SPEC"] != null)
{
model.C_SPEC = row["C_SPEC"].ToString();
}
if (row["C_STL_GRD"] != null)
{
model.C_STL_GRD = row["C_STL_GRD"].ToString();
}
if (row["C_WGT"] != null)
{
model.C_WGT = Convert.ToDecimal(row["C_WGT"].ToString());
}
if (row["C_QUA"] != null)
{
model.C_QUA = row["C_QUA"].ToString();
}
if (row["C_REMARK"] != null)
{
model.C_REMARK = row["C_REMARK"].ToString();
}
if (row["C_VFREE1"] != null)
{
model.C_VFREE1 = row["C_VFREE1"].ToString();
}
if (row["C_VFREE2"] != null)
{
model.C_VFREE2 = row["C_VFREE2"].ToString();
}
if (row["C_VFREE3"] != null)
{
model.C_VFREE3 = row["C_VFREE3"].ToString();
}
if (row["C_VFREE4"] != null)
{
model.C_VFREE4 = row["C_VFREE4"].ToString();
}
if (row["C_VFREE5"] != null)
{
model.C_VFREE5 = row["C_VFREE5"].ToString();
}
if (row["D_MOD"] != null && row["D_MOD"].ToString() != "")
{
model.D_MOD = DateTime.Parse(row["D_MOD"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMC_ROLL_APPLY_ITEM model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMC_ROLL_APPLY_ITEM model)
{
return(dal.Add(model));
}
