public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { Sys_FunctionMaster_fum_Info info = null; try { info = KeyObject as Sys_FunctionMaster_fum_Info; using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext()) { Sys_FunctionMaster_fum fum = db.Sys_FunctionMaster_fum.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_fum.DeleteOnSubmit(fum); db.SubmitChanges(); return true; } } catch (Exception Ex) { throw Ex; } }
public Model.General.ReturnValueInfo Save(Model.IModel.IModelObject itemEntity, Common.DefineConstantValue.EditStateEnum EditMode) { ReturnValueInfo rvInfo = new ReturnValueInfo(); try { BlacklistChangeRecord_blc_Info recordInfo = itemEntity as BlacklistChangeRecord_blc_Info; if (recordInfo == null) { rvInfo.isError = true; rvInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_ObjectNull; return rvInfo; } switch (EditMode) { case Common.DefineConstantValue.EditStateEnum.OE_Insert: return this._IBlacklistChangeRecordDA.InsertRecord(recordInfo); break; case Common.DefineConstantValue.EditStateEnum.OE_Update: return this._IBlacklistChangeRecordDA.UpdateRecord(recordInfo); break; case Common.DefineConstantValue.EditStateEnum.OE_Delete: return this._IBlacklistChangeRecordDA.DeleteRecord(recordInfo); break; default: break; } } catch (Exception ex) { rvInfo.messageText = ex.Message; rvInfo.isError = true; } return rvInfo; }
/// <summary> /// 登记代表 /// </summary> /// <param name="user"></param> public void LoginBehalf(Model.T_Behalf user) { HttpContext.Current.Session["UserName"] = user.UserName; HttpContext.Current.Session["Phone"] = user.Phone; HttpContext.Current.Session["Id"] = user.Id; HttpContext.Current.Session["IsVoted"] = user.IsVoted; }
/// <summary> /// 增加一条数据 /// </summary> public string Add(Model.QQ_Layer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into QQ_Layer("); strSql.Append("qq_code,qq_alt,qq_paixu,qq_createdate,qq_state,qq_delete)"); strSql.Append(" values ("); strSql.Append("@qq_code,@qq_alt,@qq_paixu,@qq_createdate,@qq_state,@qq_delete)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@qq_code", SqlDbType.NVarChar,50), new SqlParameter("@qq_alt", SqlDbType.NVarChar,100), new SqlParameter("@qq_paixu", SqlDbType.Int,4), new SqlParameter("@qq_createdate", SqlDbType.DateTime), new SqlParameter("@qq_state", SqlDbType.Int,4), new SqlParameter("@qq_delete", SqlDbType.Int,4)}; parameters[0].Value = model.qq_code; parameters[1].Value = model.qq_alt; parameters[2].Value = model.qq_paixu; parameters[3].Value = model.qq_createdate; parameters[4].Value = model.qq_state; parameters[5].Value = model.qq_delete; int obj = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction,CommandType.Text, strSql.ToString(), parameters); if (obj == 1) { return "succeeded"; } else { return "error"; } }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { Sys_RoleMaster_rlm_Info info = null; try { info = KeyObject as Sys_RoleMaster_rlm_Info; using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext()) { Sys_RoleMaster_rlm rlm = db.Sys_RoleMaster_rlm.Single<Sys_RoleMaster_rlm>(i => i.rlm_iRecordID == info.rlm_iRecordID); for (int i = 0; i < rlm.Sys_UserRoles_usr.Count; i++) { Sys_UserRoles_usr sta = rlm.Sys_UserRoles_usr[i]; db.Sys_UserRoles_usr.DeleteOnSubmit(sta); } db.Sys_RoleMaster_rlm.DeleteOnSubmit(rlm); db.SubmitChanges(); return true; } } catch (Exception Ex) { throw Ex; } }
public Model.SysMaster.Sys_UserMaster_usm_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { Sys_UserMaster_usm_Info usm = new Sys_UserMaster_usm_Info(); Sys_UserMaster_usm_Info info = new Sys_UserMaster_usm_Info(); usm = KeyObject as Sys_UserMaster_usm_Info; try { using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext()) { IQueryable<Sys_UserMaster_usm> taQuery = (from ta in db.Sys_UserMaster_usm where ta.usm_iRecordID == usm.usm_iRecordID select ta).Take(1); if (taQuery != null) { foreach (Sys_UserMaster_usm t in taQuery) { info = Common.General.CopyObjectValue<Sys_UserMaster_usm, Sys_UserMaster_usm_Info>(t); FindUserRole(info); } } return info; } } catch (Exception Ex) { throw Ex; } }
public int update(Model.News mn) { StringBuilder sql= new StringBuilder(); sql.Append(" update news set "); sql.Append(" _title=@name, _from=@source, _author=@author,_top=@hot,_click=@count,_content=@info,_cateid=@nid,_ispic=@pic "); sql.Append(" where _id=@id "); SqlParameter [] par={ new SqlParameter( "@name",SqlDbType.VarChar,50) , new SqlParameter("@source",SqlDbType.VarChar,50), new SqlParameter("@author",SqlDbType.VarChar,50), new SqlParameter("@hot",SqlDbType.Int,4), new SqlParameter("@count",SqlDbType.Int,4), new SqlParameter("@info",SqlDbType.VarChar,0), new SqlParameter("@nid",SqlDbType.Int,4), new SqlParameter("@pic",SqlDbType.Int,4 ), new SqlParameter("@id", SqlDbType.Int,4) }; par[0].Value = mn.Title; par[1].Value = mn.From; par[2].Value = mn.Author; par[3].Value = mn.Top; par[4].Value = mn.Click; par[5].Value = mn.Content; par[6].Value = mn.Cateid; par[7].Value = mn.Ispic; par[8].Value = mn.ID; int result = DbHelperSQL.ExecuteSql(sql.ToString(),par); return result; }
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 (MainDBDataContext db = new MainDBDataContext()) { IQueryable<Sys_FunctionMaster_fum> taQuery = (from ta in db.Sys_FunctionMaster_fum 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 int add(Model.News mn) { StringBuilder sql = new StringBuilder(); sql.Append(" insert into news "); sql.Append(" (_title,_from,_author,_top,_click,_content,_cateid,_ispic) "); sql.Append(" values( @title,@from,@author,@top,@click,@content,@cateid,@ispic ) "); SqlParameter[] par = { new SqlParameter( "@title",SqlDbType.VarChar,50 ), new SqlParameter("@from",SqlDbType.VarChar,50), new SqlParameter("@author",SqlDbType.VarChar,50), new SqlParameter("@top",SqlDbType.VarChar,50), new SqlParameter("@click",SqlDbType.VarChar,50), new SqlParameter("@content",SqlDbType.VarChar,0), new SqlParameter("@cateid",SqlDbType.VarChar,50), new SqlParameter("@ispic",SqlDbType.VarChar,50) }; par[0].Value = mn.Title; par[1].Value = mn.From; par[2].Value = mn.Author; par[3].Value = mn.Top; par[4].Value = mn.Click; par[5].Value = mn.Content; par[6].Value = mn.Cateid; par[7].Value = mn.Ispic; int result = DbHelperSQL.ExecuteSql(sql.ToString(),par); return result; }
public Sys_FormMaster_fom_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { Sys_FormMaster_fom_Info frm = new Sys_FormMaster_fom_Info(); Sys_FormMaster_fom_Info info = null; frm = KeyObject as Sys_FormMaster_fom_Info; try { using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext()) { IQueryable<Sys_FormMaster_fom> taQuery = (from ta in db.Sys_FormMaster_fom where ta.fom_iRecordID == frm.fom_iRecordID select ta).Take(1); if (taQuery != null) { foreach (Sys_FormMaster_fom t in taQuery) { info = Common.General.CopyObjectValue<Sys_FormMaster_fom, Sys_FormMaster_fom_Info>(t); FindFormPurview(info); } } return info; } } catch (Exception Ex) { throw Ex; } }
public Sys_RoleMaster_rlm_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { Sys_RoleMaster_rlm_Info rlm = new Sys_RoleMaster_rlm_Info(); Sys_RoleMaster_rlm_Info info = new Sys_RoleMaster_rlm_Info(); rlm = KeyObject as Sys_RoleMaster_rlm_Info; try { using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext()) { IQueryable<Sys_RoleMaster_rlm> taQuery = (from ta in db.Sys_RoleMaster_rlm where ta.rlm_iRecordID == rlm.rlm_iRecordID //orderby dpms.dpm_iRecordID ascending select ta).Take(1); if (taQuery != null) { //foreach (var t in taQuery) foreach (Sys_RoleMaster_rlm t in taQuery) { info = Common.General.CopyObjectValue<Sys_RoleMaster_rlm, Sys_RoleMaster_rlm_Info>(t); FindUserRole(info); } } return info; } } catch (Exception Ex) { throw Ex; } }
public int _delete(Model.News mn) { StringBuilder sql = new StringBuilder(); sql.Append(" delete from news where _id=@nid "); SqlParameter[] par = { new SqlParameter("@nid", SqlDbType.Int, 4) }; par[0].Value = mn.ID; int result = DbHelperSQL.ExecuteSql(sql.ToString(),par); return result; }
public SqlDataReader sqldatareader(Model.Helpcate mh) { StringBuilder sql = new StringBuilder(); sql.Append("select * from helpcate"); sql.Append(" where _cateid = @id"); SqlParameter[] par = { new SqlParameter("@id", SqlDbType.Int, 4) }; par[0].Value = mh.ID; SqlDataReader sdr = Common.DbHelperSQL.ExecuteReader(sql.ToString(), par); return sdr; }
public int _delete(Model.Helpcate mh) { StringBuilder sql = new StringBuilder(); sql.Append(" delete from helpcate "); sql.Append(" where _cateid=@id "); SqlParameter [] par={ new SqlParameter("@id",SqlDbType.Int,4) }; par[0].Value = mh.ID; int result= Common.DbHelperSQL.ExecuteSql(sql.ToString(),par); return result; }
public int _delete(Model.downlist md) { StringBuilder sql = new StringBuilder(); sql.Append(" delete from downlist "); sql.Append(" where _id=@id "); SqlParameter[] par ={ new SqlParameter ("@id",SqlDbType.Int,4) }; par[0].Value = md.id; return DbHelperSQL.ExecuteSql(sql.ToString(),par); }
public Model.IModel.IModelObject DisplayRecord(Model.IModel.IModelObject itemEntity) { try { return _codeMasterDA.DisplayRecord(itemEntity); } catch (Exception Ex) { throw Ex; } }
public Model.HHZX.Report.DepartmentBalance_dtb_Info DepartmentBalance(Model.HHZX.Report.DepartmentBalance_dtb_Info query) { try { return this._ISystemAccountDetailDA.DepartmentBalance(query); } catch (Exception Ex) { throw Ex; } }
public MachineMaster_mmt_Info DisplayRecord(Model.IModel.IModelObject itemEntity) { try { return this._MachineMasterDA.DisplayRecord(itemEntity); } catch (Exception Ex) { throw Ex; } }
public Model.HHZX.MealBooking.BlacklistChangeRecord_blc_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { try { return this._IBlacklistChangeRecordDA.DisplayRecord(KeyObject); } catch (Exception ex) { throw ex; } }
public int update(Model.Helpcate mh) { StringBuilder sql = new StringBuilder(); sql.Append(" update helpcate set "); sql.Append(" _catename=@name "); sql.Append(" where _cateid=@id "); SqlParameter[] par = { new SqlParameter("@name",SqlDbType.VarChar,50), new SqlParameter("@id",SqlDbType.Int,4 ) }; par[0].Value = mh.Catename; par[1].Value = mh.ID; int result = DbHelperSQL.ExecuteSql(sql.ToString(),par); return result; }
public int insert(Model.Helpcate mh) { StringBuilder sql = new StringBuilder(); sql.Append("insert into helpcate"); sql.Append(" values ( "); sql.Append("@name"); sql.Append(")"); SqlParameter[] par = { new SqlParameter("@name",SqlDbType.VarChar,50) }; par[0].Value = mh.Catename; return Common.DbHelperSQL.ExecuteSql(sql.ToString(),par); }
public List<Model.HHZX.Report.AccoumtBalance_atb_info> SearchRecords(Model.IModel.IModelObject searchCondition) { List<AccoumtBalance_atb_info> returnList = new List<AccoumtBalance_atb_info>(); try { AccoumtBalance_atb_info objInfo = searchCondition as AccoumtBalance_atb_info; returnList = _iabDA.GetRecord(objInfo); } catch { } return returnList; }
public int click(Model.downlist md) { StringBuilder sql = new StringBuilder(); sql.Append(" update downlist set "); sql.Append(" _click=@click "); sql.Append(" where _id=@id "); SqlParameter[] par ={ new SqlParameter("@click",SqlDbType.Int,4), new SqlParameter("@id",SqlDbType.Int,4) }; par[0].Value = md.click; par[1].Value = md.id; return DbHelperSQL.ExecuteSql(sql.ToString(), par); }
public FileController(Model _model, View _view) : base(_model, _view) { Config = FileControllerConfig.LoadConfig(ConfigPath) as FileControllerConfig; GroupFilter = new GroupFilter(); FileView.SetDataGridSource(FileModel.Files); FileView.SetGroupFilter(GroupFilter); RefreshModel(); FilterExtensions(Config.IgnoredExtensions); FileView.SearchBox.Focus(); }
public int downloadadd(Model.downlist md) { StringBuilder sql=new StringBuilder(); sql.Append(" insert into downlist "); sql.Append(" (_title,_size,_click,_uploadurl)"); sql.Append(" values (@name,@size,@click,@url)"); SqlParameter[] par = { new SqlParameter("@name",SqlDbType.VarChar,150 ), new SqlParameter("@size",SqlDbType.VarChar,50), new SqlParameter("@click",SqlDbType.Int,4), new SqlParameter("@url",SqlDbType.VarChar,200) }; par[0].Value = md.title; par[1].Value = md.size; par[2].Value = md.click; par[3].Value = md.uploadurl; return DbHelperSQL.ExecuteSql(sql.ToString(),par); }
/// <summary> /// 從DB中驗證登陸權限 /// </summary> ///<param name="itemEntity"></param> /// <returns></returns> public Model.General.ReturnValueInfo Login(Model.IModel.IModelObject itemEntity) { try { Model.General.ReturnValueInfo msg = new Model.General.ReturnValueInfo(); Sys_UserMaster_usm_Info userInfo = null; Sys_UserMaster_usm_Info cond = itemEntity as Sys_UserMaster_usm_Info; string pwd = Common.General.MD5(cond.usm_cPasswork); List<Sys_UserMaster_usm_Info> users = this.m_objStateMonitorDAL.SearchRecords(cond); if (users.Count > 0) { userInfo = users[0] as Sys_UserMaster_usm_Info; if (userInfo.usm_cPasswork != pwd) { msg.boolValue = false; msg.messageText = "密碼錯誤,請重新輸入!"; } else if (userInfo.usm_iLock == true) { msg.boolValue = false; msg.ValueObject = userInfo; msg.messageText = "账户被锁,请与管理员联系!"; } else { msg.boolValue = true; msg.ValueObject = userInfo; } } else { msg.boolValue = false; msg.messageText = "用戶不存在,請重新輸入!"; } return msg; } catch { throw; } }
public int update(Model.downlist md) { StringBuilder sql = new StringBuilder(); sql.Append(" update downlist set "); sql.Append(" _title=@name,_size=@size,_click=@click,_uploadurl=@url "); sql.Append(" where _id=@id "); SqlParameter[] par ={ new SqlParameter("@name",SqlDbType.VarChar,150 ), new SqlParameter("@size",SqlDbType.VarChar,50), new SqlParameter("@click",SqlDbType.Int,4), new SqlParameter("@url",SqlDbType.VarChar,200), new SqlParameter("@id",SqlDbType.Int,4) }; par[0].Value = md.title; par[1].Value = md.size; par[2].Value = md.click; par[3].Value = md.uploadurl; par[4].Value = md.id; return DbHelperSQL.ExecuteSql(sql.ToString(), par); }
public Model.General.ReturnValueInfo DeleteRecord(Model.IModel.IModelObject deleteInfo) { Model.General.ReturnValueInfo returnInfo = new Model.General.ReturnValueInfo(); try { if (deleteInfo != null) { returnInfo = _iccmDA.DeleteRecord(deleteInfo); } } catch (Exception ex) { returnInfo.boolValue = false; returnInfo.messageText = ex.ToString(); } return returnInfo; }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { Sys_FormMaster_fom_Info info = null; try { info = KeyObject as Sys_FormMaster_fom_Info; using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext()) { Sys_FormMaster_fom frm = db.Sys_FormMaster_fom.Single<Sys_FormMaster_fom>(i => i.fom_iRecordID == info.fom_iRecordID); for (int i = 0; i < frm.Sys_FormPurview_frp.Count; i++) { Sys_FormPurview_frp sta = frm.Sys_FormPurview_frp[i]; db.Sys_FormPurview_frp.DeleteOnSubmit(sta); } if (frm != null) { frm.fom_lVaild = false; IEnumerable<Sys_FormMaster_fom> subMenu = from t in db.Sys_FormMaster_fom where t.fom_iParentID == frm.fom_iRecordID select t; if (subMenu != null && subMenu.Count() > 0) { foreach (Sys_FormMaster_fom item in subMenu) { item.fom_lVaild = false; } } } //db.Sys_FormMaster_fom.DeleteOnSubmit(frm); db.SubmitChanges(); return true; } } catch (Exception Ex) { throw Ex; } }
public CodeMaster_cmt_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { CodeMaster_cmt_Info info = new CodeMaster_cmt_Info(); try { using (MainDBDataContext db = new MainDBDataContext()) { CodeMaster_cmt disTab = db.CodeMaster_cmt.SingleOrDefault(t => t.cmt_iRecordID == ((KeyObject) as CodeMaster_cmt_Info).cmt_iRecordID); if (disTab != null) { info = Common.General.CopyObjectValue<CodeMaster_cmt, CodeMaster_cmt_Info>(disTab); } } } catch (Exception Ex) { throw Ex; } return info; }