//保存数据
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;
}
}
