public bool InsertItem(Mod_TQC_ZZS_FILE mod)
{
string strSql = $"INSERT INTO TQC_ZZS_FILE (C_BATCH_NO,C_STOVE,C_SPEC,C_STL_GRD,C_STD_CODE,C_PDF_PATCH,C_EMP_ID)VALUES(";
strSql += $"'{mod.C_BATCH_NO}',";
strSql += $"'{mod.C_STOVE}',";
strSql += $"'{mod.C_SPEC}',";
strSql += $"'{mod.C_STL_GRD}',";
strSql += $"'{mod.C_STD_CODE}',";
strSql += $"'{mod.C_PDF_PATCH}',";
strSql += $"'{mod.C_EMP_ID}'";
strSql += ")";
return(DbHelperOra.ExecuteSql(strSql) > 0 ? true : false);
}
//上传附件
protected void Button2_Click(object sender, EventArgs e)
{
bool frist = true;
bool result = false;
var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
for (int i = 0; i < rptList.Items.Count; i++)
{
HtmlInputCheckBox cbxID = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxID");
if (cbxID.Checked)
{
Literal ltlC_BATCH_NO = (Literal)rptList.Items[i].FindControl("ltlC_BATCH_NO");
Literal ltlC_STOVE = (Literal)rptList.Items[i].FindControl("ltlC_STOVE");
Literal ltlC_STD_CODE = (Literal)rptList.Items[i].FindControl("ltlC_STD_CODE");
Literal ltlC_STL_GRD = (Literal)rptList.Items[i].FindControl("ltlC_STL_GRD");
Literal ltlC_SPEC = (Literal)rptList.Items[i].FindControl("ltlC_SPEC");
if (!tqc_zzs_file.ExistsZZS(ltlC_BATCH_NO.Text, ltlC_STL_GRD.Text, ltlC_STOVE.Text, ltlC_STD_CODE.Text))
{
#region //上传附件
string filetype = Path.GetExtension(file1.PostedFile.FileName);
string filename = Path.GetFileNameWithoutExtension(file1.PostedFile.FileName); //文件名；
string newfilename = ltlC_BATCH_NO.Text + "(" + GetTime() + ")" + filetype; //+
string path = "~/files/";
string savepath = System.Web.HttpContext.Current.Server.MapPath(path) + newfilename;
file1.PostedFile.SaveAs(savepath);
string dz = path + newfilename;
#endregion
var mod = new Mod_TQC_ZZS_FILE()
{
C_BATCH_NO = ltlC_BATCH_NO.Text,
C_STOVE = ltlC_STOVE.Text,
C_STD_CODE = ltlC_STD_CODE.Text,
C_STL_GRD = ltlC_STL_GRD.Text,
C_SPEC = ltlC_SPEC.Text,
C_PDF_PATCH = dz,
C_EMP_ID = vUser.Name
};
result = tqc_zzs_file.InsertItem(mod);
}
else
{
#region //上传附件
string filetype = Path.GetExtension(file1.PostedFile.FileName);
string filename = Path.GetFileNameWithoutExtension(file1.PostedFile.FileName); //文件名；
string newfilename = ltlC_BATCH_NO.Text + "(" + GetTime() + ")" + filetype; //+
string path = "~/files/";
string savepath = System.Web.HttpContext.Current.Server.MapPath(path) + newfilename;
file1.PostedFile.SaveAs(savepath);
string dz = path + newfilename;
#endregion
var mod = new Mod_TQC_ZZS_FILE()
{
C_BATCH_NO = ltlC_BATCH_NO.Text,
C_STOVE = ltlC_STOVE.Text,
C_STD_CODE = ltlC_STD_CODE.Text,
C_STL_GRD = ltlC_STL_GRD.Text,
C_SPEC = ltlC_SPEC.Text,
C_PDF_PATCH = dz,
C_EMP_ID = vUser.Name
};
result = tqc_zzs_file.UpdateItem(mod);
}
frist = false;
break;
}
}
if (result)
{
WebMsg.MessageBox("上传成功");
GetList();
}
}
public bool UpdateItem(Mod_TQC_ZZS_FILE mod)
{
string strSql = $@"UPDATE TQC_ZZS_FILE SET C_PDF_PATCH='{mod.C_PDF_PATCH}' WHERE C_BATCH_NO='{mod.C_BATCH_NO}' AND C_STOVE='{mod.C_STOVE}' AND C_STL_GRD='{mod.C_STL_GRD}' AND C_STD_CODE='{mod.C_STD_CODE}'";
return(DbHelperOra.ExecuteSql(strSql) > 0 ? true : false);
}
public bool UpdateItem(Mod_TQC_ZZS_FILE mod)
{
return(dal.UpdateItem(mod));
}
public bool InsertItem(Mod_TQC_ZZS_FILE mod)
{
return(dal.InsertItem(mod));
}
