public List <Sys_FunctionMaster_fum_Info> SearchRecords(Model.IModel.IModelObject searchCondition) { string sqlString = string.Empty; string whereString = string.Empty; sqlString = "SELECT TOP " + Common.DefineConstantValue.ListRecordMaxCount.ToString() + Environment.NewLine; sqlString += " fum_iRecordID," + Environment.NewLine; sqlString += " fum_cFunctionNumber," + Environment.NewLine; sqlString += " fum_cFunctionDesc," + Environment.NewLine; sqlString += " fum_cRemark," + Environment.NewLine; sqlString += " fum_cAdd," + Environment.NewLine; sqlString += " fum_dAddDate," + Environment.NewLine; sqlString += " fum_cLast," + Environment.NewLine; sqlString += " fum_dLastDate " + Environment.NewLine; sqlString += " FROM Sys_FunctionMaster_fum" + Environment.NewLine; Sys_FunctionMaster_fum_Info info = null; info = searchCondition as Sys_FunctionMaster_fum_Info; if (info != null) { whereString = " WHERE 1=1 "; if (info.fum_cFunctionNumber.Trim() != "") { if (info.fum_cFunctionNumber.ToString().Contains("*") || info.fum_cFunctionNumber.ToString().Contains("?")) { whereString += " AND fum_cFunctionNumber LIKE N'" + LocalDefine.General.ReplaceSQLLikeCondition(info.fum_cFunctionNumber) + "'"; } else { whereString += "AND fum_cFunctionNumber = N'" + info.fum_cFunctionNumber.ToString().Trim() + "'"; } } } sqlString += whereString; IEnumerable <Sys_FunctionMaster_fum_Info> infos = null; List <Sys_FunctionMaster_fum_Info> infoList = null; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { infos = db.ExecuteQuery <Sys_FunctionMaster_fum_Info>(sqlString, new object[] { }); if (infos != null) { infoList = infos.ToList <Sys_FunctionMaster_fum_Info>(); } } } catch (Exception Ex) { throw Ex; } return(infoList); }
public Sys_FunctionMaster_fum_Info GetRecord_Last() { try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { IQueryable <Sys_FunctionMaster_fum> taQuery = (from ta in db.Sys_FunctionMaster_fums orderby ta.fum_iRecordID descending select ta).Take(1); Sys_FunctionMaster_fum_Info info = new Sys_FunctionMaster_fum_Info(); if (taQuery.Count() > 0) { foreach (var t in taQuery) { info = Common.General.CopyObjectValue <Sys_FunctionMaster_fum, Sys_FunctionMaster_fum_Info>(t); FindFormPurview(info); } } return(info); } } catch (Exception Ex) { throw Ex; } }
public Sys_FunctionMaster_fum_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { Sys_FunctionMaster_fum_Info fum = new Sys_FunctionMaster_fum_Info(); Sys_FunctionMaster_fum_Info info = new Sys_FunctionMaster_fum_Info(); fum = KeyObject as Sys_FunctionMaster_fum_Info; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { IQueryable <Sys_FunctionMaster_fum> taQuery = (from ta in db.Sys_FunctionMaster_fums where ta.fum_iRecordID == fum.fum_iRecordID //orderby dpms.dpm_iRecordID ascending select ta).Take(1); if (taQuery != null) { //foreach (var t in taQuery) foreach (Sys_FunctionMaster_fum t in taQuery) { info = Common.General.CopyObjectValue <Sys_FunctionMaster_fum, Sys_FunctionMaster_fum_Info>(t); FindFormPurview(info); } } return(info); } } catch (Exception Ex) { throw Ex; } }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { Sys_FunctionMaster_fum_Info info = null; try { info = KeyObject as Sys_FunctionMaster_fum_Info; using (VPMSDBDataContext db = new VPMSDBDataContext()) { Sys_FunctionMaster_fum fum = db.Sys_FunctionMaster_fums.Single <Sys_FunctionMaster_fum>(i => i.fum_iRecordID == info.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); } db.Sys_FunctionMaster_fums.DeleteOnSubmit(fum); db.SubmitChanges(); return(true); } } catch (Exception Ex) { throw Ex; } }
public Sys_FunctionMaster_fum_Info GetRecord_Next(Model.Base.DataBaseCommandInfo commandInfo) { Sys_FunctionMaster_fum_Info info = null; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { string iRecordId = string.Empty; foreach (var id in commandInfo.KeyInfoList) { iRecordId = id.KeyValue; break; } IQueryable <Sys_FunctionMaster_fum> taQuery = (from ta in db.Sys_FunctionMaster_fums where ta.fum_iRecordID > Convert.ToInt32(iRecordId) orderby ta.fum_iRecordID ascending select ta).Take(1); if (taQuery.Count() > 0) { foreach (var t in taQuery) { info = Common.General.CopyObjectValue <Sys_FunctionMaster_fum, Sys_FunctionMaster_fum_Info>(t); FindFormPurview(info); } } return(info); } } catch (Exception Ex) { return(info); } }
public Sys_FunctionMaster_fum_Info GetRecord_First() { Sys_FunctionMaster_fum_Info info = null; try { info = this._sysFunctionMasterDA.GetRecord_First(); } catch (Exception Ex) { throw Ex; } return(info); }
public Model.IModel.IModelObject GetTableFieldLenght() { LocalGeneral general = new LocalGeneral(); Sys_FunctionMaster_fum_Info info = null; try { info = general.GetTableFieldLenght <Sys_FunctionMaster_fum_Info>("Sys_FunctionMaster_fum"); } catch (Exception Ex) { throw Ex; } return(info); }
public Model.IModel.IModelObject DisplayRecord(Model.IModel.IModelObject itemEntity) { if (itemEntity == null) { return(null); } else { Sys_FunctionMaster_fum_Info info = null; try { info = this._sysFunctionMasterDA.DisplayRecord(itemEntity); } catch (Exception Ex) { throw Ex; } return(info); } }
public bool InsertRecord(Sys_FormMaster_fom_Info infoObject) { using (VPMSDBDataContext db = new VPMSDBDataContext()) { Sys_FormMaster_fom frm = new Sys_FormMaster_fom(); try { frm = Common.General.CopyObjectValue <Sys_FormMaster_fom_Info, Sys_FormMaster_fom>(infoObject); if (infoObject.functionMaster != null && infoObject.functionMaster.Count > 0) { for (int i = 0; i < infoObject.functionMaster.Count; i++) { Sys_FunctionMaster_fum_Info usmInfo = infoObject.functionMaster[i]; Sys_FormPurview_frp item = new Sys_FormPurview_frp(); item.frp_cFunctionNumber = usmInfo.fum_cFunctionNumber; item.frp_cFormNumber = infoObject.fom_cFormNumber; item.frp_cPurviewCode = item.frp_cFunctionNumber + item.frp_cFormNumber; //courseitem.cum_cNumber; frm.Sys_FormPurview_frps.Add(item); //db.Sys_UserRoles_usrs.InsertOnSubmit(item); } } db.Sys_FormMaster_foms.InsertOnSubmit(frm); db.SubmitChanges(); return(true); } catch (Exception Ex) { throw Ex; } } }
public Sys_FunctionMaster_fum_Info GetRecord_Next(Model.Base.DataBaseCommandInfo commandInfo) { Sys_FunctionMaster_fum_Info info = null; if (commandInfo.KeyInfoList == null) { return(info); } else { try { info = this._sysFunctionMasterDA.GetRecord_Next(commandInfo); } catch (Exception Ex) { throw Ex; } return(info); } }
private Sys_FunctionMaster_fum_Info FindFormPurview(Sys_FunctionMaster_fum_Info info) { string sqlString = string.Empty; sqlString += "SELECT fom_cFormNumber,fom_cFormDesc " + Environment.NewLine; sqlString += "FROM Sys_FormMaster_fom " + Environment.NewLine; sqlString += "LEFT JOIN Sys_FormPurview_frp" + Environment.NewLine; sqlString += "ON fom_cFormNumber=frp_cFormNumber" + Environment.NewLine; sqlString += "LEFT JOIN Sys_FunctionMaster_fum" + Environment.NewLine; sqlString += "ON frp_cFunctionNumber=fum_cFunctionNumber WHERE fum_iRecordID='" + info.fum_iRecordID + "'"; IEnumerable <Sys_FormMaster_fom_Info> infos = null; List <Sys_FormMaster_fom_Info> infoList = null; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { infos = db.ExecuteQuery <Sys_FormMaster_fom_Info>(sqlString, new object[] { }); if (infos != null) { infoList = infos.ToList <Sys_FormMaster_fom_Info>(); } foreach (Sys_FormMaster_fom_Info t in infoList) { info.formMaster.Add(t); } return(info); } } catch (Exception Ex) { throw Ex; } }
public Model.General.ReturnValueInfo Save(Model.IModel.IModelObject itemEntity, Common.DefineConstantValue.EditStateEnum EditMode) { bool b; Model.General.ReturnValueInfo msg = new Model.General.ReturnValueInfo(); Sys_FunctionMaster_fum_Info info = null; info = itemEntity as Sys_FunctionMaster_fum_Info; if (info == null) { msg.boolValue = false; msg.messageText = "传入的数据为空!"; return(msg); } try { switch (EditMode) { case Common.DefineConstantValue.EditStateEnum.OE_Delete: b = this._sysFunctionMasterDA.DeleteRecord(info); if (b == true) { msg.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_I_RecordByDelete; } break; case Common.DefineConstantValue.EditStateEnum.OE_Insert: b = this._sysFunctionMasterDA.IsExistRecord(info); if (b == false) { this._sysFunctionMasterDA.InsertRecord(info); } else { msg.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_I_AddFail + " 功能编号重复!"; } break; case Common.DefineConstantValue.EditStateEnum.OE_Update: b = this._sysFunctionMasterDA.UpdateRecord(info); //if (b == true) //{ // msg.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_I_UpdateSuccess; //} //else //{ // msg.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_I_UpdateFail; //} break; } } catch (Exception Ex) { throw Ex; } return(msg); }
public bool UpdateRecord(Sys_FormMaster_fom_Info infoObject) { using (VPMSDBDataContext db = new VPMSDBDataContext()) { Sys_FormMaster_fom frm = new Sys_FormMaster_fom(); try { frm = db.Sys_FormMaster_foms.SingleOrDefault(t => t.fom_iRecordID == infoObject.fom_iRecordID); for (int i = 0; i < frm.Sys_FormPurview_frps.Count; i++) { Sys_FormPurview_frp sta = frm.Sys_FormPurview_frps[i]; db.Sys_FormPurview_frps.DeleteOnSubmit(sta); } string sqlString = string.Empty; Sys_FormMaster_fom_Info info = new Sys_FormMaster_fom_Info(); info = Common.General.CopyObjectValue <Sys_FormMaster_fom, Sys_FormMaster_fom_Info>(frm); IEnumerable <Sys_FormMaster_fom_Info> IEfom = null; IEnumerable <Sys_FormPurview_frp_Info> IEfrp = null; sqlString += "UPDATE Sys_FormMaster_fom" + Environment.NewLine; sqlString += " SET fom_cFormNumber='" + infoObject.fom_cFormNumber + "'," + Environment.NewLine; sqlString += " fom_cFormDesc='" + infoObject.fom_cFormDesc + "'," + Environment.NewLine; sqlString += " fom_cExePath='" + infoObject.fom_cExePath + "'," + Environment.NewLine; sqlString += " fom_cWebPath='" + infoObject.fom_cWebPath + "'," + Environment.NewLine; sqlString += " fom_iWebForm='" + infoObject.fom_iWebForm + "'," + Environment.NewLine; //sqlString += " fom_cExePath='" + infoObject.rlm_cLast + "'," + Environment.NewLine; sqlString += " fom_iParentID='" + infoObject.fom_iParentID + "'," + Environment.NewLine; sqlString += " fom_iIndex='" + infoObject.fom_iIndex + "'," + Environment.NewLine; sqlString += " fom_cLast='" + infoObject.fom_cLast + "'," + Environment.NewLine; sqlString += " fom_dLastDate='" + infoObject.fom_dLastDate.Value.ToString(DefineConstantValue.gc_DateTimeFormat) + "'" + Environment.NewLine; sqlString += " WHERE fom_iRecordID='" + infoObject.fom_iRecordID + "'"; IEfom = db.ExecuteQuery <Sys_FormMaster_fom_Info>(sqlString, new object[] { }); sqlString = string.Empty; sqlString += "DELETE FROM Sys_FormPurview_frp WHERE frp_cFormNumber='" + infoObject.fom_cFormNumber + "'"; IEfrp = db.ExecuteQuery <Sys_FormPurview_frp_Info>(sqlString, new object[] { }); if (infoObject.functionMaster != null && infoObject.functionMaster.Count > 0) { for (int i = 0; i < infoObject.functionMaster.Count; i++) { sqlString = string.Empty; Sys_FunctionMaster_fum_Info fomInfo = infoObject.functionMaster[i]; string frp_code = fomInfo.fum_cFunctionNumber + infoObject.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 + "','" + fomInfo.fum_cFunctionNumber + "','" + infoObject.fom_cFormNumber + "')"; IEfrp = db.ExecuteQuery <Sys_FormPurview_frp_Info>(sqlString, new object[] { }); } } //if (frm != null) //{ // frm.fom_cFormNumber = infoObject.fom_cFormNumber; // frm.fom_cFormDesc = infoObject.fom_cFormDesc; // frm.fom_cExePath = infoObject.fom_cExePath; // frm.fom_cWebPath = infoObject.fom_cWebPath; // frm.fom_iWebForm = infoObject.fom_iWebForm; // //frm.fom_iImageIndex = infoObject.fom_iImageIndex; // frm.fom_iParentID = infoObject.fom_iParentID; // frm.fom_iIndex = infoObject.fom_iIndex; // frm.fom_cLast = infoObject.fom_cLast; // frm.fom_dLastDate = infoObject.fom_dLastDate.Value; // if (infoObject.functionMaster != null && infoObject.functionMaster.Count > 0) // { // for (int i = 0; i < infoObject.functionMaster.Count; i++) // { // Sys_FunctionMaster_fum_Info usmInfo = infoObject.functionMaster[i]; // Sys_FormPurview_frp item = new Sys_FormPurview_frp(); // item.frp_cFunctionNumber = usmInfo.fum_cFunctionNumber; // item.frp_cFormNumber = infoObject.fom_cFormNumber; // item.frp_cPurviewCode = item.frp_cFunctionNumber + item.frp_cFormNumber; // //courseitem.cum_cNumber; // frm.Sys_FormPurview_frps.Add(item); // //db.Sys_UserRoles_usrs.InsertOnSubmit(item); // } // } // db.SubmitChanges(); //} return(true); } catch (Exception Ex) { throw Ex; } } }