//保存数据 public void SaveData(SaveDataModel data, IDbTransaction tran, string caseId) { try { if (caseId != null) data.baseInfo.CaseID = caseId; int meetingID = 0; data.baseInfo.Condition.Add("CaseID=" + data.baseInfo.CaseID); StringBuilder strSql = new StringBuilder(); //更新或插入主业务信息 data.baseInfo.MeetingDate = DateTime.Parse(data.baseInfo.StartTime.ToString("yyyy-MM-dd")); if (Utility.Database.Update<B_OA_Meeting>(data.baseInfo, tran) < 1) { Utility.Database.Insert<B_OA_Meeting>(data.baseInfo, tran); } } catch (Exception e) { ComBase.Logger(e); throw e; } }
//保存数据 public void SaveData(SaveDataModel data, IDbTransaction tran, string caseId) { try { if (caseId != null) data.baseInfo.CaseID = caseId; int meetingID = 0; data.baseInfo.Condition.Add("CaseID=" + data.baseInfo.CaseID); StringBuilder strSql = new StringBuilder(); //更新或插入主业务信息 if (Utility.Database.Update<B_OA_Meeting>(data.baseInfo, tran) < 1) { if (Utility.Database.Insert<B_OA_Meeting>(data.baseInfo, tran) > 0) { //取得当前工作班次 strSql = new StringBuilder(); strSql.Append("SELECT @@IDENTITY AS MeetingID FROM B_OA_Meeting"); DataSet dataSet = Utility.Database.ExcuteDataSet(strSql.ToString(), tran); if (dataSet.Tables[0].Rows.Count > 0) { if (dataSet.Tables[0].Rows.Count > 0) meetingID = Convert.ToInt32(dataSet.Tables[0].Rows[0]["MeetingID"]); } } } else { meetingID = data.baseInfo.MeetingID; //删除参数人员表信息 strSql.Append("DELETE FROM B_OA_Participant WHERE MeetingID = " + meetingID); Utility.Database.ExecuteNonQuery(strSql.ToString(), tran); } //插入参会人员 string[] pItem = data.baseInfo.ParticipantNameid.Split(';'); for (int i = 0; i < pItem.Length; i++) { if (pItem[i].ToString().Trim() == "") continue; B_OA_Participant participant = new B_OA_Participant(); participant.MeetingID = meetingID; participant.UserID = pItem[i]; Utility.Database.Insert<B_OA_Participant>(participant, tran); } } catch (Exception e) { ComBase.Logger(e); throw e; } }