/// <summary>
/// 获取工厂时间—WDATE、SHT、BAN、STIME、ETIME
/// </summary>
/// <returns></returns>
public DataTable GetShift()
{
try
{
string strSql = "GETSHIFT";
return(db.ExecuteDataTable(strSql));
}
catch { throw; }
}
/// <summary>
/// 获取菜单权限数据
/// </summary>
/// <param name="loginName"></param>
/// <returns></returns>
public DataTable GetPermissions(string loginName)
{
try
{
string strSql = string.Format(@"
SELECT
DISTINCT C.Id,C.DisplayName,C.NodeURL,C.DisplayOrder,C.ParentNodeId,C.MenuLevel,C.FunImgNum,C.Editor,C.CreateDate
FROM T_MOBILE_GROUP (NOLOCK) AS A LEFT JOIN T_MOBILE_PERMISSIONS (NOLOCK) AS B ON A.GroupId = B.GroupId
LEFT JOIN T_MOBILE_MENU (NOLOCK) AS C ON B.MobileMenuId = C.Id WHERE A.LOGINNAME = '{0}' AND MenuLevel = '2' AND (C.NodeURL <> '' AND C.NodeURL IS NOT NULL)
ORDER BY C.DISPLAYORDER ASC ", loginName);
return(db.ExecuteDataTable(strSql));
}
catch { throw; }
}
public IList <T> ExecuteStoredProcedure <T>(ISession session, string storedProcName, SqlParameter[] parameters, out int recordCount, bool keepSession) where T : new()
{
try
{
OpenConnect();
DataTable dt = MsSqlHelper.ExecuteDataTable(session.Connection as SqlConnection, CommandType.StoredProcedure, storedProcName, parameters);
IList <T> list = JF.Common.Libary.ModelFunc.ModelConvertHelper <T> .ToList(dt);
if (list == null)
{
recordCount = 0;
return(null);
}
recordCount = list.Count;
return(list);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (!keepSession)
{
Disconnect();
}
}
}
/// <summary>
/// 获取语言
/// </summary>
/// <param name="key"></param>
/// <returns></returns>
public DataTable GetLanguage()
{
try
{
string sql = " SELECT Chinese,English,Other FROM TranslationConfig (NOLOCK) WHERE Other != ''";
return(db.ExecuteDataTable(sql));
}
catch
{
throw;
}
}
public bool ExecuteStoredProcedure(ISession session, string storedProcName, SqlParameter[] parameters, bool keepSession)
{
try
{
OpenConnect();
MsSqlHelper.ExecuteDataTable(session.Connection as SqlConnection, CommandType.StoredProcedure, storedProcName, parameters);
return(true);
}
catch (Exception ex)
{
LogExepttion(ex);
return(false);
}
finally
{
if (!keepSession)
{
Disconnect();
}
}
}
public DataTable GetFixedAssetInfo(string strDepartment, string index = "0")
{
try
{
string strSql = string.Format(@"
SELECT a.BARCODE,
a.ASSETCODE,
a.ASSETNAME,
a.GUIGEXINGHAO,
right('00'+a.ZICHANZHUANGTAI,2) ZICHANZHUANGTAI,
zczt.ZHUANGTAIMINGCHENG,
a.CUNFANGDIDIAN,
cfdept.DEPTNAME CUNFANGDIDIANNAME,
a.SHIYONGBUMEN,
dept.DEPTNAME SHIYONGBUMENNAME,
a.GUYUANBIANHAO,
emp.EMPLOYEENAME,
a.ZICHANSHIBEIMA,
a.XULIEHAO,
a.BEIZHU
FROM FIXEDASSETINFO a
left join ZICHANZHUANGTAI zczt on right('00'+a.ZICHANZHUANGTAI,2)= zczt.ZHUANGTAICODE --資產狀態
left join DEPARTMENTINFO dept on a.SHIYONGBUMEN=dept.DEPTCODE --使用部門
left join DEPARTMENTINFO cfdept on a.CUNFANGDIDIAN=cfdept.DEPTCODE --存放部門
left join EMPLOYEEINFO emp on a.GUYUANBIANHAO=emp.EMPLOYEECODE --僱員姓名
WHERE 1 = 1 AND DATAFLAG = 0 AND BARCODE ! = ''
and ADMINDEPT = '{0}'
", strDepartment);
if (strDepartment == "全部")
{
strSql =
@"SELECT a.BARCODE,
a.ASSETCODE,
a.ASSETNAME,
a.GUIGEXINGHAO,
right('00'+a.ZICHANZHUANGTAI,2) ZICHANZHUANGTAI,
zczt.ZHUANGTAIMINGCHENG,
a.CUNFANGDIDIAN,
cfdept.DEPTNAME CUNFANGDIDIANNAME,
a.SHIYONGBUMEN,
dept.DEPTNAME SHIYONGBUMENNAME,
a.GUYUANBIANHAO,
emp.EMPLOYEENAME,
a.ZICHANSHIBEIMA,
a.XULIEHAO,
a.BEIZHU
FROM FIXEDASSETINFO a
left join ZICHANZHUANGTAI zczt on right('00'+a.ZICHANZHUANGTAI,2)= zczt.ZHUANGTAICODE --資產狀態
left join DEPARTMENTINFO dept on a.SHIYONGBUMEN=dept.DEPTCODE --使用部門
left join DEPARTMENTINFO cfdept on a.CUNFANGDIDIAN=cfdept.DEPTCODE --存放部門
left join EMPLOYEEINFO emp on a.GUYUANBIANHAO=emp.EMPLOYEECODE --僱員姓名
WHERE 1 = 1 AND DATAFLAG = 0 AND BARCODE ! = ''
";
}
if (index == "test")
{
strSql =
@" SELECT a.BARCODE,
a.ASSETCODE,
a.ASSETNAME,
a.GUIGEXINGHAO,
right('00'+a.ZICHANZHUANGTAI,2) ZICHANZHUANGTAI,
zczt.ZHUANGTAIMINGCHENG,
a.CUNFANGDIDIAN,
cfdept.DEPTNAME CUNFANGDIDIANNAME,
a.SHIYONGBUMEN,
dept.DEPTNAME SHIYONGBUMENNAME,
a.GUYUANBIANHAO,
emp.EMPLOYEENAME,
a.ZICHANSHIBEIMA,
a.XULIEHAO,
a.BEIZHU
FROM FIXEDASSETINFO a
left join ZICHANZHUANGTAI zczt on right('00'+a.ZICHANZHUANGTAI,2)= zczt.ZHUANGTAICODE --資產狀態
left join DEPARTMENTINFO dept on a.SHIYONGBUMEN=dept.DEPTCODE --使用部門
left join DEPARTMENTINFO cfdept on a.CUNFANGDIDIAN=cfdept.DEPTCODE --存放部門
left join EMPLOYEEINFO emp on a.GUYUANBIANHAO=emp.EMPLOYEECODE --僱員姓名
WHERE 1 = 1 AND DATAFLAG = 0 AND BARCODE ! = ''
and BARCODE='830000100'";
}
//FixedAssetInfoModel model = new FixedAssetInfoModel();
return(db.ExecuteDataTable(strSql));
}
catch { throw; }
//return new FixedAssetInfoModel();
}