public string Data_Submit_YiChang(string data)
{
token = appClass.CRM_Gettoken();
Sonluk.UI.Model.CRM.KQ_YCKQSMService.CRM_KQ_YCKQSMList[] checkdata = Newtonsoft.Json.JsonConvert.DeserializeObject <Sonluk.UI.Model.CRM.KQ_YCKQSMService.CRM_KQ_YCKQSMList[]>(data);
CRM_OA_BASIC basic = new CRM_OA_BASIC();
CRM_HG_STAFF staffmodel = crmModels.HG_STAFF.ReadBySTAFFID(Convert.ToInt32(Session["STAFFID"]), token);
basic.LoginName = staffmodel.STAFFNO;
basic.Subject = "异常考勤说明(" + staffmodel.STAFFNAME;
basic.TemplateCode = crmModels.SYS_CS.Read(12, token)[0].CS.ToString();
CRM_OA_YCKQSM list = new CRM_OA_YCKQSM();
list.STAFFNAME = staffmodel.STAFFNAME;
list.SMTABLEList = new SMTABLE[checkdata.Length];
for (int i = 0; i < checkdata.Length; i++)
{
list.SMTABLEList[i] = new SMTABLE();
list.SMTABLEList[i].SMRQ = checkdata[i].SMRQ;
list.SMTABLEList[i].SMSXB = (checkdata[i].SMSXB == 1) ? "上班" : "下班";
list.SMTABLEList[i].SMSX = checkdata[i].SMSX;
}
if (checkdata[0].KQQDID != 0)
{
list.QDSJ = checkdata[0].QDSJ;
list.QDWZ = checkdata[0].QDWZ;
list.KQJL = checkdata[0].KQJL + "米";
}
else
{
list.QDSJ = "没有考勤";
list.QDWZ = "";
list.KQJL = "";
}
MessageInfo info = crmModels.CRM_OA.Launch(basic, list, token); //提交
if (info.Key != "0" && info.Key != "-1")
{
for (int i = 0; i < checkdata.Length; i++)
{
checkdata[i].ISACTIVE = 2;
crmModels.KQ_YCKQSM.Update(checkdata[i], token);
CRM_OA_TRANSMIT model = new CRM_OA_TRANSMIT();
model.OAID = info.Key;
model.OACSBH = checkdata[i].YCKQID;
model.OACSLB = 104;
model.OAZT = 1;
model.CJSJ = DateTime.Now.ToString("yyyy-MM-dd");
crmModels.OA_TRANSMIT.Create(model, token);
}
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(info));
}
public string confirm(string lb_wlh, string in_Vornr, string in_Arbpl, string in_hgsl, string in_Zmeins, string in_sjgs, string in_ygh, string AUERU, string Grund, string Ltxa1, string KTSCH)
{
string token = AppClass.GetSession("token").ToString();
Ps_work ps_work = new Ps_work();
ps_work.Aufnr = lb_wlh;
ps_work.Vornr = in_Vornr;
ps_work.Arbpl = in_Arbpl;
ps_work.OpRz1 = in_hgsl;
ps_work.Opre1 = in_Zmeins;
ps_work.Grund = Grund;
ps_work.Ismnw = in_sjgs;
//ps_work.Pernr = in_ygh;
ps_work.Aueru = AUERU;
ps_work.Leknw = AUERU;
ps_work.Iedd = DateTime.Now.ToString("yyyyMMdd");
ps_work.Ltxa1 = Ltxa1;
ps_work.KTSCH = KTSCH;
Ps_staff ps_staff = new Ps_staff();
ps_staff.Inits = in_ygh;
CRM_HG_STAFF staff = cmrmodele.HG_STAFF.ReadBySTAFFID(Convert.ToInt32(Session["STAFFID"]), AppClass.GetSession("token").ToString());
ps_staff.Rufnm = staff.STAFFNO;
string rst = psModels.NetWork.confirm(ps_work, ps_staff, token);
return(rst);
}
public ActionResult WLIndex()
{
Session["state"] = "WX";
string name = "wl";
string password = "******";
CRM_LoginInfo tokeninfo = crmModels.CRM_Login.Login(name, password, "", "", 0, 1);
Session["MENUINFO"] = tokeninfo.JURISDICTION_GROUP;
CRM_HG_STAFF staffdata = crmModels.HG_STAFF.ReadBySTAFFID(tokeninfo.TokenInfo.STAFFID, tokeninfo.TokenInfo.access_token);
if (tokeninfo.TokenInfo.access_token == null)
{
if (tokeninfo.TokenInfo.MSG == "E")
{
Session["ErrorMessage"] = tokeninfo.TokenInfo.MESSAGE;
}
else
{
Session["ErrorMessage"] = "用户名或密码错误";
}
}
else
{
Session["ErrorMessage"] = null;
Session["token"] = tokeninfo.TokenInfo.access_token;
Session["STAFFID"] = tokeninfo.TokenInfo.STAFFID;
Session["NAME"] = staffdata.STAFFNAME;
Session["USERLX"] = staffdata.USERLX;
Response.Cookies["userName"].Value = name + "_" + password;
Response.Cookies["userName"].Expires = DateTime.Now.AddDays(10);
}
return(View());
}
public int Data_Update_Password(string oldp, string newp)
{
token = appClass.CRM_Gettoken();
string pattern = @"(?=.*[a-zA-Z])(?=.*[0-9])";
bool result = Regex.IsMatch(newp, pattern);
if (result == false)
{
return(-2); //复杂度不够
}
if (newp.Length < 8)
{
return(-3); //长度少于8
}
CRM_HG_STAFF staffmodel = crmModels.HG_STAFF.ReadBySTAFFID(Convert.ToInt32(Session["STAFFID"]), token);
string oldpass = FormsAuthentication.HashPasswordForStoringInConfigFile(oldp, "MD5").ToLower();
if (oldpass != staffmodel.STAFFPW)
{
return(-1); //原密码不对
}
staffmodel.STAFFPW = FormsAuthentication.HashPasswordForStoringInConfigFile(newp, "MD5").ToLower();
int i = crmModels.HG_STAFF.Update(staffmodel, token);
return(i);
}
public string Data_Report_NoticeBySTAFFID()
{
token = appClass.CRM_Gettoken();
CRM_HG_STAFF staff = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token);
CRM_MSG_NOTICETTList[] data = crmModels.MSG_NOTICE.ReadBySTAFFID(appClass.CRM_GetStaffid(), staff.USERLX, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public string Data_Select_ByParam(string cxdata)
{
token = appclass.CRM_Gettoken();
CRM_HG_STAFF model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_HG_STAFF>(cxdata);
CRM_HG_STAFFList[] data = crmModels.HG_STAFF.ReadByParam(model, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public ActionResult NoticePart()
{
token = appClass.CRM_Gettoken();
CRM_HG_STAFF staff = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token);
CRM_MSG_NOTICETTList[] data = crmModels.MSG_NOTICE.ReadBySTAFFID(appClass.CRM_GetStaffid(), staff.USERLX, token);
ViewBag.data = data;
return(View());
}
public string Data_Report_InvoiceByKHID()
{
token = appClass.CRM_Gettoken();
CRM_HG_STAFF staff = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token);
CRM_KH_KH kehu = crmModels.KH_KH.ReadBySAPSN(staff.STAFFNO, token);
CRM_MSG_INVOICEList[] data = crmModels.MSG_INVOICE.ReadByKHID(kehu.KHID, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public int Data_Update_KHAcount_Role(int KHID, string STAFFUSER, string STAFFPW, string roledata) //给客户修改加用户名和密码并管理角色
{
token = appClass.CRM_Gettoken();
//CRM_Report_STAFFModel model = new CRM_Report_STAFFModel();
//model.STAFFNO = STAFFNO;
//model.ISACTIVE = 1;
//int staffid = crmModels.HG_STAFF.Report(model, token)[0].STAFFID; //根据工号找到staffid
CRM_KH_KHList khdata = crmModels.KH_KH.Read(KHID, token);
CRM_HG_STAFF data = new CRM_HG_STAFF();
data.STAFFNO = khdata.SAPSN;
data.STAFFNAME = khdata.MC;
data.STAFFUSER = STAFFUSER;
if (STAFFPW != "") //如果密码有所改动
{
string pattern = @"(?=.*[a-zA-Z])(?=.*[0-9])";
bool result = Regex.IsMatch(STAFFPW, pattern);
if (result == false)
{
return(-2); //复杂度不够
}
if (STAFFPW.Length < 8)
{
return(-3); //长度少于8
}
data.STAFFPW = FormsAuthentication.HashPasswordForStoringInConfigFile(STAFFPW, "MD5").ToLower();
}
data.SISLOCK = false;
data.USERLX = 1107;
data.ISACTIVE = 1;
int staffid = crmModels.HG_STAFF.Create(data, token); //帐号密码加进去，更新人员信息
if (staffid == -1)
{
return(-4);
}
CRM_HG_ROLE[] rolemodel = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_HG_ROLE[]>(roledata);
crmModels.HG_ROLE.Delete_STAFFROLEByStaffid(staffid, token);
for (int x = 0; x < rolemodel.Length; x++)
{
int _i = crmModels.HG_ROLE.Create_STAFFROLE(staffid, rolemodel[x].ROLEID, token);
if (_i <= 0)
{
return(-10);
}
}
return(staffid);
}
public ActionResult InvoicePart()
{
token = appClass.CRM_Gettoken();
CRM_HG_STAFF staff = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token);
CRM_KH_KH kehu = crmModels.KH_KH.ReadBySAPSN(staff.STAFFNO, token);
CRM_MSG_INVOICEList[] data = crmModels.MSG_INVOICE.ReadByKHID(kehu.KHID, token);
ViewBag.data = data;
return(View());
}
public int Data_Update_Password(string oldp, string newp)
{
token = appClass.CRM_Gettoken();
string pattern = @"(?=.*[a-zA-Z])(?=.*[0-9])";
bool result = Regex.IsMatch(newp, pattern);
if (result == false)
{
return(-2); //复杂度不够
}
if (newp.Length < 8)
{
return(-3); //长度少于8
}
CRM_HG_STAFF staffmodel = crmModels.HG_STAFF.ReadBySTAFFID(Convert.ToInt32(Session["STAFFID"]), token);
string oldpass = FormsAuthentication.HashPasswordForStoringInConfigFile(oldp, "MD5").ToLower();
if (oldpass != staffmodel.STAFFPW.ToLower())
{
return(-1); //原密码不对
}
staffmodel.STAFFPW = FormsAuthentication.HashPasswordForStoringInConfigFile(newp, "MD5").ToLower();
int i = crmModels.HG_STAFF.Update(staffmodel, token);
if (i > 0)
{
//TokenInfo tokeninfo = crmModels.CRM_Login.Login_SSO(staffmodel.STAFFUSER, newp, "", "");
//MES_RETURN_UI rst_MES_RETURN_UI = new MES_RETURN_UI();
//if (tokeninfo.access_token == null)
//{
// rst_MES_RETURN_UI.TYPE = "E";
// rst_MES_RETURN_UI.MESSAGE = tokeninfo.MESSAGE;
//}
//else
//{
// rst_MES_RETURN_UI.TYPE = "S";
// rst_MES_RETURN_UI.MESSAGE = tokeninfo.TOKENID;
// Session["token"] = tokeninfo.access_token;
// Session["STAFFID"] = tokeninfo.STAFFID;
// Session["NAME"] = crmModels.HG_STAFF.ReadBySTAFFID(tokeninfo.STAFFID, tokeninfo.access_token).STAFFNAME;
// Response.Cookies["TOKENID"].Value = tokeninfo.TOKENID;
//}
}
return(i);
}
public string Data_Update_Users(int STAFFID, string STAFFPW, bool islock, int STAFFKHLXID)
{
token = appClass.CRM_Gettoken();
WebMSG msg = new WebMSG();
CRM_HG_STAFF data = crmModels.HG_STAFF.ReadBySTAFFID(STAFFID, token); //根据staffid找到人员信息
if (STAFFPW != "") //如果密码有所改动
{
string pattern = @"(?=.*[a-zA-Z])(?=.*[0-9])";
bool result = Regex.IsMatch(STAFFPW, pattern);
if (result == false)
{
msg.KEY = -2;
msg.MSG = "密码复杂度不够";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); //复杂度不够
}
if (STAFFPW.Length < 8)
{
msg.KEY = -3;
msg.MSG = "密码长度不得少于8";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); //长度少于8
}
data.STAFFPW = FormsAuthentication.HashPasswordForStoringInConfigFile(STAFFPW, "MD5").ToLower();
}
data.SISLOCK = islock;
data.STAFFKHLXID = STAFFKHLXID;
if (!islock)
{
data.E_COUNT = 0;
}
int i = crmModels.HG_STAFF.Update(data, token); //帐号密码加进去，更新人员信息
if (i <= 0)
{
msg.KEY = 0;
msg.MSG = "修改失败！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
else
{
msg.KEY = 1;
msg.MSG = "修改成功！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
}
public int Data_Insert(string data) //新增人员信息
{
//JavaScriptSerializer js = new JavaScriptSerializer();
//crmModels = js.Deserialize<CRMModels>(data);
//crmModels = ParseFromJson<CRMModels>(data);
if (Session["token"] != null)
{
token = Session["token"].ToString();
}
CRM_HG_STAFF crmmodel = JsonConvert.DeserializeObject <CRM_HG_STAFF>(data);
crmmodel.USERLX = 1108;
int id = crmModels.HG_STAFF.Create(crmmodel, token);
return(id);
}
public int Data_Insert(string data) //新增人员信息
{
//JavaScriptSerializer js = new JavaScriptSerializer();
//crmModels = js.Deserialize<CRMModels>(data);
//crmModels = ParseFromJson<CRMModels>(data);
token = appclass.CRM_Gettoken();
CRM_HG_STAFF crmmodel = JsonConvert.DeserializeObject <CRM_HG_STAFF>(data);
crmmodel.STAFFPW = FormsAuthentication.HashPasswordForStoringInConfigFile(crmmodel.STAFFPW, "MD5").ToLower();
crmmodel.USERLX = 1108;
int id = crmModels.HG_STAFF.Create(crmmodel, token);
return(id);
}
public string Data_Insert_NoticeMX_AllJXS(int NOTICETTID)
{
token = appClass.CRM_Gettoken();
CRM_Report_KHModel cxmodel = new CRM_Report_KHModel();
cxmodel.KHLX = 1;
CRM_KH_KHList[] KHmodel = crmModels.KH_KH.ReadUser_KH(cxmodel, token);
for (int i = 0; i < KHmodel.Length; i++)
{
CRM_HG_STAFF staff = crmModels.HG_STAFF.ReadBySTAFFNO(KHmodel[i].SAPSN, token);
CRM_MSG_NOTICEMX model = new CRM_MSG_NOTICEMX();
model.NOTICETTID = NOTICETTID;
model.USERID = staff.STAFFID;
CRM_MSG_NOTICEMX[] cxdata = crmModels.MSG_NOTICE.ReadMXbyParam(model, token);
if (cxdata.Length > 0)
{
webmsg.KEY = 0;
webmsg.MSG = "数据重复！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg));
}
}
for (int i = 0; i < KHmodel.Length; i++)
{
CRM_HG_STAFF staff = crmModels.HG_STAFF.ReadBySTAFFNO(KHmodel[i].SAPSN, token);
CRM_MSG_NOTICEMX model = new CRM_MSG_NOTICEMX();
model.NOTICETTID = NOTICETTID;
model.USERID = staff.STAFFID;
model.USERLX = 1107;
model.ISACTIVE = 1;
int ii = crmModels.MSG_NOTICE.CreateMX(model, token);
if (ii <= 0)
{
webmsg.KEY = ii;
webmsg.MSG = "第" + (i + 1) + "行数据新建失败！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg));
}
}
webmsg.KEY = 1;
webmsg.MSG = "新建成功！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg));
}
public ActionResult Verify(string name, string password)
{
TokenInfo tokeninfo = models.CRM_Login.Login(name, password, "", "", 0, 0).TokenInfo;
Response.Cookies["userName"].Value = name;
Response.Cookies["userName"].Expires = DateTime.Now.AddDays(10);
if (tokeninfo.access_token == null)
{
AppClass.SetSession("ErrorMessage", "用户名或密码错误");
Response.Cookies["password"].Value = "";
Response.Cookies["password"].Expires = DateTime.Now.AddDays(10);
}
else
{
AppClass.SetSession("ErrorMessage", null);
AppClass.SetSession("token", tokeninfo.access_token);
AppClass.SetSession("STAFFID", tokeninfo.STAFFID);
CRM_HG_STAFF rst_CRM_HG_STAFF = models.HG_STAFF.ReadBySTAFFID(tokeninfo.STAFFID, tokeninfo.access_token);
Session["ID"] = rst_CRM_HG_STAFF.STAFFUSER;
Session["NAME"] = rst_CRM_HG_STAFF.STAFFNAME;
Response.Cookies["password"].Value = password;
Response.Cookies["password"].Expires = DateTime.Now.AddDays(10);
TokenINFO model_TokenINFO = new TokenINFO();
model_TokenINFO.STAFFID = tokeninfo.STAFFID;
model_TokenINFO.Token = tokeninfo.access_token;
model_TokenINFO.STAFFNAME = rst_CRM_HG_STAFF.STAFFNAME;
Response.Cookies["tokeninfo"].Value = HttpUtility.UrlEncode(Newtonsoft.Json.JsonConvert.SerializeObject(model_TokenINFO));
Response.Cookies["tokeninfo"].Expires = DateTime.Now.AddDays(2);
}
ActionResult target;
if (tokeninfo.access_token == null)
{
target = RedirectToAction("SignIn", "Access");
}
else
{
target = RedirectToAction("Main", "Access");
}
return(target);
}
public void getlogininfo(CRM_LoginInfo tokeninfo)
{
//Session["MENUINFO"] = tokeninfo.JURISDICTION_GROUP;
//Session["token"] = tokeninfo.TokenInfo.access_token;
//Session["STAFFID"] = tokeninfo.TokenInfo.STAFFID;
//Session["NAME"] = crmModels.HG_STAFF.ReadBySTAFFID(tokeninfo.TokenInfo.STAFFID, tokeninfo.TokenInfo.access_token).STAFFNAME;
//Response.Cookies["token"].Value = tokeninfo.TokenInfo.access_token;
//Response.Cookies["token"].Expires = DateTime.Now.AddDays(10);
AppClass.SetSession("ErrorMessage", null);
AppClass.SetSession("token", tokeninfo.TokenInfo.access_token);
AppClass.SetSession("STAFFID", tokeninfo.TokenInfo.STAFFID);
CRM_HG_STAFF rst_CRM_HG_STAFF = models.HG_STAFF.ReadBySTAFFID(tokeninfo.TokenInfo.STAFFID, tokeninfo.TokenInfo.access_token);
Session["ID"] = rst_CRM_HG_STAFF.STAFFUSER;
Session["NAME"] = rst_CRM_HG_STAFF.STAFFNAME;
TokenINFO model_TokenINFO = new TokenINFO();
model_TokenINFO.STAFFID = tokeninfo.TokenInfo.STAFFID;
model_TokenINFO.Token = tokeninfo.TokenInfo.access_token;
model_TokenINFO.STAFFNAME = rst_CRM_HG_STAFF.STAFFNAME;
Response.Cookies["tokeninfo"].Value = HttpUtility.UrlEncode(Newtonsoft.Json.JsonConvert.SerializeObject(model_TokenINFO));
Response.Cookies["tokeninfo"].Expires = DateTime.Now.AddDays(2);
MES_SY_TYPEMX model_MES_SY_TYPEMX = new MES_SY_TYPEMX();
model_MES_SY_TYPEMX.ID = tokeninfo.TokenInfo.LANGUAGEID;
MES_SY_TYPEMXLIST[] rst_MES_SY_TYPEMXLIST = mesModels.SY_TYPEMX.SELECT(model_MES_SY_TYPEMX, tokeninfo.TokenInfo.access_token);
if (rst_MES_SY_TYPEMXLIST.Length > 0)
{
Response.Cookies["Sonluk.Local.Culture"].Value = rst_MES_SY_TYPEMXLIST[0].MXNAME;
Response.Cookies["Sonluk.Local.Culture"].Expires = DateTime.Now.AddDays(10);
}
else
{
Response.Cookies["Sonluk.Local.Culture"].Value = "zh-CN";
Response.Cookies["Sonluk.Local.Culture"].Expires = DateTime.Now.AddDays(10);
}
}
public ActionResult Insert_Order()
{
token = appClass.CRM_Gettoken();
CRM_HG_STAFF STAFF = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token); //STAFF为当前用户的数据
ViewBag.STAFF = STAFF;
string SAPSN = STAFF.STAFFNO;
CRM_KH_KH[] SDF = crmModels.KH_KH.ReadSDFbyPKH(SAPSN, token);
ViewBag.SDF = SDF;
CRM_KH_KH KH = crmModels.KH_KH.ReadBySAPSN(SAPSN, token); //kh为当前客户的数据
ViewBag.KH = KH;
DateTime now = DateTime.Now;
ViewBag.startdate = now.AddMonths(-1).ToString("yyyy-MM-dd");
ViewBag.enddate = now.ToString("yyyy-MM-dd");
return(View());
}
//<summary>
//批量修改人员主数据
//</summary>
//<returns></returns>
public string Data_DaoRu_Staff_Update()
{
token = appclass.CRM_Gettoken();
var file = Request.Files[0];
//string date = DateTime.Now.ToString("yyyyMMddHHmmss");
//string fileName = date + "_" + KHID;
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string gotname = file.FileName;
//string[] name = gotname.Split('.');
//int count = name.Length - 1;
//string savePath = @"E:\CRM\Areas\CRM\upload\" + year + @"\" + month + @"\" + fileName + "." + name[count];
string savePath = FileSavePath + @"\excel\" + year + @"\" + month + @"\" + gotname;
file.SaveAs(savePath);
FileInfo fi = new FileInfo(savePath);
if (fi.Exists == true)
{
string[] sheet = { "人员" };
DaoRuMsg msg = new DaoRuMsg();
//开始做数据校验
DataTable data1 = ExcelToDataTable(savePath, sheet[0], true); //人员
#region
if (data1 != null)
{
if (data1.Columns.Contains("人员类型") == false || data1.Columns.Contains("姓名") == false || data1.Columns.Contains("人员编号") == false)
{
msg.Msg = "请使用人员修改模版！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
else
{
//做数据验证
if (data1.Rows.Count > 0)
{
for (int i = 0; i < data1.Rows.Count; i++)
{
if (data1.Rows[i]["人员编号"].ToString() == "")
{
msg.Msg = "人员第" + i + 2 + "行人员编号不能为空！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
int STAFFID = crmModels.HG_STAFF.ReadBySTAFFID(Convert.ToInt32(data1.Rows[i]["人员编号"]), token).STAFFID;
if (STAFFID == 0)
{
msg.Msg = "人员第" + i + 2 + "行人员编号不存在！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
if (data1.Rows[i]["人员类型"].ToString() == "")
{
msg.Msg = "人员第" + i + 2 + "行人员类型不能为空！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
int STAFFLX = crmModels.HG_DICT.ReadByDICNAME(data1.Rows[i]["人员类型"].ToString(), 33, token);
if (STAFFLX == 0)
//if (data1.Rows[i]["人员类型"].ToString() != "业务员" && data1.Rows[i]["人员类型"].ToString() != "办公室人员" && data1.Rows[i]["人员类型"].ToString() != "直营卖场促销员" && data1.Rows[i]["人员类型"].ToString() != "客户业务员" && data1.Rows[i]["人员类型"].ToString() != "管理人员")
{
msg.Msg = "人员第" + i + 2 + "行人员类型错误！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
if (data1.Rows[i]["性别"].ToString() != "男" && data1.Rows[i]["性别"].ToString() != "女")
{
msg.Msg = "人员第" + i + 2 + "行性别错误！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
if (data1.Rows[i]["婚姻状况"].ToString() != "未婚" && data1.Rows[i]["婚姻状况"].ToString() != "已婚")
{
msg.Msg = "人员第" + i + 2 + "行婚姻状况错误！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
int DEPID = crmModels.HG_DEPT.ReadByName(data1.Rows[i]["部门"].ToString(), token).DEPID;
if (DEPID == 0)
{
msg.Msg = "人员第" + i + 2 + "行部门不存在！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
int BZID = crmModels.HG_BZGZSJ.ReadByBZNAME(data1.Rows[i]["班次"].ToString(), token).BZID;
if (BZID == 0)
{
msg.Msg = "人员第" + i + 2 + "行班次不存在！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
int BBID = crmModels.KQ_GZRL.Read(data1.Rows[i]["日历版本"].ToString(), 0, token)[0].BBID;
if (BBID == 0)
{
msg.Msg = "人员第" + i + 2 + "行日历版本不存在！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
int STAFFZZMM = crmModels.HG_DICT.ReadByDICNAME(data1.Rows[i]["政治面貌"].ToString(), 15, token);
if (STAFFZZMM == 0)
{
msg.Msg = "人员第" + i + 2 + "行政治面貌不存在！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
int STAFFXL = crmModels.HG_DICT.ReadByDICNAME(data1.Rows[i]["学历"].ToString(), 16, token);
if (STAFFXL == 0)
{
msg.Msg = "人员第" + i + 2 + "行学历不存在！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
//int STAFFZWJB = crmModels.HG_DICT.ReadByDICNAME(data1.Rows[i]["职务"].ToString(), 13, token);
//if (STAFFZWJB == 0)
//{
// msg.Msg = "人员第" + i + 2 + "行职务不存在！";
// return Newtonsoft.Json.JsonConvert.SerializeObject(msg);
//}
int STAFFGW = crmModels.HG_DICT.ReadByDICNAME(data1.Rows[i]["岗位"].ToString(), 14, token);
if (STAFFGW == 0)
{
msg.Msg = "人员第" + i + 2 + "行岗位不存在！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
}
}
}
}
#endregion
//能到这儿就说明数据是没问题的了...大概，然后才进行数据库写入
#region
for (int i = 0; i < data1.Rows.Count; i++)
{
CRM_HG_STAFF model = new CRM_HG_STAFF();
model = crmModels.HG_STAFF.ReadBySTAFFID(Convert.ToInt32(data1.Rows[i]["人员编号"]), token);
model.STAFFLX = crmModels.HG_DICT.ReadByDICNAME(data1.Rows[i]["人员类型"].ToString(), 33, token);
//switch (data1.Rows[i]["人员类型"].ToString())
//{
// case "驻外业务员":
// model.STAFFLX = 1;
// break;
// case "办公室人员":
// model.STAFFLX = 2;
// break;
// case "直营卖场促销员":
// model.STAFFLX = 3;
// break;
// case "客户业务员":
// model.STAFFLX = 4;
// break;
//}
model.STAFFNAME = data1.Rows[i]["姓名"].ToString();
model.STAFFNO = data1.Rows[i]["工号"].ToString();
model.DEPID = crmModels.HG_DEPT.ReadByName(data1.Rows[i]["部门"].ToString(), token).DEPID;
model.STAFFZZMM = crmModels.HG_DICT.ReadByDICNAME(data1.Rows[i]["政治面貌"].ToString(), 15, token);
switch (data1.Rows[i]["性别"].ToString())
{
case "男":
model.STAFFSEX = 1;
break;
case "女":
model.STAFFSEX = 2;
break;
}
model.STAFFXL = crmModels.HG_DICT.ReadByDICNAME(data1.Rows[i]["学历"].ToString(), 16, token);
switch (data1.Rows[i]["婚姻状况"].ToString())
{
case "未婚":
model.STAFFHYZK = 1;
break;
case "已婚":
model.STAFFHYZK = 2;
break;
}
model.STAFFEMAIL = data1.Rows[i]["邮箱地址"].ToString();
model.STAFFTEL = data1.Rows[i]["联系电话"].ToString();
model.STAFFJG = data1.Rows[i]["籍贯"].ToString();
model.STAFFSFZH = data1.Rows[i]["身份证号"].ToString();
model.STAFFSR = data1.Rows[i]["生日"].ToString();
model.STAFFRZSJ = data1.Rows[i]["入职时间"].ToString();
model.STAFFMPSJ = data1.Rows[i]["调入民品部时间"].ToString();
model.STAFFCZDZ = data1.Rows[i]["常住地址"].ToString();
model.STAFFBYYX = data1.Rows[i]["毕业院校"].ToString();
model.STAFFZWJB = crmModels.HG_DICT.ReadByDICNAME(data1.Rows[i]["职位"].ToString(), 13, token);
model.STAFFGW = crmModels.HG_DICT.ReadByDICNAME(data1.Rows[i]["岗位"].ToString(), 14, token);
model.BZID = crmModels.HG_BZGZSJ.ReadByBZNAME(data1.Rows[i]["班次"].ToString(), token).BZID;
model.BBID = crmModels.KQ_GZRL.Read(data1.Rows[i]["日历版本"].ToString(), 0, token)[0].BBID;
model.STAFFWORK = data1.Rows[i]["工作内容"].ToString();
model.STAFFMEMO = data1.Rows[i]["备注"].ToString();
//model.ISACTIVE = 1;
int id = crmModels.HG_STAFF.Update(model, token);
if (id <= 0)
{
msg.Msg = "人员的第" + i + 2 + "行出现问题，请记录当前报错信息并联系管理员";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
}
#endregion
msg.Msg = "修改成功！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
else
{
return("{}");
}
}
private void btnOK_Click(object sender, EventArgs e)
{
string token = Appclass.token;
string pattern = @"(?=.*[a-zA-Z])(?=.*[0-9])";
bool result = Regex.IsMatch(txtPasswordNew.Text, pattern);
if (txtPasswordNew.Text != txtPasswordNew1.Text)
{
MessageBox.Show("2遍新密码请保持一致！");
return;
}
if (result == false)
{
MessageBox.Show("复杂度不够！");
return; //复杂度不够
}
if (txtPasswordNew.Text.Length < 8)
{
MessageBox.Show("长度少于8！");
return; //长度少于8
}
CRM_HG_STAFF staffmodel = crmModels.HG_STAFF.ReadBySTAFFID(Appclass.STAFFID, token);
string oldpass = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPasswordOLD.Text, "MD5").ToLower();
if (oldpass != staffmodel.STAFFPW.ToLower())
{
MessageBox.Show("原密码不对！");
return; //原密码不对
}
staffmodel.STAFFPW = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPasswordNew.Text, "MD5").ToLower();
int i = crmModels.HG_STAFF.Update(staffmodel, token);
if (i > 0)
{
if (MessageBox.Show("修改成功,点击重新启动程序", "消息框", MessageBoxButtons.OK) == DialogResult.OK)
{
Application.Exit();
System.Diagnostics.Process.Start(System.Reflection.Assembly.GetExecutingAssembly().Location);
}
}
else
{
MessageBox.Show("修改失败！");
return;
}
//if (txtPasswordOLD.Text == "")
//{
// MessageBox.Show("原密码不能为空！");
// return;
//}
//if (txtPasswordNew.Text == "" || txtPasswordNew1.Text == "")
//{
// MessageBox.Show("新密码不能为空！");
// return;
//}
//if (txtPasswordNew.Text != txtPasswordNew1.Text)
//{
// MessageBox.Show("2遍新密码请保持一致！");
// return;
//}
//int loginRETURN = mainService.LOGIN(modleSTAFF.STAFFUSER, txtPasswordOLD.Text, "");
//if (loginRETURN == 1)
//{
// MessageBox.Show("原密码错误！");
// return;
//}
//mainService.Update_ChangePassWord(modleSTAFF.STAFFUSER, txtPasswordNew.Text);
//this.DialogResult = DialogResult.OK;
}
public ActionResult WX_SH_Order()
{
string Account = System.Configuration.ConfigurationManager.AppSettings["apiAccount"];
string Secret = System.Configuration.ConfigurationManager.AppSettings["apiSecret"];
CRM_LoginInfo login = crmModels.CRM_Login.Login(Account, Secret, "", "", 1, 0);
string token = login.TokenInfo.access_token;
Session["token"] = token;
Session["NAME"] = " ";
//CRM_HG_STAFF staffdata1 = crmmodel.HG_STAFF.ReadBySTAFFID(login.TokenInfo.STAFFID, login.TokenInfo.access_token);
int StaffID = 0;
string code = Request.QueryString["code"];
string state = Request.QueryString["state"];
//code = "Cto7s7NeQaw-fgHCGM-UYhK_C0WcyMauTPTEshPCIEM";
//state = "QY";
string openid = "";
string userid = "";
PublicController otherController = DependencyResolver.Current.GetService <PublicController>();
//string result = otherController.ToExcel(data, 4, token);
if (code != null) //有code
{
if (state == "WX") //微信公众号登录
{
Session["state"] = "WX";
string[] data = otherController.GetWebToken(code);
if (data[0] == "ok") //成功获取openid
{
openid = data[1];
Session["openid"] = openid;
CRM_WX_OPENID openidModel = new CRM_WX_OPENID();
openidModel.OPENID = openid;
CRM_WX_OPENID[] openidData = crmModels.WX_OPENID.ReadByParam(openidModel, token);
if (openidData.Length == 0)
{
ViewBag.MSG = "您没有权限";
return(View("Error"));
}
StaffID = openidData[0].STAFFID;
CRM_HG_STAFF staffdata = crmModels.HG_STAFF.ReadBySTAFFID(StaffID, token);
string appid = System.Configuration.ConfigurationManager.AppSettings["AppID"];
CRM_LoginInfo tokeninfo = crmModels.CRM_Login.Login("", "", openid, appid, 0, 1);
if (tokeninfo.TokenInfo.access_token == null)
{
ViewBag.MSG = "获取token失败";
return(View("Error"));
}
else
{
Session["MENUINFO"] = tokeninfo.JURISDICTION_GROUP;
Session["STAFFID"] = StaffID;
Session["NAME"] = staffdata.STAFFNAME;
Session["USERLX"] = staffdata.USERLX;
}
}
else //获取openid失败
{
ViewBag.MSG = data[1];
return(View("Error"));
}
}
else if (state == "QY") //企业微信登录
{
Session["state"] = "QY";
string[] data = otherController.GetQYwebToken(code);
if (data[0] == "ok") //成功获取userid或openid
{
userid = data[1];
Session["openid"] = userid;
CRM_WX_OPENID openidModel = new CRM_WX_OPENID();
openidModel.OPENID = userid;
CRM_WX_OPENID[] openidData = crmModels.WX_OPENID.ReadByParam(openidModel, token);
if (openidData.Length == 0)
{
ViewBag.MSG = "您没有权限";
return(View("Error"));
}
StaffID = openidData[0].STAFFID;
CRM_HG_STAFF staffdata = crmModels.HG_STAFF.ReadBySTAFFID(StaffID, token);
string corpid = System.Configuration.ConfigurationManager.AppSettings["CorpID"];
CRM_LoginInfo tokeninfo = crmModels.CRM_Login.Login("", "", userid, corpid, 0, 1);
if (tokeninfo.TokenInfo.access_token == null)
{
ViewBag.MSG = "获取token失败";
return(View("Error"));
}
else
{
Session["MENUINFO"] = tokeninfo.JURISDICTION_GROUP;
Session["STAFFID"] = StaffID;
Session["NAME"] = staffdata.STAFFNAME;
Session["USERLX"] = staffdata.USERLX;
}
}
else //获取userid或openid失败
{
ViewBag.MSG = data[1];
return(View("Error"));
}
}
else //不太可能发生的情况
{
ViewBag.MSG = "登录失败";
return(View("Error"));
}
}
else //没有code
{
ViewBag.MSG = "请退出并重新登录";
return(View("Error"));
}
//StaffID = 35;
CRM_ORDER_TT model = new CRM_ORDER_TT();
model.ISACTIVE = 20;
CRM_ORDER_TT[] OrderData = crmModels.ORDER_TT.ReadTTbyParam(model, StaffID, 0, 0, token);
ViewBag.TTdata = OrderData;
return(View());
}
public string Data_Modify_CCTT(int CCID, string beiz)
{
token = appClass.CRM_Gettoken();
CRM_KQ_CCTT model = crmModels.KQ_CC.Read_TTbyCCID(CCID, token);
model.BEIZ = beiz;
int int1 = crmModels.KQ_CC.Update_TT(model, token);
if (int1 <= 0)
{
MessageInfo msg = new MessageInfo();
msg.Key = "0";
msg.Value = "保存失败！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
////先校验这个ccid对应的天数是否等于明细的条数
//CRM_KQ_CCMX[] mxmodel = crmModels.KQ_CC.Read_MXbyCCID(model.CCID, token);
//if (model.SJCCTS * 2 > mxmodel.Length)
//{
// MessageInfo msg = new MessageInfo();
// msg.Key = "0";
// msg.Value = "请确认明细数量与出差天数是否对应！";
// return Newtonsoft.Json.JsonConvert.SerializeObject(msg);
//}
////然后先保存
//int id = crmModels.KQ_CC.Update_TT(model, token);
//if (id <= 0)
//{
// MessageInfo msg = new MessageInfo();
// msg.Key = "0";
// msg.Value = "保存失败，未发起OA流程";
// return Newtonsoft.Json.JsonConvert.SerializeObject(msg);
//}
//开始做OA
CRM_HG_STAFF staffmodel = crmModels.HG_STAFF.ReadBySTAFFID(Convert.ToInt32(Session["STAFFID"]), token);
CRM_OA_BASIC basic = new CRM_OA_BASIC();
basic.Subject = "出差撤销单(" + staffmodel.STAFFNAME + " ";
basic.LoginName = crmModels.HG_STAFF.ReadBySTAFFID(staffmodel.STAFFID, token).STAFFNO;
basic.TemplateCode = crmModels.SYS_CS.Read(5, token)[0].CS.ToString();
CRM_OA_CC list = new CRM_OA_CC();
list.CCSQSJ = model.CCSQSJ;
list.STAFFNAME = model.CCRNAME;
list.CCLXDES = crmModels.HG_DICT.ReadByDICID(Convert.ToInt32(model.CCLX), token).DICNAME;
list.CCDD = model.CCDD;
list.BQYCCDES = model.BQYCC == true ? "是" : "否";
list.ZCYWCCDES = model.ZCYWCC == true ? "是" : "否";
list.JHCCKSSJ = model.JHCCKSSJ;
list.JHCCJSSJ = model.JHCCJSSJ;
list.CXFS = crmModels.HG_DICT.ReadByDICID(Convert.ToInt32(model.CXFS), token).DICNAME;
list.YJJE = model.YJJE.ToString();
list.QTCXFSDES = crmModels.HG_DICT.ReadByDICID(Convert.ToInt32(model.QTCXFS), token).DICNAME;
list.QTCXFSJE = model.QTCXFSJE.ToString();
list.BEIZ = model.BEIZ;
if (list.QTCXFSJE == "0" || list.QTCXFSJE == "0.00")
{
list.QTCXFSJE = "";
}
list.TITLE = "出差撤销单";
CRM_KQ_CCMX[] mxmodel = crmModels.KQ_CC.Read_MXbyCCID(model.CCID, token);
list.CRM_OA_CC_SUBList = new CRM_OA_CC_SUB[mxmodel.Length];
for (int i = 0; i < mxmodel.Length; i++)
{
list.CRM_OA_CC_SUBList[i] = new CRM_OA_CC_SUB();
list.CRM_OA_CC_SUBList[i].DATE = mxmodel[i].DATE;
string sjlx = ""; //上午或下午
if (mxmodel[i].CCSJLX == 1)
{
sjlx = "上午";
}
else if (mxmodel[i].CCSJLX == 2)
{
sjlx = "下午";
}
list.CRM_OA_CC_SUBList[i].CCSJLXDES = sjlx;
list.CRM_OA_CC_SUBList[i].DD = mxmodel[i].DD;
list.CRM_OA_CC_SUBList[i].GZMB = mxmodel[i].GZMB;
}
MessageInfo info = crmModels.CRM_OA.Launch(basic, list, token); //提交
if (info.Key != "0" && info.Key != "-1")
{
model.ISACTIVE = 2;
crmModels.KQ_CC.Update_TT(model, token);
CRM_OA_TRANSMIT TRANSMITmodel = new CRM_OA_TRANSMIT();
TRANSMITmodel.OAID = info.Key;
TRANSMITmodel.OACSBH = model.CCID;
TRANSMITmodel.OACSLB = 1083;
TRANSMITmodel.OAZT = 1;
TRANSMITmodel.CJSJ = DateTime.Now.ToString("yyyy-MM-dd");
crmModels.OA_TRANSMIT.Create(TRANSMITmodel, token);
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(info));
}
public int Update(CRM_HG_STAFF model, string ptoken)
{
return(client.Update(model, ptoken));
}
public int Data_Update_Users_Role_Duty(int staffid, string STAFFUSER, string STAFFPW, bool islock, int STAFFKHLXID, string roledata, string dutydata) //给人员修改加用户名和密码并管理职务角色
{
token = appClass.CRM_Gettoken();
//CRM_Report_STAFFModel model = new CRM_Report_STAFFModel();
//model.STAFFNO = STAFFNO;
//model.ISACTIVE = 1;
//int staffid = crmModels.HG_STAFF.Report(model, token)[0].STAFFID; //根据工号找到staffid
CRM_HG_STAFF data = crmModels.HG_STAFF.ReadBySTAFFID(staffid, token); //根据staffid找到人员信息
data.STAFFUSER = STAFFUSER;
if (STAFFPW != "") //如果密码有所改动
{
string pattern = @"(?=.*[a-zA-Z])(?=.*[0-9])";
bool result = Regex.IsMatch(STAFFPW, pattern);
if (result == false)
{
return(-2); //复杂度不够
}
if (STAFFPW.Length < 8)
{
return(-3); //长度少于8
}
data.STAFFPW = FormsAuthentication.HashPasswordForStoringInConfigFile(STAFFPW, "MD5").ToLower();
}
data.SISLOCK = islock;
if (!islock)
{
data.E_COUNT = 0;
}
data.STAFFKHLXID = STAFFKHLXID;
if (data.USERLX == 0) //等于0是人员新建账户的情况。改成1108代表人员账户，非0则不作修改
{
data.USERLX = 1108;
}
int i = crmModels.HG_STAFF.Update(data, token); //帐号密码加进去，更新人员信息
if (i == -1)
{
return(-4);
}
CRM_HG_ROLE[] rolemodel = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_HG_ROLE[]>(roledata);
crmModels.HG_ROLE.Delete_STAFFROLEByStaffid(staffid, token);
for (int x = 0; x < rolemodel.Length; x++)
{
int _i = crmModels.HG_ROLE.Create_STAFFROLE(staffid, rolemodel[x].ROLEID, token);
if (_i <= 0)
{
return(-10);
}
}
DutyModelForNow[] dutymodel = Newtonsoft.Json.JsonConvert.DeserializeObject <DutyModelForNow[]>(dutydata);
crmModels.HG_STAFFDUTY.DeleteByStaffid(staffid, token);
for (int x = 0; x < dutymodel.Length; x++)
{
int _i = crmModels.HG_STAFFDUTY.Create(staffid, Convert.ToInt32(dutymodel[x].DUTYID), token);
if (_i <= 0)
{
return(-20);
}
}
return(i);
}
public CRM_HG_STAFFList[] ReadByParam(CRM_HG_STAFF model, string ptoken)
{
return(client.ReadByParam(model, ptoken));
}
