public static DataTable DeleteMailOfWFHistoryInfo(WF_GetMailOfWFHistoryInfo info) { DataProvider dataProvider = new DataProvider(); dataProvider.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BPMConnectionString"].ConnectionString; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@InstanceID", System.Data.SqlDbType.NVarChar, 100) }; parameters[0].Value = info.InstanceID; DataTable dataTable = dataProvider.ExecutedProcedure("Biz.usp_DeleteMailInfoOfWFHistory", parameters); return(dataTable); }
public static DataTable InsertMailInfoOfWFHistoryInfo(WF_GetMailOfWFHistoryInfo info) { DataProvider dataProvider = new DataProvider(); dataProvider.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("Biz.usp_InsertMailInfoOfWFHistory", parameters); return(dataTable); }