public static void AddMailOfWFInfo(WF_GetMailOfWFInfo info) { DataTable dt = GetMailOfWFInfoBySN(info.SN, info.ApproveLeaderEmail); if (dt == null || dt.Rows.Count == 0) { InsertMailInfoOfWFInfo(info); } else { UpdateMailInfoOfWFInfo(info.SN, info.Status); } }
public static DataTable InsertMailInfoOfWFInfo(WF_GetMailOfWFInfo info) { DataProvider dataProvider = new DataProvider(); dataProvider.ConnectionString = connectionString;// System.Configuration.ConfigurationManager.ConnectionStrings["BPMConnectionString"].ConnectionString; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@InstanceID", System.Data.SqlDbType.NVarChar, 100), new SqlParameter("@SN", System.Data.SqlDbType.NVarChar, 20), new SqlParameter("@FormTitle", System.Data.SqlDbType.NVarChar, 300), new SqlParameter("@ApproveLeader", System.Data.SqlDbType.NVarChar, 2000), new SqlParameter("@Status", System.Data.SqlDbType.NVarChar, 10), new SqlParameter("@ApproveLeaderEmail", System.Data.SqlDbType.NVarChar, 300) }; parameters[0].Value = info.InstanceID; parameters[1].Value = info.SN; parameters[2].Value = info.FormTitle; parameters[3].Value = info.ApproveLeader; parameters[4].Value = info.Status; parameters[5].Value = info.ApproveLeaderEmail; DataTable dataTable = dataProvider.ExecutedProcedure("wf_usp_InsertMailInfoOfWF", parameters); return(dataTable); }