partial void DeleteSys_FunctionMaster_fum(Sys_FunctionMaster_fum instance);
partial void UpdateSys_FunctionMaster_fum(Sys_FunctionMaster_fum instance);
partial void InsertSys_FunctionMaster_fum(Sys_FunctionMaster_fum instance);
public bool UpdateRecord(Sys_FunctionMaster_fum_Info infoObject)
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
Sys_FunctionMaster_fum fum = new Sys_FunctionMaster_fum();
try
{
//fum = db.Sys_FunctionMaster_fum.SingleOrDefault(t => t.fum_iRecordID == infoObject.fum_iRecordID);
//for (int i = 0; i < fum.Sys_FormPurview_frps.Count; i++)
//{
// Sys_FormPurview_frp sta = fum.Sys_FormPurview_frps[i];
// db.Sys_FormPurview_frps.DeleteOnSubmit(sta);
//}
string sqlString = string.Empty;
Sys_FunctionMaster_fum_Info info = new Sys_FunctionMaster_fum_Info();
//info = Common.General.CopyObjectValue<Sys_FunctionMaster_fum, Sys_FunctionMaster_fum_Info>(fum);
IEnumerable<Sys_FunctionMaster_fum_Info> IEfum = null;
IEnumerable<Sys_FormPurview_frp_Info> IEfrp = null;
sqlString += "UPDATE Sys_FunctionMaster_fum" + Environment.NewLine;
sqlString += " SET fum_cFunctionNumber='" + infoObject.fum_cFunctionNumber + "'," + Environment.NewLine;
sqlString += " fum_cFunctionDesc='" + infoObject.fum_cFunctionDesc + "'," + Environment.NewLine;
sqlString += " fum_cRemark='" + infoObject.fum_cRemark + "'," + Environment.NewLine;
sqlString += " fum_cLast='" + infoObject.fum_cLast + "'," + Environment.NewLine;
sqlString += " fum_dLastDate='" + infoObject.fum_dLastDate.Value.ToString(DefineConstantValue.gc_DateTimeFormat) + "'" + Environment.NewLine;
sqlString += " WHERE fum_iRecordID='" + infoObject.fum_iRecordID + "'";
IEfum = db.ExecuteQuery<Sys_FunctionMaster_fum_Info>(sqlString, new object[] { });
sqlString = string.Empty;
sqlString += "DELETE FROM Sys_FormPurview_frp WHERE frp_cFunctionNumber='" + infoObject.fum_cFunctionNumber + "'";
IEfrp = db.ExecuteQuery<Sys_FormPurview_frp_Info>(sqlString, new object[] { });
if (infoObject.formMaster != null && infoObject.formMaster.Count > 0)
{
for (int i = 0; i < infoObject.formMaster.Count; i++)
{
sqlString = string.Empty;
Sys_FormMaster_fom_Info fomInfo = infoObject.formMaster[i];
string frp_code = infoObject.fum_cFunctionNumber + fomInfo.fom_cFormNumber;
sqlString += "INSERT INTO Sys_FormPurview_frp" + Environment.NewLine;
sqlString += "(frp_cPurviewCode, frp_cFunctionNumber, frp_cFormNumber)" + Environment.NewLine;
sqlString += " VALUES " + Environment.NewLine;
sqlString += "('" + frp_code + "','" + infoObject.fum_cFunctionNumber + "','" + fomInfo.fom_cFormNumber + "')";
IEfrp = db.ExecuteQuery<Sys_FormPurview_frp_Info>(sqlString, new object[] { });
}
}
//if (fum != null)
//{
// ////usm = Common.General.SetDataToLingQEntity(usm, infoObject);//时间溢出
// //rlm.rlm_cRoleDesc = infoObject.rlm_cRoleDesc;
// //rlm.rlm_cLast = infoObject.rlm_cLast;
// //rlm.rlm_dLastDate = infoObject.rlm_dLastDate;
// fum.fum_cFunctionNumber = infoObject.fum_cFunctionNumber;
// fum.fum_cFunctionDesc = infoObject.fum_cFunctionDesc;
// fum.fum_cRemark = infoObject.fum_cRemark;
// fum.fum_cLast = infoObject.fum_cLast;
// fum.fum_dLastDate = infoObject.fum_dLastDate.Value;
// if (infoObject.formMaster != null && infoObject.formMaster.Count > 0)
// {
// for (int i = 0; i < infoObject.formMaster.Count; i++)
// {
// Sys_FormMaster_fom_Info usmInfo = infoObject.formMaster[i];
// Sys_FormPurview_frp item = new Sys_FormPurview_frp();
// item.frp_cFunctionNumber = infoObject.fum_cFunctionNumber;
// item.frp_cFormNumber = usmInfo.fom_cFormNumber;
// item.frp_cPurviewCode = item.frp_cFunctionNumber + item.frp_cFormNumber;
// //courseitem.cum_cNumber;
// fum.Sys_FormPurview_frps.Add(item);
// //db.Sys_UserRoles_usrs.InsertOnSubmit(item);
// }
// }
// db.SubmitChanges();
//}
return true;
}
catch (Exception Ex)
{
throw Ex;
}
}
}
public bool IsExistRecord(object KeyObject)
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
Sys_FunctionMaster_fum fum = new Sys_FunctionMaster_fum();
try
{
fum = Common.General.CopyObjectValue<object, Sys_FunctionMaster_fum>(KeyObject);
IQueryable<Sys_FunctionMaster_fum> taQuery =
(from ta in db.Sys_FunctionMaster_fum where ta.fum_cFunctionNumber == fum.fum_cFunctionNumber select ta);
if (taQuery.Count() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception Ex)
{
throw Ex;
}
}
}
public bool InsertRecord(Sys_FunctionMaster_fum_Info infoObject)
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
Sys_FunctionMaster_fum fum = new Sys_FunctionMaster_fum();
try
{
fum = Common.General.CopyObjectValue<Sys_FunctionMaster_fum_Info, Sys_FunctionMaster_fum>(infoObject);
if (infoObject.formMaster != null && infoObject.formMaster.Count > 0)
{
for (int i = 0; i < infoObject.formMaster.Count; i++)
{
Sys_FormMaster_fom_Info usmInfo = infoObject.formMaster[i];
Sys_FormPurview_frp item = new Sys_FormPurview_frp();
item.frp_cFunctionNumber = infoObject.fum_cFunctionNumber;
item.frp_cFormNumber = usmInfo.fom_cFormNumber;
item.frp_cPurviewCode = item.frp_cFunctionNumber + item.frp_cFormNumber;
//courseitem.cum_cNumber;
//fum.Sys_FormPurview_frps.Add(item);
//db.Sys_UserRoles_usrs.InsertOnSubmit(item);
}
}
db.Sys_FunctionMaster_fum.InsertOnSubmit(fum);
db.SubmitChanges();
return true;
}
catch (Exception Ex)
{
throw Ex;
}
}
}
