public int addEmail(Tz888.Model.Email.EmailModel model, List <Tz888.Model.Email.EmailAnnexModel> EmailAnnex)
{
int flag = 0;
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@Email_Name", model.Email_Name),
new SqlParameter("@Email_RUser", model.Email_RUser),
new SqlParameter("@Email_Content", model.Email_Content),
new SqlParameter("@Email_AddTime", model.Email_AddTime),
new SqlParameter("@Email_IsSuc", model.Email_IsSuc),
};
DataSet ds = Tz888.DBUtility.DbHelperSQL.RunProcedures("proc_Email_add", param, "ds");
if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
flag = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
if (flag > 0 && EmailAnnex != null && EmailAnnex.Count > 0)
{
for (int i = 0; i < EmailAnnex.Count; i++)
{
Tz888.Model.Email.EmailAnnexModel amodel = EmailAnnex[i];
amodel.Annex_EmailID = flag;
string sqlStr2 = "insert into EmailAnnexTab(Annex_EmailID,Annex_Name,Annex_Addr)" +
" values (" + flag + ",'" + amodel.Annex_Name + "','" + amodel.Annex_Addr + "')";
int aflag = Tz888.DBUtility.DbHelperSQL.ExecuteSql(sqlStr2);
}
}
}
return(flag);
}
public int addEmail(Tz888.Model.Email.EmailModel model, List <Tz888.Model.Email.EmailAnnexModel> EmailAnnex)
{
return(dal.addEmail(model, EmailAnnex));
}
