partial void DeleteSys_UserMaster_usm(Sys_UserMaster_usm instance);
partial void UpdateSys_UserMaster_usm(Sys_UserMaster_usm instance);
partial void InsertSys_UserMaster_usm(Sys_UserMaster_usm instance);
public bool IsExistRecord(object KeyObject)
{
using (MainDBDataContext db = new MainDBDataContext())
{
Sys_UserMaster_usm usm = new Sys_UserMaster_usm();
try
{
usm = Common.General.CopyObjectValue<object, Sys_UserMaster_usm>(KeyObject);
IQueryable<Sys_UserMaster_usm> taQuery =
(from ta in db.Sys_UserMaster_usm where ta.usm_cUserLoginID == usm.usm_cUserLoginID select ta);
if (taQuery.Count() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception Ex)
{
throw Ex;
}
}
}
public bool InsertRecord(Model.SysMaster.Sys_UserMaster_usm_Info infoObject)
{
using (MainDBDataContext db = new MainDBDataContext())
{
Sys_UserMaster_usm usm = new Sys_UserMaster_usm();
List<Sys_UserRoles_usr> usrs = new List<Sys_UserRoles_usr>();
try
{
usm = Common.General.CopyObjectValue<Sys_UserMaster_usm_Info, Sys_UserMaster_usm>(infoObject);
if (infoObject.roleMasterList != null && infoObject.roleMasterList.Count > 0)
{
for (int i = 0; i < infoObject.roleMasterList.Count; i++)
{
Sys_RoleMaster_rlm_Info usmInfo = infoObject.roleMasterList[i];
Sys_UserRoles_usr item = new Sys_UserRoles_usr();
item.usr_cUserLoginID = infoObject.usm_cUserLoginID;
item.usr_cRoleID = usmInfo.rlm_cRoleID;
usrs.Add(item);
}
}
db.Sys_UserRoles_usr.InsertAllOnSubmit(usrs);
db.Sys_UserMaster_usm.InsertOnSubmit(usm);
db.SubmitChanges();
return true;
}
catch (Exception Ex)
{
throw Ex;
}
}
}
public bool UpdateRecord(Model.SysMaster.Sys_UserMaster_usm_Info infoObject)
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
Sys_UserMaster_usm usm = new Sys_UserMaster_usm();
try
{
usm = db.Sys_UserMaster_usm.SingleOrDefault(t => t.usm_iRecordID == infoObject.usm_iRecordID);
for (int i = 0; i < usm.Sys_UserRoles_usr.Count; i++)
{
Sys_UserRoles_usr sta = usm.Sys_UserRoles_usr[i];
db.Sys_UserRoles_usr.DeleteOnSubmit(sta);
}
string sqlString = string.Empty;
Sys_UserMaster_usm_Info info = new Sys_UserMaster_usm_Info();
info = Common.General.CopyObjectValue<Sys_UserMaster_usm, Sys_UserMaster_usm_Info>(usm);
IEnumerable<Sys_UserMaster_usm_Info> IEusm = null;
IEnumerable<Sys_UserRoles_usr_Info> IEusr = null;
sqlString += "UPDATE Sys_UserMaster_usm" + Environment.NewLine;
sqlString += " SET usm_cUserLoginID='" + infoObject.usm_cUserLoginID + "'," + Environment.NewLine;
sqlString += " usm_cChaName='" + infoObject.usm_cChaName + "'," + Environment.NewLine;
if (infoObject.usm_cPwd != null && infoObject.usm_cPwd != "")
{
sqlString += " usm_cPwd='" + infoObject.usm_cPwd + "'," + Environment.NewLine;
}
sqlString += " usm_cEMail='" + infoObject.usm_cEmail + "'," + Environment.NewLine;
sqlString += " usm_iLock='" + infoObject.usm_iLock + "'," + Environment.NewLine;
sqlString += " usm_cLast='" + infoObject.usm_cLast + "'," + Environment.NewLine;
sqlString += " usm_dLastDate='" + infoObject.usm_dLastDate.ToString(DefineConstantValue.gc_DateTimeFormat) + "'" + Environment.NewLine;
sqlString += " WHERE usm_iRecordID='" + infoObject.usm_iRecordID + "'";
IEusm = db.ExecuteQuery<Sys_UserMaster_usm_Info>(sqlString, new object[] { });
sqlString = string.Empty;
sqlString += "DELETE FROM Sys_UserRoles_usr WHERE usr_cUserLoginID='" + infoObject.usm_cUserLoginID + "'";
IEusr = db.ExecuteQuery<Sys_UserRoles_usr_Info>(sqlString, new object[] { });
if (infoObject.roleMasterList != null && infoObject.roleMasterList.Count > 0)
{
for (int i = 0; i < infoObject.roleMasterList.Count; i++)
{
sqlString = string.Empty;
Sys_RoleMaster_rlm_Info rlmInfo = infoObject.roleMasterList[i];
sqlString += "INSERT INTO Sys_UserRoles_usr" + Environment.NewLine;
sqlString += "(usr_cUserLoginID, usr_cRoleID)" + Environment.NewLine;
sqlString += " VALUES " + Environment.NewLine;
sqlString += "('" + infoObject.usm_cUserLoginID + "','" + rlmInfo.rlm_cRoleID + "')";
IEusr = db.ExecuteQuery<Sys_UserRoles_usr_Info>(sqlString, new object[] { });
}
}
return true;
}
catch (Exception Ex)
{
throw Ex;
}
}
}
