//所有部门奖金页面
public ActionResult Detail(int DepartID, string CompanyId)
{
try
{
//解密
CompanyId = Base64MIMA.JIE(CompanyId);
//加密
ViewBag.CompanyId = Base64MIMA.JIA(CompanyId);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
string sqlDepart = string.Format("select BonusDataID,b2.BIName,Name,DisDate,EarMoney from BonusData2 b inner join Employee e on b.DisMan=e.EmpID inner join BonusItem b2 on b.BonusItemID=b2.BonusItemID where BonusType=0 and EarMan='{0}' AND b2.CompanyID='{1}' AND e.CompanyID='{1}'", DepartID, CompanyId);
DataTable DepartName = sql.GetDataTableCommand(sqlDepart);
if (DepartName.Rows.Count > 0)
{
ViewBag.Detail = DepartName;
}
else
{
ViewBag.Detail = null;
}
return(View());
}
//部门提现
public ActionResult depDeposit(string departID, string companyID)
{
try
{
////加密
//ViewBag.userID = userID;
//解密
companyID = Base64MIMA.JIE(companyID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
try
{
/* string departID = getDepartID(userID);*/ //获得部门ID
string allUserID = getAllUserID(departID, "dep"); //获取提取的所有BD2中ID
decimal SumMoney = getAllMoney(allUserID); //获取要提取的总金额
string CompanyID = companyID; //公司ID
string aa = sql.EditDataCommand("EXEC departTIJIAO " + departID + ",'" + allUserID + "'," + SumMoney + "," + companyID + "");
if (aa == "0")
{
return(Content("提现成功，正在审核"));
}
else
{
return(Content("未知错误，提现失败"));
}
}
catch (Exception)
{
return(Content("提现失败"));
}
}
/// <summary>
/// 上传图片
/// </summary>
/// <param name="serverId"></param>
/// <returns></returns>
public ActionResult UploadImge(string serverId, string companyid)//原图
{
log.AppenLog("上传图片");
companyid = Base64MIMA.JIE(companyid);
//return Content("222");
//
//WriteLog("serverId" + serverId);
List <string> rsFilePathList = new List <string>();
try
{
string imageFilePath = "";
string imgServerIds = serverId; // 微信服务器图片Id
//WriteLog("imgServerIds微信服务器图片Id" + imgServerIds);
List <string> imgServerIdList = imgServerIds.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToList();
//WriteLog("imgServerIdList集合:" + imgServerIdList);
// WriteLog("imgServerIdList.Count():图片长度" + imgServerIdList.Count());
foreach (string imgServerId in imgServerIdList)
{
//WriteLog("imgServerId:" + imgServerId);
// 1)获取图片
ImgHelper imgH = new ImgHelper();
Image img = imgH.GetImage(imgServerId, companyid);
// 2)存放本地
imageFilePath = imgH.SaveWeChatAttFileOfImage(img, "Sunpn");
rsFilePathList.Add(imageFilePath);
}
return(Content(imageFilePath));
}
catch (Exception ex)
{
log.AppenLog(ex.Message);
return(Content(ex.Message));
}
}
/// <summary>
/// 员工搜索补全
/// </summary>
/// <param name="keyword"></param>
/// <param name="CompanyId"></param>
/// <returns></returns>
public ActionResult GetInfo(string keyword, string CompanyID)
{
try
{
//加密
ViewBag.CompanyId = CompanyID;
//解密
CompanyID = Base64MIMA.JIE(CompanyID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
keyword = keyword.Trim().Replace(" ", "");
string sqlserach = "";
sqlserach = string.Format("select Name from dbo.Employee where (SpellJX like '%{0}%' or SpellQP like '%{1}%' or Name like '%{2}%') and CompanyID='{3}'", keyword, keyword, keyword, CompanyID);
DataSet ds = sql.GetDataSetCommand(sqlserach);
string info = JsonConvert.SerializeObject(ds);
info = info.Replace("Table", "data").Replace("Name", "title");
return(Content(info));
}
//提交意见反馈
public ActionResult CommSugg(string ResonContent, string ResonImg, string comType, string comId, string compId)
{
if (comId == "" || comId == null)
{
return(Content("网络错误，稍后请重试"));
}
comId = Base64MIMA.JIE(comId);
log.AppenLog("提交反馈：" + ResonContent + ",ResonImg:" + ResonImg + ",comType:" + comType + ",comId:" + comId);
int ImgCount = 0;
if (ResonImg != "")
{
ResonImg = ResonImg.Substring(0, ResonImg.Length - 1);
ImgCount = ResonImg.Split(',').Count();
}
log.AppenLog("ImgCount:" + ImgCount);
string sqlstr = string.Format($"exec proc_Suggection 'InsertSuggestion','{ResonContent}','{ResonImg}','{comType}','{comId}','',{ImgCount},'{Base64MIMA.JIE(compId)}'");
log.AppenLog("提交反馈sqlstr：" + sqlstr);
string info = sql.EditDataCommand(sqlstr);
if (info == "0")
{
return(Content("ok"));
}
else
{
return(Content("提交意见失败"));
}
}
//被授权人列表页面
public ActionResult Collect(string BonusItemID, string CompanyID)
{
try
{
//解密
CompanyID = Base64MIMA.JIE(CompanyID);
//加密
ViewBag.CompanyId = Base64MIMA.JIA(CompanyID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
//string dtsql = string.Format("SELECT DISTINCT BonusImpower.BonusItemID,BIPID,BIName,EmpID FROM dbo.BonusImpower INNER JOIN dbo.BonusItem ON BonusItem.BonusItemID = BonusImpower.BonusItemID WHERE ImpowerDate>=CONVERT(varchar(30),DATEADD(MM,DATEDIFF(MM,0,GETDATE()),0),102) AND EmpID='{0}'", EmpID);
//查看此奖金项本月授权给过哪些人
string dtsql = string.Format("SELECT DISTINCT BonusImpower.EmpID,Employee.EmpPhotos,BonusItemID,Name FROM dbo.BonusImpower INNER JOIN dbo.Employee ON Employee.EmpID = BonusImpower.EmpID WHERE BonusItemID='{0}' and CompanyID='{1}' AND ImpowerDate>=CONVERT(varchar(30),DATEADD(MM,DATEDIFF(MM,0,GETDATE()),0),102) GROUP BY BonusImpower.EmpID,Employee.EmpPhotos,BonusItemID,Name having SUM(RemainMoney)>0", BonusItemID, CompanyID);
DataTable dt = sql.GetDataTableCommand(dtsql);
if (dt.Rows.Count > 0)
{
ViewBag.ds = dt;
}
else
{
ViewBag.ds = null;
}
return(View());
}
//删除
public ActionResult Delete(string EmpID, string CompanyID)
{
try
{
//解密
CompanyID = Base64MIMA.JIE(CompanyID);
//加密
ViewBag.CompanyId = Base64MIMA.JIA(CompanyID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
string delsql = string.Format("delete from dbo.Employee where EmpID='{0}' and CompanyID='{1}'", EmpID, CompanyID);
string del = sql.EditDataCommand(delsql);
if (del == "0")
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
// GET: BonusItemRule
//public ActionResult Index()
//{
// //公司级奖金
// string gs = string.Format("select * from BonusItem where BIType=0");
// DataTable gsdt = sql.GetDataTableCommand(gs);
// if (gsdt.Rows.Count > 0)
// {
// ViewBag.gs = gsdt;
// }
// else
// {
// ViewBag.gs = null;
// }
// //部门级奖金
// string gr = string.Format("select * from BonusItem where BIType=1");
// DataTable grdt = sql.GetDataTableCommand(gr);
// if (grdt.Rows.Count > 0)
// {
// ViewBag.gr = grdt;
// }
// else
// {
// ViewBag.gr = null;
// }
// return View();
//}
//新增规则页面
public ActionResult AddRule(string BonusItemID, string CompanyID)
{
try
{
//解密
CompanyID = Base64MIMA.JIE(CompanyID);
//加密
ViewBag.CompanyId = Base64MIMA.JIA(CompanyID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
string bisql = string.Format("select * from BonusItem where BonusItemID='{0}' and CompanyID='{1}'", BonusItemID, CompanyID);
DataTable bi = sql.GetDataTableCommand(bisql);
if (bi.Rows.Count > 0)
{
ViewBag.bi = bi;
}
else
{
ViewBag.bi = null;
}
return(View());
}
public ActionResult Detail(string CompanyID)
{
try
{
//解密
CompanyID = Base64MIMA.JIE(CompanyID);
//加密
ViewBag.CompanyId = Base64MIMA.JIA(CompanyID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
string detialsql = string.Format("select * from BonusItem where CompanyID='{0}'", CompanyID);
DataTable ds = sql.GetDataTableCommand(detialsql);
if (ds.Rows.Count > 0)
{
ViewBag.ds = ds;
}
else
{
ViewBag.ds = null;
}
return(View());
}
//员工界面
public ActionResult EmpGain(string empBounsID, string compid)
{
ViewBag.empBounsID = empBounsID;
compid = Base64MIMA.JIE(compid);
try
{
string sqls = string.Format(@"SELECT CASE WHEN BonusType=2 THEN e.Name WHEN BonusType=1 THEN b2.BIName END Bonusform,EarMoney,EarDate,
CASE WHEN IsGet=0 THEN '未领取' ELSE '已领取' END isget,BonusDataID FROM BonusData2 b LEFT JOIN dbo.Employee e ON b.DisMan=e.EmpID LEFT JOIN dbo.BonusItem b2 ON b.BonusItemID=b2.BonusItemID
WHERE EarMan='{0}' and b.CompanyId='{1}' and e.CompanyID='{1}' ORDER BY EarDate DESC", empBounsID, compid);
DataTable ds = sql.GetDataTableCommand(sqls);
if (ds.Rows.Count > 0)
{
ViewBag.Emp = ds;
}
else
{
ViewBag.Emp = null;
}
}
catch (Exception)
{
throw;
}
return(View());
}
//奖金项数据
public ActionResult DataInfo(string BonusItemID, string CompanyID)
{
try
{
//解密
CompanyID = Base64MIMA.JIE(CompanyID);
//加密
ViewBag.CompanyId = Base64MIMA.JIA(CompanyID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
DataTable dt = sql.GetDataTableProcedure("proc_BonusData", BonusItemID, CompanyID);
if (dt?.Rows.Count > 0 && dt.Rows[0][0].ToString() != "")
{
ViewBag.dt = dt;
}
else
{
ViewBag.dt = null;
}
return(View());
}
//主页面根据人名的分布视图
public ActionResult SearchInfo(string EmpName, string CompanyId)
{
try
{ //加密
ViewBag.CompanyId = CompanyId;
//解密
CompanyId = Base64MIMA.JIE(CompanyId);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
DataTable Empds = GetEmpJjInfo(EmpName, CompanyId);
if (Empds.Rows.Count > 0)
{
ViewBag.Emp = Empds;
}
else
{
ViewBag.Emp = null;
}
return(PartialView("_bonusData"));
}
// 主页面
public ActionResult Index(string CompanyId)
{
try
{
ViewBag.CompanyId = CompanyId;
//解密
CompanyId = Base64MIMA.JIE(CompanyId);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
DataTable Empds = GetEmpJjInfo("", CompanyId);
DataTable Depds = GetDepJjInfo("", CompanyId);
if (Depds.Rows.Count > 0)
{
ViewBag.Dep = Depds;
}
else
{
ViewBag.Dep = null;
}
if (Empds.Rows.Count > 0)
{
ViewBag.Emp = Empds;
}
else
{
ViewBag.Emp = null;
}
return(View());
}
//部门界面
public ActionResult DepGain(string depBounsID, string compid)
{
ViewBag.depBounsID = depBounsID;
compid = Base64MIMA.JIE(compid);
try
{
string sqls = string.Format(@"SELECT BIName,EarMoney,EarDate,
CASE WHEN IsGet=0 THEN '未领取' ELSE '已领取' END isget FROM BonusData2 b LEFT JOIN dbo.Depart d ON b.EarMan=d.DepartID LEFT JOIN dbo.BonusItem b2 ON b.BonusItemID=b2.BonusItemID
WHERE b.BonusType=0 and EarMan='{0}' and b.CompanyId='{1}' and d.CompanyID='{1}' ORDER BY EarDate DESC", depBounsID, compid);
DataTable ds = sql.GetDataTableCommand(sqls);
if (ds.Rows.Count > 0)
{
ViewBag.Dep = ds;
}
else
{
ViewBag.Dep = null;
}
}
catch (Exception)
{
throw;
}
return(View());
}
/// <summary>
/// 添加交易
/// </summary>
/// <returns></returns>
public ActionResult AddTrading(string Userid, double TradingMoney, string beizhuContent, string comUserid, string companyId)
{
if (Userid == "" || TradingMoney <= 0)
{
return(Content("输入有误"));
}
comUserid = Base64MIMA.JIE(comUserid);//解密
companyId = Base64MIMA.JIE(companyId);
string guidBeizuID = null;
string sqlstr = "";
if (beizhuContent != "")
{
guidBeizuID = System.Guid.NewGuid().ToString();//原因guid
sqlstr = string.Format("insert into ResonDetial values('{0}','{1}',2) ", guidBeizuID, beizhuContent);
sqlstr += string.Format("insert into BonusData2 values(newid(),'{0}',GETDATE(),'{1}',{3},GETDATE(),2,0,'{2}','{4}')", comUserid, Userid, guidBeizuID, TradingMoney, companyId);
}
else
{
sqlstr += string.Format("insert into BonusData2 values(newid(),'{0}',GETDATE(),'{1}',{2},GETDATE(),2,0,null,'{3}')", comUserid, Userid, TradingMoney, companyId);
}
string info = sql.EditDataCommand(sqlstr);
if (info == "0")
{
return(Content("ok"));
}
else
{
return(Content("付款失败"));
}
}
// GET: CompanyRegist
public ActionResult Index(string userID)
{
string UserJie = Base64MIMA.JIE(userID);
log.AppenLog("公司用户id：" + UserJie);
//先判断有没有公司id
string isact = string.Format("SELECT CompanyID FROM dbo.Employee WHERE CompanyID IN (select CompanyID from dbo.Company) AND EmpID='{0}'", UserJie);
DataTable dt = sql.GetDataTableCommand(isact);
if (dt?.Rows.Count > 0)
{
//如果有公司则判断公司是否激活
string iscodesql = string.Format(" SELECT IsTongguo,endDate FROM dbo.Company WHERE CompanyID='{0}'", dt.Rows[0][0].ToString());
DataTable ct = sql.GetDataTableCommand(iscodesql);
if (ct?.Rows[0]["IsTongguo"].ToString() == "0")
{
if ((DateTime)ct?.Rows[0]["endDate"] >= DateTime.Now)
{
return(Redirect("/Wo/Index?userID=" + userID));//如果已经激活则进入主页面
}
else
{
return(Content("<script>alert('您的使用期限已过,请联系我们!');history.go(-1);</script>"));
}
}
else
{
return(Content("<script>alert('您的公司已注册,但是暂未激活系统,请联系我们!');history.go(-1);</script>"));
}
}
else
{
return(View());
}
}
// GET: UserDepartBonus
public ActionResult Index(string userID)
{
try
{
//解密
userID = Base64MIMA.JIE(userID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
string sqlDepart = string.Format(@"
SELECT BonusDataID,BIName,EarMoney,Name,EarDate
FROM dbo.BonusData2 b INNER JOIN dbo.Depart d ON b.EarMan=d.DepartID INNER JOIN dbo.BonusItem b2 ON b.BonusItemID=b2.BonusItemID INNER JOIN dbo.Employee e ON b.DisMan=e.EmpID
WHERE BonusType=0 AND DepartPrincipal='{0}' ORDER BY EarDate DESC
", userID);
DataTable DepartName = sql.GetDataTableCommand(sqlDepart);
if (DepartName.Rows.Count > 0)
{
ViewBag.Detail = DepartName;
}
else
{
ViewBag.Detail = null;
}
return(View());
}
public ActionResult CompanyManager(string CompanyID)
{
try
{
////加密
//ViewBag.userID = userID;
//解密
CompanyID = Base64MIMA.JIE(CompanyID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
string infosql = string.Format("select Company.CompanyID,CompanyName,EmpID,Name,CompanyPhone,CompanyEmail,CompanyLogo,endDate,beginDate from Company LEFT JOIN dbo.Employee ON CompanyPrincipal=EmpID where Company.CompanyID='{0}'", CompanyID);
DataTable info = sql.GetDataTableCommand(infosql);
if (info?.Rows.Count > 0)
{
ViewBag.info = info;
}
else
{
ViewBag.info = null;
}
InitJsapi(Base64MIMA.JIA(CompanyID));
return(View());
}
//奖金授权页面
public ActionResult AddImpower(string BonusItemID, string CompanyID)
{
try
{
//解密
CompanyID = Base64MIMA.JIE(CompanyID);
//加密
ViewBag.CompanyId = Base64MIMA.JIA(CompanyID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
string addsql = string.Format("SELECT BonusItem.BonusItemID,BIPrincipal,BIName FROM BonusItem WHERE BonusItemID='{0}' and CompanyID='{1}'", BonusItemID, CompanyID);
DataTable dt = sql.GetDataTableCommand(addsql);
if (dt.Rows.Count > 0)
{
ViewBag.dt = dt;
}
else
{
ViewBag.dt = null;
}
return(View());
}
public ActionResult editSure(string CompanyID, string CompanyName, string CompanyPrincipal, string CompanyPhone, string CompanyEmail)
{
try
{
////加密
//ViewBag.userID = userID;
//解密
CompanyID = Base64MIMA.JIE(CompanyID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
string upsql = string.Format("UPDATE dbo.Company SET CompanyName='{0}',CompanyPrincipal='{1}',CompanyPhone='{2}',CompanyEmail='{3}' where CompanyID='{4}'", CompanyName, CompanyPrincipal, CompanyPhone, CompanyEmail, CompanyID);
string up = sql.EditDataCommand(upsql);
if (up == "0")
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
public ActionResult editSure(string name, string sex, string bir, string joindate, string posi, string tel, string email, int isout, string password, string depart, string EmpID, string Role, string CompanyID)
{
try
{
//解密
CompanyID = Base64MIMA.JIE(CompanyID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
string py = Pinyin.GetInitials(name);
string pinyin = Pinyin.GetPinyin(name).Replace(" ", "");
string editsql = string.Format("update dbo.Employee set Name='{0}',Sex={1},Birth='{2}',JoinDate='{3}',EmpTel='{4}',EmpEmail='{5}',IsOut={6},EmpPassword='******',DepartID='{8}',PositionID='{9}',SpellJX='{11}',SpellQP='{12}',RoleID='{13}' where EmpID='{10}' and CompanyID='{14}'", name, sex, bir, joindate, tel, email, isout, password, depart, posi, EmpID, py, pinyin, Role, CompanyID);
string edit = sql.EditDataCommand(editsql);
if (edit == "0")
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
// GET: BonusParameter
public ActionResult Index(string CompanyId)
{
try
{
//解密
CompanyId = Base64MIMA.JIE(CompanyId);
//加密
ViewBag.CompanyId = Base64MIMA.JIA(CompanyId);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
try
{
string parSql = string.Format("SELECT * FROM dbo.BonusParameter WHERE CompanyId='{0}' ORDER BY BonusNum", CompanyId);
DataTable ds = sql.GetDataTableCommand(parSql);
if (ds.Rows.Count > 0)
{
ViewBag.Par = ds;
}
else
{
ViewBag.Par = null;
}
}
catch (Exception)
{
return(Content("no"));
}
return(View());
}
//我的部门奖金页面
public ActionResult MyDepartBonus(string DepartID, string compId)
{
try
{
compId = Base64MIMA.JIE(compId);
string sqlDepart = string.Format(@"
SELECT BonusDataID,BIName,EarMoney,Name,EarDate
FROM dbo.BonusData2 b INNER JOIN dbo.Depart d
ON b.EarMan=d.DepartID INNER JOIN dbo.BonusItem b2
ON b.BonusItemID=b2.BonusItemID INNER JOIN dbo.Employee e
ON b.DisMan=e.EmpID
WHERE BonusType=0 AND EarMan='{0}' and b.CompanyId='{1}'
and d.CompanyID='{1}' and b2.CompanyID='{1}'
and e.CompanyID='{1}'
ORDER BY EarDate DESC
", DepartID, compId);
DataTable DepartName = sql.GetDataTableCommand(sqlDepart);
if (DepartName.Rows.Count > 0)
{
ViewBag.Detail = DepartName;
}
else
{
ViewBag.Detail = null;
}
}
catch (Exception ex)
{
return(Redirect("/ErrorPage/Index"));
}
return(View());
}
//编辑
public ActionResult editSure(string BonusItemID, string BIName, string BIPrincipal, string BIState, string BIType, int BIDepID, int InDate, string CompanyID)
{
try
{
//解密
CompanyID = Base64MIMA.JIE(CompanyID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
if (InDate > 12)
{
return(Content("big"));
}
string editsql = string.Format("update dbo.BonusItem set BonusItemID='{0}',BIName='{1}',BIPrincipal='{2}',BIState='{3}',BIType='{4}',BIDepID={6},InDate={7} where BonusItemID='{5}' and CompanyID='{8}'", BonusItemID, BIName, BIPrincipal, BIState, BIType, BonusItemID, BIDepID, InDate, CompanyID);
string edit = sql.EditDataCommand(editsql);
if (edit == "0")
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
//更换头像
public ActionResult UpdateImg(string img, string userID)
{
try
{
userID = Base64MIMA.JIE(userID);
log.AppenLog("选中的图片" + img);
string[] a = img.Split('.');
//BMP（位图）、JPG、JPEG、PNG、GIF
if (a[1] == "jpg" || a[1] == "gif" || a[1] == "png" || a[1] == "JPEG" || a[1] == "BMP")
{
string photosql = string.Format("update dbo.Employee set EmpPhotos='{0}' where EmpID='{1}'", img, userID);
log.AppenLog("photosql:" + photosql);
string photo = sql.EditDataCommand(photosql);
if (photo == "0")
{
return(Content("ok"));
}
else
{
return(Content("更换头像失败，请稍后重试"));
}
}
else
{
return(Content("图片格式不正确"));
}
}
catch (Exception ex)
{
return(Content("更换图片时错误:" + ex.Message));
throw;
}
}
public ActionResult Detail(string CompanyID)
{
try
{
//解密
CompanyID = Base64MIMA.JIE(CompanyID);
//加密
ViewBag.companyid = Base64MIMA.JIA(CompanyID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
string detialsql = string.Format("SELECT dbo.BonusItem.BonusItemID BonusItemID,dbo.BonusItemRule.BonusItemID BonusItemIDs,BIName,BIType,InDate,dbo.BonusItemRule.CompanyID FROM dbo.BonusItem Left JOIN dbo.BonusItemRule ON BonusItem.BonusItemID=dbo.BonusItemRule.BonusItemID WHERE BonusItem.CompanyID='{0}'", CompanyID);
DataTable ds = sql.GetDataTableCommand(detialsql);
if (ds.Rows.Count > 0)
{
ViewBag.ds = ds;
}
else
{
ViewBag.ds = null;
}
return(View());
}
//添加页面
public ActionResult addPosition(string CompanyId)
{
try
{
//解密
CompanyId = Base64MIMA.JIE(CompanyId);
//加密
ViewBag.CompanyId = Base64MIMA.JIA(CompanyId);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
try
{
string namesqls = string.Format("select DepartID,DepartName from Depart where CompanyId='{0}'", CompanyId);
DataTable dt = sql.GetDataTableCommand(namesqls);
if (dt.Rows.Count > 0)
{
ViewBag.depName = dt;
}
else
{
ViewBag.depName = null;
}
}
catch (Exception)
{
throw;
}
return(View());
}
public ActionResult SearchEmp(string Name, string CompanyID)
{
try
{
//加密
ViewBag.CompanyId = CompanyID;
//解密
CompanyID = Base64MIMA.JIE(CompanyID);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
string sqlEmp = "";
//sqlEmp = string.Format("select * from dbo.BonusItem where BIName like '%{0}%' and CompanyID='{1}'",Name, CompanyID);
sqlEmp = string.Format("SELECT dbo.BonusItem.BonusItemID BonusItemID, dbo.BonusItemRule.BonusItemID BonusItemIDs, BIName, BIType, InDate, dbo.BonusItemRule.CompanyID FROM dbo.BonusItem Left JOIN dbo.BonusItemRule ON BonusItem.BonusItemID = dbo.BonusItemRule.BonusItemID WHERE BIName like '%{0}%' AND BonusItem.CompanyID = '{1}' and BIState = 0", Name, CompanyID);
DataTable DepartName = sql.GetDataTableCommand(sqlEmp);
if (DepartName.Rows.Count > 0)
{
ViewBag.ds = DepartName;
}
else
{
ViewBag.ds = null;
}
return(PartialView("_BonusItemSearch"));
}
/// <summary>
/// 自动补全
/// </summary>
/// <returns></returns>
public ActionResult GetPersons(string EmpId, string CompanyId)
{
//WriteLog("GetPersons");
//string selectname = Session["userName"].ToString();
//WriteLog("selectname:" + selectname);
string q = Request.QueryString["term"];
EmpId = Base64MIMA.JIE(EmpId);
////得到这个人所属的公司
//string sqlstr2 = string.Format("select CompanyID from Employee where EmpID='{0}'", EmpId);
//DataTable dt2 = sql.GetDataTableCommand(sqlstr2);
//int CompanyID = 0;
//if (dt2?.Rows.Count > 0)
//{
// CompanyID = int.Parse(dt2.Rows[0]["CompanyID"].ToString());
//}
CompanyId = Base64MIMA.JIE(CompanyId);
//string sqlstr = string.Format("select Name label,EmpID value from Employee where SpellJX like '%{0}%' and IsOut=0 and EmpID!='{1}' and CompanyID='{2}'", q, EmpId, CompanyId);
string sqlstr = string.Format($"exec proc_BonusOutput 'zidong','{EmpId}','{CompanyId}','','{q}'");
DataTable dt = sql.GetDataTableCommand(sqlstr);
//WriteLog("sqlstr:" + sqlstr);
//WriteLog("序列化：" + JsonConvert.SerializeObject(dt));
return(Content(JsonConvert.SerializeObject(dt)));
}
// GET: DepartBouns
public ActionResult Index(string CompanyId)
{
try
{ //加密
ViewBag.CompanyId = CompanyId;
//解密
CompanyId = Base64MIMA.JIE(CompanyId);
}
catch (Exception)
{
//跳转错误页面
return(Redirect("/ErrorPage/Index"));
}
string sqlDepart = string.Format("select DepartName,DepartID from Depart where CompanyId='{0}'", CompanyId);
DataTable DepartName = sql.GetDataTableCommand(sqlDepart);
if (DepartName.Rows.Count > 0)
{
ViewBag.dname = DepartName;
}
else
{
ViewBag.dname = null;
}
return(View());
}
