/// <summary>
/// 添加实验室
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDepSave_Click(object sender, EventArgs e)
{
try
{
StringBuilder sb = new StringBuilder();
SortedList SQLlist = new SortedList(new MySort());
if (DictUserId != 0)
{
if (gdDep.SelectedRowIndexArray.Length != 0)
{
var library = new DictuserandlabdeptService();
Dictuserandlabdept userdep = new Dictuserandlabdept();
userdep.Dictuserid = DictUserId;
Hashtable hts = new Hashtable();
hts.Add("value", userdep.Dictuserid);
SQLlist.Add(new Hashtable()
{
{ "DELETE", "Dict.DeleteDictuserandlabdeptByUserId" }
}, userdep.Dictuserid);
foreach (int row in gdDep.SelectedRowIndexArray)
{
Dictuserandlabdept dictuserandlabdep = new Dictuserandlabdept();
dictuserandlabdep.Dictuserandlabdeptid = library.getSeqID("SEQ_DICTUSERANDLABDEPT");
dictuserandlabdep.Dictlabdeptid = Convert.ToDouble(gdDep.DataKeys[row][0].ToString());
dictuserandlabdep.Dictuserid = Convert.ToInt32(DictUserId);
dictuserandlabdep.Createdate = DateTime.Now;
SQLlist.Add(new Hashtable()
{
{ "INSERT", "Dict.InsertDictuserandlabdept" }
}, dictuserandlabdep);
}
if (library.ExecuteSqlTran(SQLlist))
{
BindGridDep();
MessageBoxShow("所选实验室已成功保存,需重新登陆数据才能生效！", MessageBoxIcon.Information);
}
else
{
MessageBoxShow("所选实验室添加有误！", MessageBoxIcon.Warning);
}
}
else
{
MessageBoxShow("您未选择实验室！", MessageBoxIcon.Warning);
}
}
else
{
MessageBoxShow("您还未选择用户！", MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
MessageBoxShow(ex.Message, MessageBoxIcon.Error);
}
}
/// <summary>
/// 获取体检单位详细信息
/// </summary>
/// <param name="usercode"></param>
/// <returns></returns>
public Dictuserandlabdept GetDictuserandlabdeptInfo(Dictuserandlabdept library)
{
//Dictuserandlabdept obj = null;
//IList lst = this.selectIList("Dict.GetDictuserandlabdeptInfo", library);
//if (lst.Count > 0)
// obj = (Dictuserandlabdept)lst[0];
//return obj;
return(this.selectObj <Dictuserandlabdept>("Dict.GetDictuserandlabdeptInfo", library));
}
///<summary>
///新增编辑后保存
///</summary>
///<param name="library"></param>
/// <returns></returns>
public bool SaveDictuserandlabdept(Dictuserandlabdept library)
{
int nflag = 0;
//新增
if (library.Dictuserandlabdeptid == 0 || library.Dictuserandlabdeptid == null)
{
try
{
library.Dictuserandlabdeptid = getSeqID("SEQ_DICTUSERANDLABDEPT");
insert("Dict.InsertDictuserandlabdept", library);
nflag = 1;
List <LogInfo> logLst = getLogInfo <Dictuserandlabdept>(new Dictuserandlabdept(), library);
Dictlabdept dictlabdep = new Dictlabdept();
dictlabdep.Dictlabdeptid = library.Dictlabdeptid;
dictlabdep = new DictlabdeptService().GetDictlabdeptInfo(dictlabdep);
AddMaintenanceLog("Dictuserandlabdept", int.Parse(library.Dictuserandlabdeptid.ToString()), logLst, "新增", dictlabdep.Labdeptname, library.Createdate.ToString(), modulename);
}
catch (Exception ex)
{
nflag = 0;
throw new Exception(ex.Message);
}
}
else//保存
{
try
{
Dictuserandlabdept dictcustomer = GetDictuserandlabdeptInfo(library);
nflag = update("Dict.UpdateDictuserandlabdept", library);
List <LogInfo> logLst = getLogInfo <Dictuserandlabdept>(dictcustomer, library);
Dictlabdept dictlabdep = new Dictlabdept();
dictlabdep.Dictlabdeptid = library.Dictlabdeptid;
dictlabdep = new DictlabdeptService().GetDictlabdeptInfo(dictlabdep);
AddMaintenanceLog("Dictuserandlabdept", int.Parse(library.Dictuserandlabdeptid.ToString()), logLst, "修改", dictlabdep.Labdeptname, library.Createdate.ToString(), modulename);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
return(nflag > 0);
}
