public CommonResult<CyResourceEntity> GetCyResourceList()
{
var commonResult = new CommonResult<CyResourceEntity>();
const string sql = @"SELECT [ResourceId]
,[ResourceCode]
,[ResourceName]
,[MenuCode]
,[MenuId]
,[RequestPath]
,[ResourceFlag]
,[Memo]
FROM [dbo].[CyResource](nolock)";
using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyReadConnectionStringName))
{
try
{
var model = conn.Query<CyResourceEntity>(sql).ToList();
commonResult.Success = true;
commonResult.Message = "执行成功";
commonResult.ResultObjList = model;
}
catch (Exception ex)
{
commonResult.Success = false;
commonResult.IsHappenEx = true;
commonResult.Message = "执行失败";
commonResult.ExMessage = ex.Message;
commonResult.ExData = ex;
}
return commonResult;
}
}
public async Task<IActionResult> Get()
{
var res = await _helper.QueryAsync(BookCommandText.GetBooks);
CommonResult<Book> json = new CommonResult<Book>
{
Code = "000",
Message = "ok",
Data = res
};
return Ok(json);
}
public IActionResult Post([FromForm]PostForm form)
{
DynamicParameters dp = new DynamicParameters();
dp.Add("@Id", form.Id, DbType.Int32, ParameterDirection.Input);
var res = _helper.Query<Book>(BookCommandText.GetBookById, dp, null, true, null, CommandType.StoredProcedure).FirstOrDefault();
CommonResult<Book> json = new CommonResult<Book>
{
Code = "000",
Message = "ok",
Data = res
};
return Ok(json);
}
/// <summary>
/// 保存客户端上传的相关数据列表
/// </summary>
/// <param name="list">数据列表</param>
/// <returns></returns>
public ActionResult SaveExcelData(List <CompetitorInfo> list)
{
CommonResult result = new CommonResult();
if (list != null && list.Count > 0)
{
#region 采用事务进行数据提交
DbTransaction trans = BLLFactory <Competitor> .Instance.CreateTransaction();
if (trans != null)
{
try
{
//int seq = 1;
foreach (CompetitorInfo detail in list)
{
//detail.Seq = seq++;//增加1
detail.CreateTime = DateTime.Now;
detail.Creator = CurrentUser.ID.ToString();
detail.Editor = CurrentUser.ID.ToString();
detail.EditTime = DateTime.Now;
detail.Company_ID = CurrentUser.Company_ID;
detail.Dept_ID = CurrentUser.Dept_ID;
BLLFactory <Competitor> .Instance.Insert(detail, trans);
}
trans.Commit();
result.Success = true;
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(CompetitorController));
result.ErrorMessage = ex.Message;
trans.Rollback();
}
}
#endregion
}
else
{
result.ErrorMessage = "导入信息不能为空";
}
return(ToJsonContent(result));
}
/// <summary>
/// 保存客户端上传的相关数据列表
/// </summary>
/// <param name="list">数据列表</param>
/// <returns></returns>
public ActionResult SaveExcelData(List <DictDataInfo> list)
{
CommonResult result = new CommonResult();
if (list != null && list.Count > 0)
{
#region 采用事务进行数据提交
DbTransaction trans = BLLFactory <DictData> .Instance.CreateTransaction();
if (trans != null)
{
try
{
//int seq = 1;
foreach (DictDataInfo detail in list)
{
DictTypeInfo typeInfo = BLLFactory <DictType> .Instance.FindSingle(string.Format("Name ='{0}'", detail.DictType_ID));
if (typeInfo != null)
{
//detail.Seq = seq++;//增加1
detail.Editor = CurrentUser.ID.ToString();
detail.LastUpdated = DateTime.Now;
BLLFactory <DictData> .Instance.Insert(detail, trans);
}
}
trans.Commit();
result.Success = true;
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(DictDataController));
result.ErrorMessage = ex.Message;
trans.Rollback();
}
}
#endregion
}
else
{
result.ErrorMessage = "导入信息不能为空";
}
return(ToJsonContent(result));
}
public CommonResult <PageResult <DbTableInfo> > FindListTable(SearchModel search)
{
CommonResult <PageResult <DbTableInfo> > result = new CommonResult <PageResult <DbTableInfo> >();
if (!string.IsNullOrEmpty(search.EnCode))
{
YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper();
object connCode = yuebonCacheHelper.Get("CodeGeneratorDbConn");
if (connCode != null)
{
string SqlConnectionString = connCode.ToString();
string[] sqlconn = SqlConnectionString.Split(";");
string[] dataName = sqlconn[1].Split("=");
dataName[1] = search.EnCode;
sqlconn[1] = dataName.Join("=");
string newConnStr = sqlconn.Join(";");
TimeSpan expiresSliding = DateTime.Now.AddMinutes(30) - DateTime.Now;
yuebonCacheHelper.Add("CodeGeneratorDbConn", newConnStr, expiresSliding, false);
yuebonCacheHelper.Add("CodeGeneratorDbName", search.EnCode, expiresSliding, false);
}
}
string orderByDir = search.Order;
string orderFlied = string.IsNullOrEmpty(search.Sort)? "TableName": search.Sort;
bool order = orderByDir == "asc" ? false : true;
string where = "1=1";
if (!string.IsNullOrEmpty(search.Keywords))
{
where += " and TableName like '%" + search.Keywords + "%'";
}
PagerInfo pagerInfo = new PagerInfo {
PageSize = search.PageSize,
CurrenetPageIndex = search.CurrenetPageIndex
};
DbExtractor dbExtractor = new DbExtractor();
List <DbTableInfo> listTable = dbExtractor.GetTablesWithPage(search.Keywords, orderFlied, order, pagerInfo);
PageResult <DbTableInfo> pageResult = new PageResult <DbTableInfo>();
pageResult.CurrentPage = pagerInfo.CurrenetPageIndex;
pageResult.Items = listTable;
pageResult.ItemsPerPage = pagerInfo.PageSize;
pageResult.TotalItems = pagerInfo.RecordCount;
result.ResData = pageResult;
result.ErrCode = ErrCode.successCode;
return(result);
}
/// <summary>
/// 保存客户端上传的相关数据列表
/// </summary>
/// <param name="list">数据列表</param>
/// <returns></returns>
public ActionResult SaveExcelData(List <BootstrapIconInfo> list)
{
CommonResult result = new CommonResult();
if (list != null && list.Count > 0)
{
#region 采用事务进行数据提交
DbTransaction trans = BLLFactory <BootstrapIcon> .Instance.CreateTransaction();
if (trans != null)
{
try
{
//int seq = 1;
foreach (BootstrapIconInfo detail in list)
{
//detail.Seq = seq++;//增加1
detail.CreateTime = DateTime.Now;
BLLFactory <BootstrapIcon> .Instance.Insert(detail, trans);
}
trans.Commit();
result.Success = true;
}
catch (Exception ex)
{
LogTextHelper.Error(ex);
result.ErrorMessage = ex.Message;
trans.Rollback();
}
finally
{
trans.Connection.Close();
trans.Connection.Dispose();
trans.Dispose();
}
}
#endregion
}
else
{
result.ErrorMessage = "导入信息不能为空";
}
return(ToJsonContent(result));
}
/// <summary>
/// 保存客户端上传的相关数据列表
/// </summary>
/// <param name="list">数据列表</param>
/// <returns></returns>
public ActionResult SaveExcelData(List <ReimbursementInfo> list)
{
CommonResult result = new CommonResult();
if (list != null && list.Count > 0)
{
#region 采用事务进行数据提交
var trans = BLLFactory <Reimbursement> .Instance.CreateTransaction();
if (trans != null)
{
try
{
//int seq = 1;
foreach (ReimbursementInfo detail in list)
{
//detail.Seq = seq++;//增加1
/*
* detail.CreateTime = DateTime.Now;
* detail.Creator = CurrentUser.ID.ToString();
* detail.Editor = CurrentUser.ID.ToString();
* detail.EditTime = DateTime.Now;
*/
BLLFactory <Reimbursement> .Instance.Insert(detail, trans);
}
trans.Commit();
result.Success = true;
}
catch (Exception ex)
{
LogTextHelper.Error(ex);
result.ErrorMessage = ex.Message;
trans.Rollback();
}
}
#endregion
}
else
{
result.ErrorMessage = "导入信息不能为空";
}
return(ToJsonContent(result));
}
public ActionResult DepositAccount(int custNo)
{
CommonResult result = new CommonResult();
try
{
//up_DepositWriteoff(预付费模式预存款销账)
//CREATEPROCEDURE[dbo].[up_DepositWriteoff]
//@iCustNo INTEGER = 1, --< !--客户编号-- >
//@sUserID VARCHAR(8),--< !--操作员编号-- >
//@sReturn VARCHAR(MAX)OUTPUT
lock (objLock)
{
//System.Threading.Thread.Sleep(3000);
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@iCustNo", SqlDbType.Int)
{
Value = custNo
});
param.Add(new SqlParameter("@sUserID", SqlDbType.VarChar, 8)
{
Value = UserInfo.ID
});
param.Add(new SqlParameter("@sReturn", SqlDbType.VarChar, 256)
{
Direction = ParameterDirection.Output
});
BLLFactory <Core.BLL.AccPayment> .Instance.ExecStoreProc("up_DepositWriteoff", param);
if (param[param.Count - 1].Value.ToString() == "0")
{
result.Success = true;
}
else
{
result.ErrorMessage = "操作失败!错误如下:" + param[param.Count - 1].Value;
}
}
}
catch (Exception ex)
{
result.ErrorMessage = "操作失败!错误如下:" + ex.Message;
}
return(ToJsonContent(result));
}
/// <summary>
/// 系统-菜单-删除
/// </summary>
/// <returns></returns>
public ActionResult Sys_Menu_Del_Server(string Ids)
{
CommonResult result = new CommonResult();
var arrIds = Ids.Split(',');
var rs = new AuthorityClient().Sys_Menu_BatchDel(arrIds);
if (rs == "0")
{
result.IsSuccess = true;
}
else
{
result.IsSuccess = false;
result.ErrorMsg = rs;
}
return(ToJsonContent(result));
}
/// <summary>
/// xxp 获取设备的执行信息
/// </summary>
/// <param name="strDevCode">设备编码</param>
/// <returns></returns>
public CommonResult <List <V_DV_DevExecute> > GetDeviceExecuteByDevCode(string strDevCode)
{
var result = new CommonResult <List <V_DV_DevExecute> >();
try
{
var dbSession = new DBService <V_DV_DevExecute>().DbSession;
result.Data = dbSession.GetQueryable(t => t.ZGCode == strDevCode).ToList();
}
catch (Exception ex)
{
Utils.Logger.Error(ex.ToString());
throw ex;
}
return(result);
}
public IActionResult SendMakePhoneCallNotice(string userId, string tell, string tell2)
{
CommonResult result = new CommonResult();
try
{
tell = tell.Replace(" ", "");
string message = "{\"telphone\":\"" + tell2 + "\"}";
result = Messenger.SendMakePhoneCallNotice(userId, tell, message, "");
}
catch (Exception ex)
{
result.ErrMsg = ex.Message;
Log4NetHelper.Error("更新用户电话号码 UpdatePhone", ex);
}
return(ToJsonContent(result));
}
public override async Task <IActionResult> UpdateAsync(MenuInputDto tinfo)
{
CommonResult result = new CommonResult();
Menu info = iService.Get(tinfo.Id);
info.FullName = tinfo.FullName;
info.EnCode = tinfo.EnCode;
info.SystemTypeId = tinfo.SystemTypeId;
info.ParentId = tinfo.ParentId;
info.Icon = tinfo.Icon;
info.EnabledMark = tinfo.EnabledMark;
info.SortCode = tinfo.SortCode;
info.Description = tinfo.Description;
info.MenuType = tinfo.MenuType;
info.ActiveMenu = tinfo.ActiveMenu;
if (info.MenuType == "F")
{
info.IsFrame = false;
info.Component = "";
info.UrlAddress = "";
}
else
{
info.Component = tinfo.Component;
info.IsFrame = tinfo.IsFrame;
info.UrlAddress = tinfo.UrlAddress;
}
info.IsShow = tinfo.IsShow;
OnBeforeUpdate(info);
bool bl = await iService.UpdateAsync(info, tinfo.Id).ConfigureAwait(false);
if (bl)
{
result.ErrCode = ErrCode.successCode;
result.ErrMsg = ErrCode.err0;
}
else
{
result.ErrMsg = ErrCode.err43002;
result.ErrCode = "43002";
}
return(ToJsonContent(result));
}
/// <summary>
/// 系统-菜单-删除
/// </summary>
/// <returns></returns>
public ActionResult Sys_Menu_Del_Server(string Ids)
{
CommonResult result = new CommonResult();
var arrIds = Ids.Split(',');
var rs = new WaterFeeWeb.ServiceReference1.AuthorityClient().Sys_Menu_BatchDel(arrIds);
if (rs == "0")
{
result.Success = true;
}
else
{
result.Success = false;
result.ErrorMessage = rs;
}
return(ToJsonContent(result));
}
/// <summary>
/// 根据设备编码获取数据，初期用于设备状态的获取XCQ20161217
/// </summary>
/// <param name="Devcode"></param>
/// <returns></returns>
public CommonResult <List <vw_DurmsUpFeeding> > GetDurmsUpFeedingByDevCode(string Devcode)
{
var result = new CommonResult <List <vw_DurmsUpFeeding> >();
try
{
var dbSession = new DBService <vw_DurmsUpFeeding>().DbSession;
result.Data = dbSession.GetQueryable(t => t.DevCode == Devcode).ToList();
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
result.StackTrace = ex.StackTrace;
}
return(result);
}
/// <summary>
/// 根据排配单号获取当前工艺操作明细列表 XCQ20161217
/// </summary>
/// <param name="ArrangedVouchCode"></param>
/// <returns></returns>
public CommonResult <List <ArrangedVouchLog> > GetArrangedVouchLogByCode(string ArrangedVouchCode)
{
var result = new CommonResult <List <ArrangedVouchLog> >();
try
{
var dbSession = new DBService <ArrangedVouchLog>().DbSession;
result.Data = dbSession.GetQueryable(t => t.ArrangedVouchCode == ArrangedVouchCode).OrderByDescending(t => t.AutoID).ToList();
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
result.StackTrace = ex.StackTrace;
}
return(result);
}
/// <summary>
/// 根据登录名称获取体重数据
/// </summary>
/// <param name="PerCode"></param>
/// <returns></returns>
public CommonResult <Person> GetPersonByPerCode(string PerCode)
{
var result = new CommonResult <Person>();
try
{
var dbSession = new DBService <Person>().DbSession;
result.Data = dbSession.GetQueryable(t => t.PersonCode == PerCode).FirstOrDefault();
}
catch (Exception ex)
{
Utils.Logger.Error(ex.Message);
throw ex;
}
return(result);
}
/// <summary>
/// 获取当天的排配数据
/// </summary>
/// <returns></returns>
public CommonResult <ArrangedVouch> GetArrangedBySameTime()
{
var result = new CommonResult <ArrangedVouch>();
try
{
var dbSession = new DBService <ArrangedVouch>().DbSession;
result.Data = dbSession.GetQueryable(t => t.VouchDate.Year == DateTime.Now.Year && t.VouchDate.Month == DateTime.Now.Month && t.VouchDate.Day == DateTime.Now.Day).OrderByDescending(t => t.ID).FirstOrDefault();
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
result.StackTrace = ex.StackTrace;
}
return(result);
}
public ActionResult UpDown(string id, bool up)
{
CommonResult result = new CommonResult();
if (!string.IsNullOrEmpty(id))
{
try
{
result.Success = BLLFactory <WebFavorite> .Instance.UpDown(id, up);
}
catch (Exception ex)
{
result.ErrorMessage = ex.Message;
}
}
return(ToJsonContent(result));
}
//客户档案统计
public ActionResult StatClientArcData_Server()
{
CommonResult result = new CommonResult();
var endcode = Session["IntEndCode"] ?? "0";
var DteBegin = Request["WHC_dtStart"].ToDateTime();
var DteEnd = Request["WHC_dtEnd"].ToDateTime();
try
{
var rs = new DbServiceReference.ServiceDbClient().StatClientArcData(endcode.ToString().ToInt(), DteBegin, DteEnd);
if (rs.IsSuccess)
{
DataTable dts = JsonConvert.DeserializeObject <DataTable>(rs.StrData1);
if (dts.Rows.Count > 0)
{
int rows = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
int page = Request["page"] == null ? 1 : int.Parse(Request["page"]);
DataTable dat = new DataTable();
//复制源的架构和约束
dat = dts.Clone();
// 清除目标的所有数据
dat.Clear();
//对数据进行分页
for (int i = (page - 1) * rows; i < page * rows && i < dts.Rows.Count; i++)
{
dat.ImportRow(dts.Rows[i]);
}
//最重要的是在后台取数据放在json中要添加个参数total来存放数据的总行数，如果没有这个参数则不能分页
int total = dts.Rows.Count;
var dt = new { total, rows = dat };
result.Success = true;
return(ToJsonContentDate(dt));
}
}
else
{
result.ErrorMessage = rs.ErrorMsg;
result.Success = false;
}
}
catch (Exception ex)
{
result.ErrorMessage = "查询失败!错误如下:" + ex.Message;
}
return(ToJsonContentDate(result));
}
/// <summary>
/// 查询执行主表数据CraftsProcessExecute，用于初期对象建立
/// </summary>
/// <returns></returns>
public CommonResult <List <CraftsProcessExecute> > GetCfPExecutes(string ArrangedVouchCode)
{
var result = new CommonResult <List <CraftsProcessExecute> >();
// string strArrangedVouchCode = null;
try
{
var dbSession = new DBService <CraftsProcessExecute>().DbSession;
result.Data = dbSession.GetQueryable(t => t.ArrangedVouchCode == ArrangedVouchCode).ToList();
}
catch (Exception ex)
{
Utils.Logger.Error(ex.Message);
throw ex;
}
return(result);
}
/// <summary>
/// 根据排配单号获取最新执行主表CraftsProcessExecute数据
/// 2017-01-09修正为当前最新执行状态数据，增加t.ExecuteStatus != 0 && t.ExecuteStatus != 99判断条件
/// </summary>20170110XC1
/// <param name="ArrangedVouchCode"></param>
/// <returns></returns>
public CommonResult <CraftsProcessExecute> GetCfPExecuteByArrangedVouchCode(string ArrangedVouchCode)
{
var result = new CommonResult <CraftsProcessExecute>();
try
{
var dbSession = new DBService <CraftsProcessExecute>().DbSession;
result.Data = dbSession.GetQueryable(t => t.ArrangedVouchCode == ArrangedVouchCode && t.ExecuteStatus != 0 && t.ExecuteStatus != 99).OrderByDescending(t => t.ExecuteID).FirstOrDefault();
// result.Data = dbSession.GetQueryable().OrderBy(t => t.ExecuteID).OrderBy(t => t.CraftsName).ToList();
}
catch (Exception ex)
{
Utils.Logger.Error(ex.Message);
throw ex;
}
return(result);
}
public virtual async Task <IActionResult> DeleteAsync(TKey id)
{
CommonResult result = new CommonResult();
bool bl = await iService.DeleteAsync(id).ConfigureAwait(false);
if (bl)
{
result.ErrCode = ErrCode.successCode;
result.ErrMsg = ErrCode.err0;
}
else
{
result.ErrMsg = ErrCode.err43003;
result.ErrCode = "43003";
}
return(ToJsonContent(result));
}
/// <summary>
/// 遍历获取IP登记表所有IP数据，暂定匹配条件为状态是0的时候，登记表中新建数据默认status为0
/// </summary>20170117XCQ
/// <returns></returns>
public CommonResult <List <IPRegistForm> > GetAllIPRegistForm()
{
var result = new CommonResult <List <IPRegistForm> >();
try
{
var dbSession = new DBService <IPRegistForm>().DbSession;
result.Data = dbSession.GetQueryable(t => t.Status == 0).ToList();
}
catch (Exception ex)
{
Utils.Logger.Error(ex.Message);
throw ex;
}
return(result);
}
public virtual async Task <CommonResult <TODto> > GetById(TKey id)
{
CommonResult <TODto> result = new CommonResult <TODto>();
TODto info = await iService.GetOutDtoAsync(id);
if (info != null)
{
result.ErrCode = ErrCode.successCode;
result.ResData = info;
}
else
{
result.ErrMsg = ErrCode.err50001;
result.ErrCode = "50001";
}
return(result);
}
///2016/12/02
/// <summary>
/// 获取设备接口集合
/// </summary>
/// <param name="PageSize">每页大小</param>
/// <param name="CurrPage">当前页面</param>
/// <param name="TotalNum">总条数</param>
/// <param name="strDevCode">设备编码</param>
/// <param name="strDeviCode">设备接口编码</param>
/// <param name="strDeviName">设备接口名称</param>
/// <returns></returns>
public CommonResult <List <QC_DrumsFindLeakReport> > GetQCDrumsFindLeak()//int PageSize, int CurrPage, ref int TotalNum,string DevpCodet => t.DevpCode == DevpCode
{
var result = new CommonResult <List <QC_DrumsFindLeakReport> >();
try
{
var dbSession = new DBService <QC_DrumsFindLeakReport>().DbSession;
result.Data = dbSession.GetQueryable().ToList();
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
result.StackTrace = ex.StackTrace;
}
return(result);
}
public virtual IActionResult Delete(TKey id)
{
CommonResult result = new CommonResult();
bool bl = iService.Delete(id);
if (bl)
{
result.ErrCode = ErrCode.successCode;
result.ErrMsg = ErrCode.err0;
}
else
{
result.ErrMsg = ErrCode.err43003;
result.ErrCode = "43003";
}
return(ToJsonContent(result));
}
public IActionResult Logout()
{
CommonResult result = new CommonResult();
YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper();
yuebonCacheHelper.Remove("login_user_" + CurrentUser.UserId);
yuebonCacheHelper.Remove("User_Function_" + CurrentUser.UserId);
UserLogOn userLogOn = _userLogOnService.GetWhere("UserId='" + CurrentUser.UserId + "'");
userLogOn.UserOnLine = false;
_userLogOnService.Update(userLogOn, userLogOn.Id);
CurrentUser = null;
result.Success = true;
result.ErrCode = ErrCode.successCode;
result.ErrMsg = "成功退出";
return(ToJsonContent(result));
}
/// <summary>
/// 直接获取操作日志列表XCQ20161217
/// </summary>
/// <returns></returns>
public CommonResult <List <ArrangedVouchLog> > GetArrangedVouchLog()
{
var result = new CommonResult <List <ArrangedVouchLog> >();
try
{
var dbSession = new DBService <ArrangedVouchLog>().DbSession;
result.Data = dbSession.GetQueryable().ToList();
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
result.StackTrace = ex.StackTrace;
}
return(result);
}
public async Task <IActionResult> SaveUserTheme(UserThemeInputDto info)
{
CommonResult result = new CommonResult();
try
{
result.Success = await userLogOnService.SaveUserTheme(info, CurrentUser.UserId);
result.ErrCode = ErrCode.successCode;
}
catch (Exception ex)
{
Log4NetHelper.Error("保存用户自定义的软件主题异常", ex);//错误记录
result.ErrMsg = ex.Message;
}
return(ToJsonContent(result));
}
public CommonResult <V_DV_DevExecute> GetDeviceExecuteByID(int strExctueID)
{
var result = new CommonResult <V_DV_DevExecute>();
try
{
var dbSession = new DBService <V_DV_DevExecute>().DbSession;
result.Data = dbSession.GetQueryable(t => t.ExecuteID == strExctueID).FirstOrDefault();
// result.Data = dbSession.GetQueryable(t => t.== strExctueID).FirstOrDefault();
}
catch (Exception ex)
{
Utils.Logger.Error(ex.ToString());
throw ex;
}
return(result);
}
/// <summary>
/// 根据转鼓名称获取数采仪数据20170414-BY XCQ
/// </summary>
/// <param name="Address"></param>
/// <returns></returns>
public CommonResult <List <V_DV_DevExecute> > GetDevViewListByZGName(string ZGName)
{
var result = new CommonResult <List <V_DV_DevExecute> >();
try
{
var dbSession = new DBService <V_DV_DevExecute>().DbSession;
result.Data = dbSession.GetQueryable(t => t.ZGName == ZGName && t.InterFaceStatus == 0 && t.WorkStatus == 0 && t.EquipStatus == 0).ToList();
//&& t.ZGCode == "ZG0102"&& t.ZGCode == "ZG0102"
}
catch (Exception ex)
{
Utils.Logger.Error(ex.ToString());
throw ex;
}
return(result);
}
public CommonResult <List <DeviceExecute> > GetAllExecute()
{
var result = new CommonResult <List <DeviceExecute> >();
try
{
var dbSession = new DBService <DeviceExecute>().DbSession;
result.Data = dbSession.GetQueryable().ToList();
}
catch (Exception ex)
{
Utils.Logger.Error(ex.ToString());
throw ex;
}
return(result);
}
public JsonResult LoginIn(LoginUser loginUser)
{
var userResult = new CommonResult<CyUserEntity>();
try
{
var user = new CyUserEntity()
{
UserName = loginUser.UserName,
UserPwd = loginUser.UserPwd,
ValideCode = loginUser.ValideCode
};
//验证用户信息
userResult = CyUserService.Login(user);
//验证成功
if (userResult.Success)
{
var cyUser = userResult.ResultObj;
var model = new UserModel()
{
UserNo = cyUser.UserNo,
UserName = cyUser.UserName,
NickName = cyUser.NickName,
TrueName = cyUser.TrueName,
MemberType = cyUser.MemberType,
Role = cyUser.Role
};
UserContext.SetAuthCookie(model, true);
var loginLog = new CyUserLoginLogEntity()
{
UserNo = cyUser.UserNo,
LoginIp = IpHelper.GetUserIpAddress(),
LoginTime = DateTime.Now
};
CyUserService.AddCyUserLoginLog(loginLog);
}
}
catch (Exception ex)
{
userResult.Success = false;
userResult.Message = ex.Message;
}
return Json(userResult, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 查询用户信息
/// </summary>
/// <param name="userName">用户名</param>
/// <returns></returns>
public CommonResult<CyUserEntity> GetCyUserByUserName(string userName)
{
var commonResult = new CommonResult<CyUserEntity>();
const string sql = @"SELECT [UserId]
,[UserNo]
,[UserName]
,[UserPwd]
,[NickName]
,[TrueName]
,[Gender]
,[MobilePhone]
,[Email]
,[QQ]
,[Industry]
,[Position]
,[Birthday]
,[BirthPlace]
,[Residence]
,[MemberType]
,[Role]
,[CreateUserNo]
,[CreateTime]
,[UpdateUserNo]
,[UpdateTime]
,[DataStatus]
FROM [dbo].[CyUser](NOLOCK)
WHERE UserName=@UserName AND DataStatus=@DataStatus";
using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyReadConnectionStringName))
{
try
{
var model = conn.Query<CyUserEntity>(sql, new { UserName = userName, DataStatus = DataStatus.Valid }).ToList();
commonResult.Success = true;
commonResult.Message = "执行成功";
commonResult.ResultObjList = model;
}
catch (Exception ex)
{
commonResult.Success = false;
commonResult.IsHappenEx = true;
commonResult.Message = "执行失败";
commonResult.ExMessage = ex.Message;
commonResult.ExData = ex;
}
return commonResult;
}
}
/// <summary>
/// 添加用户信息
/// </summary>
/// <param name="entity">实体</param>
/// <param name="trans">事务</param>
/// <returns>执行结果</returns>
public CommonResult<string> AddCyUser(CyUserEntity entity, IDbTransaction trans = null)
{
var commonResult = new CommonResult<string>();
const string sql = @"INSERT INTO [dbo].[CyUser]
([UserNo]
,[UserName]
,[UserPwd]
,[NickName]
,[TrueName]
,[Gender]
,[MobilePhone]
,[Email]
,[QQ]
,[Industry]
,[Position]
,[Birthday]
,[BirthPlace]
,[Residence]
,[MemberType]
,[Role]
,[CreateUserNo]
,[CreateTime]
,[UpdateUserNo]
,[UpdateTime]
,[DataStatus])
VALUES
(@UserNo
,@UserName
,@UserPwd
,@NickName
,@TrueName
,@Gender
,@MobilePhone
,@Email
,@QQ
,@Industry
,@Position
,@Birthday
,@BirthPlace
,@Residence
,@MemberType
,@Role
,@CreateUserNo
,@CreateTime
,@UpdateUserNo
,@UpdateTime
,@DataStatus)";
if (trans == null)
{
using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyMainDbConnectionStringName))
{
try
{
var rows = conn.Execute(sql, entity);
commonResult.Success = true;
commonResult.Message = "执行成功";
commonResult.EffectRows = rows;
}
catch (Exception ex)
{
commonResult.Success = false;
commonResult.IsHappenEx = true;
commonResult.Message = "执行失败";
commonResult.ExMessage = ex.Message;
commonResult.ExData = ex;
}
}
}
else
{
try
{
var rows = trans.Connection.Execute(sql, entity, transaction: trans);
commonResult.Success = true;
commonResult.Message = "执行成功";
commonResult.EffectRows = rows;
}
catch (Exception ex)
{
commonResult.Success = false;
commonResult.IsHappenEx = true;
commonResult.Message = "执行失败";
commonResult.ExMessage = ex.Message;
commonResult.ExData = ex;
}
}
return commonResult;
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="entity">实体</param>
/// <param name="trans">事务</param>
/// <returns>执行结果</returns>
public CommonResult<string> ModifyCyUser(CyUserEntity entity, IDbTransaction trans = null)
{
var commonResult = new CommonResult<string>();
const string sql = @"UPDATE [dbo].[CyUser]
SET [NickName] =@NickName
,[TrueName] =@TrueName
,[Gender] =@Gender
,[MobilePhone] =@MobilePhone
,[Email] =@Email
,[QQ] =@QQ
,[Birthday] =@Birthday
,[BirthPlace] =@BirthPlace
,[Residence] =@Residence
,[UpdateUserNo] =@UpdateUserNo
,[UpdateTime] =@UpdateTime
WHERE UserNo=@UserNo";
if (trans == null)
{
using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyMainDbConnectionStringName))
{
try
{
var rows = conn.Execute(sql, entity);
commonResult.Success = true;
commonResult.Message = "执行成功";
commonResult.EffectRows = rows;
}
catch (Exception ex)
{
commonResult.Success = false;
commonResult.IsHappenEx = true;
commonResult.Message = "执行失败";
commonResult.ExMessage = ex.Message;
commonResult.ExData = ex;
}
}
}
else
{
try
{
var rows = trans.Connection.Execute(sql, entity, transaction: trans);
commonResult.Success = true;
commonResult.Message = "执行成功";
commonResult.EffectRows = rows;
}
catch (Exception ex)
{
commonResult.Success = false;
commonResult.IsHappenEx = true;
commonResult.Message = "执行失败";
commonResult.ExMessage = ex.Message;
commonResult.ExData = ex;
}
}
return commonResult;
}
/// <summary>
/// 添加登录日志
/// </summary>
/// <param name="entity"></param>
/// <param name="trans"></param>
/// <returns></returns>
public CommonResult<string> AddCyUserLoginLog(CyUserLoginLogEntity entity, IDbTransaction trans = null)
{
var commonResult = new CommonResult<string>();
const string sql = @"INSERT INTO [dbo].[CyUserLoginLog]
([UserNo]
,[LoginTime]
,[LoginIp])
VALUES
(@UserNo
,@LoginTime
,@LoginIp)";
if (trans == null)
{
using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyMainDbConnectionStringName))
{
try
{
var rows = conn.Execute(sql, entity);
commonResult.Success = true;
commonResult.Message = "执行成功";
commonResult.EffectRows = rows;
}
catch (Exception ex)
{
commonResult.Success = false;
commonResult.IsHappenEx = true;
commonResult.Message = "执行失败";
commonResult.ExMessage = ex.Message;
commonResult.ExData = ex;
}
}
}
else
{
try
{
var rows = trans.Connection.Execute(sql, entity, transaction: trans);
commonResult.Success = true;
commonResult.Message = "执行成功";
commonResult.EffectRows = rows;
}
catch (Exception ex)
{
commonResult.Success = false;
commonResult.IsHappenEx = true;
commonResult.Message = "执行失败";
commonResult.ExMessage = ex.Message;
commonResult.ExData = ex;
}
}
return commonResult;
}
public CommonResult<CyUserEntity> Login(CyUserEntity user)
{
try
{
var commonResult = new CommonResult<CyUserEntity>();
if (string.IsNullOrEmpty(user.UserName))
{
commonResult.Success = false;
commonResult.Message = "用户名为空";
return commonResult;
}
if (string.IsNullOrEmpty(user.UserPwd))
{
commonResult.Success = false;
commonResult.Message = "密码为空";
return commonResult;
}
var userResult = CyUserProvider.GetCyUserByUserName(user.UserName);
if (userResult.Success)
{
var userModel = userResult.ResultObjList;
if (userModel.Count == 0)
{
commonResult.Success = false;
commonResult.Message = "用户名不存在";
return commonResult;
}
//如果同一用户名出现重复记录
if (userModel.Count > 1)
{
commonResult.Success = false;
commonResult.Message = "用户信息异常请联系管理员";
return commonResult;
}
if (userModel[0].UserPwd != StringUtil.ToHashString(user.UserPwd))
{
commonResult.Success = false;
commonResult.Message = "密码错误";
return commonResult;
}
if (!string.Equals(HttpContext.Current.Session["vcode"].ToString(), user.ValideCode, StringComparison.CurrentCultureIgnoreCase))
{
commonResult.Success = false;
commonResult.Message = "验证码填写错误";
return commonResult;
}
commonResult.Success = true;
commonResult.Message = "验证成功";
commonResult.ResultObj = userModel[0];
}
else
{
commonResult = userResult;
return commonResult;
}
return commonResult;
}
catch (Exception)
{
throw;
}
}
public CommonResult<string> AddCyCompany(CyCompanyEntity entity, IDbTransaction trans = null)
{
var commonResult = new CommonResult<string>();
const string sql = @"INSERT INTO [dbo].[CyCompany]
([UserNo]
,[CompanyName]
,[Industry]
,[ContactName]
,[ContactPhone]
,[ContactEmail]
,[CompanyTel]
,[CompanyFax]
,[CompanyAddress]
,[CompanyWebsite]
,[CompanyProfile]
,[CreateUserNo]
,[CreateTime]
,[UpdateUserNo]
,[UpdateTime]
,[DataStatus])
VALUES
(@UserNo
,@CompanyName
,@Industry
,@ContactName
,@ContactPhone
,@ContactEmail
,@CompanyTel
,@CompanyFax
,@CompanyAddress
,@CompanyWebsite
,@CompanyProfile
,@CreateUserNo
,@CreateTime
,@UpdateUserNo
,@UpdateTime
,@DataStatus)";
if (trans == null)
{
using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyMainDbConnectionStringName))
{
try
{
var rows = conn.Execute(sql, entity);
commonResult.Success = true;
commonResult.Message = "执行成功";
commonResult.EffectRows = rows;
}
catch (Exception ex)
{
commonResult.Success = false;
commonResult.IsHappenEx = true;
commonResult.Message = "执行失败";
commonResult.ExMessage = ex.Message;
commonResult.ExData = ex;
}
}
}
else
{
try
{
var rows = trans.Connection.Execute(sql, entity, transaction: trans);
commonResult.Success = true;
commonResult.Message = "执行成功";
commonResult.EffectRows = rows;
}
catch (Exception ex)
{
commonResult.Success = false;
commonResult.IsHappenEx = true;
commonResult.Message = "执行失败";
commonResult.ExMessage = ex.Message;
commonResult.ExData = ex;
}
}
return commonResult;
}
