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;
}
