public ActionResult Userrdelete(string id)
{
try
{
string[] uid = id.Split(',');
foreach (string i in uid)
{
if (!string.IsNullOrEmpty(i))
{
Sys_Users spc = Sys_user.DbSession.Sys_UsersDal.FirstOrDefault(u => u.Emp_no == i.ToString().Trim());
Sys_user.DbSession.Sys_UsersDal.Delete(spc);
PhoneUsers pu = Sys_user.DbSession.PhoneUsersDal.FirstOrDefault(u => u.ID == i.ToString().Trim());
if (pu != null)
{
Sys_user.DbSession.PhoneUsersDal.Delete(pu);
}
}
}
Sys_user.DbSession.SaveChanges();
return(Content("刪除成功"));
}
catch (Exception)
{
return(Content("刪除失敗"));
}
}
//添加線長
public ActionResult StaffADDDBOSS(string id, string class1, string li)
{
if (id != null)
{
try
{
string sql = "select cpf01,cpf02,cpf29,cpf70 from cpf_file where cpf35 is null and cpf01='" + id + "' ";
DataTable dt = new DataTable();
dt = TIPTOP.AdoDAL.SQLHelper.GetTable(sql, System.Data.CommandType.Text);
Staff sf = new Staff();
sf.ID = id;
sf.NAME = dt.Rows[0][1].ToString();
sf.BU = dt.Rows[0][2].ToString();
sf.BUID = dt.Rows[0][2].ToString();
sf.CLASS = class1;
sf.POSITION = "線長";
sf.LINENAME = li;
sf.date1 = DateTime.Parse(dt.Rows[0][3].ToString().Substring(0, 9));
sf.date2 = DateTime.Now.Date;
staffService.DbSession.StaffDal.Add(sf);
PhoneUsers pu = new PhoneUsers();
pu.ID = id; pu.PASSWORD1 = id; pu.power1 = "1";
staffService.DbSession.PhoneUsersDal.Add(pu);
staffService.DbSession.SaveChanges();
return(Content("添加成功"));
}
catch (Exception)
{
return(Content("添加失敗可能該員工已經存在"));
}
}
return(Content("添加失敗可能該員工已經存在"));
}
void Start()
{
_phoneUsers = new PhoneUsers();
_phoneCallsHarcoded = new PhoneCallsHarcode();
_telephoneCentral = new TelephoneCentral(this, Board, StressController, _phoneUsers, SFXController);
//StartGame();
}
//添加線長手機賬號
public List <PhoneUsers> GetPhoneUsersList(List <cpf_file> cpf)
{
List <PhoneUsers> phoneUsers = new List <PhoneUsers>();
foreach (cpf_file c in cpf)
{
PhoneUsers s = new PhoneUsers();
s.ID = c.cpf01;
s.PASSWORD1 = c.cpf01;
s.power1 = "1";
phoneUsers.Add(s);
}
return(phoneUsers);
}
public TelephoneCentral(GameController gameController, Board board, StressController stressController, PhoneUsers phoneUsers, SFXController sfxController)
{
Instance = this;
this.board = board;
this.stressController = stressController;
this.gameController = gameController;
this.phoneUsers = phoneUsers;
this.sfxController = sfxController;
board.OnTalkingFinished += FinishCall;
board.SubscribeToJabEvent(ConnectCall);
stressController.OnStressPeak += EndCalls;
LoadCallGroups();
}
public ActionResult Userradd(string id, string bu, string ps)
{
if (id != null)
{
try
{
string sql = "select cpf01,cpf02,cpf29,cpf70 from cpf_file where cpf35 is null and cpf01='" + id + "' ";
DataTable dt = new DataTable();
dt = TIPTOP.AdoDAL.SQLHelper.GetTable(sql, System.Data.CommandType.Text);
Sys_Users spc = new Sys_Users();
spc.Emp_no = dt.Rows[0][0].ToString();
spc.Name = dt.Rows[0][1].ToString();
spc.Password = dt.Rows[0][0].ToString();
spc.Department = dt.Rows[0][2].ToString();
spc.Item3 = bu;
spc.Item1 = ps;
Sys_user.DbSession.Sys_UsersDal.Add(spc);
if (ps == "主管")
{
PhoneUsers pu = new PhoneUsers();
pu.ID = id.ToString().Trim();
pu.PASSWORD1 = id.ToString().Trim();
pu.power1 = "3";
Sys_user.DbSession.PhoneUsersDal.Add(pu);
}
Sys_user.DbSession.SaveChanges();
return(Content("添加成功"));
}
catch (Exception)
{
return(Content("沒有這個員工"));
}
}
return(Content("沒有這個員工"));
}
public void addPhoneUsers(DataTable dt)
{
//deletePhoneUsers(dt);
foreach (DataRow dr in dt.Rows)
{
#region
//string id = dr.Field<string>("工號").ToString().Trim();
//var tem = dbSession.PhoneUsersDal.FirstOrDefault(u => u.ID == id);
//if (tem == null)
//{
// if (dr.Field<string>("職位").ToString() == "線長")
// {
// PhoneUsers pu = new PhoneUsers();
// pu.ID = dr.Field<string>("工號").ToString().Trim();
// pu.PASSWORD1 = dr.Field<string>("工號").ToString().Trim();
// pu.power1 = "1";
// dbSession.PhoneUsersDal.Add(pu);
// }
//}
#endregion
if (dr.Field <string>("職位").ToString() == "線長")
{
string id = dr.Field <string>("工號").ToString().Trim();
var tem = dbSession.PhoneUsersDal.FirstOrDefault(u => u.ID == id);
if (tem == null)
{
PhoneUsers pu = new PhoneUsers();
pu.ID = dr.Field <string>("工號").ToString().Trim();
pu.PASSWORD1 = dr.Field <string>("工號").ToString().Trim();
pu.power1 = "1";
dbSession.PhoneUsersDal.Add(pu);
}
else
{
if (tem.power1 != "1")
{
tem.power1 = "1";
}
}
}
if (dr.Field <string>("職位").ToString() == "主管")
{
string id = dr.Field <string>("工號").ToString().Trim();
var tem = dbSession.PhoneUsersDal.FirstOrDefault(u => u.ID == id);
if (tem == null)
{
PhoneUsers pu = new PhoneUsers();
pu.ID = dr.Field <string>("工號").ToString().Trim();
pu.PASSWORD1 = dr.Field <string>("工號").ToString().Trim();
pu.power1 = "3";
dbSession.PhoneUsersDal.Add(pu);
}
else
{
if (tem.power1 != "3")
{
tem.power1 = "3";
}
}
}
}
dbSession.SaveChanges();
}
public ActionResult Login(string UserID1, string Password1)
{
IStaffDal staffDal = new StaffDal();
//ViewBag.Message = "Your application description page.";
Sys_Users user = new Sys_Users();
PhoneUsers phoneuser = new PhoneUsers();
bool flag = true; //驗證標記
if (UserID1 != null && Password1 != null)
{
//驗證PhoneUser 上有沒有數數據
var temp = Sys_user.DbSession.PhoneUsersDal.GetEntity(u => u.ID == UserID1 && u.PASSWORD1 == Password1);
if (temp.Count() == 1)
{
flag = false;
PhoneUsers pu = new PhoneUsers();
foreach (PhoneUsers t in temp)
{
var temp1 = Sys_user.DbSession.StaffDal.GetEntity(u => u.ID == UserID1);
foreach (Staff a in temp1)
{
//Session["Users"] = temp1 as Staff;
Session["UserID"] = a.ID;
Session["UserBU"] = a.BU;
Session["UserCLASS"] = a.CLASS;
Session["UserLINENAME"] = a.LINENAME;
}
pu = t;
}
//線長
if (pu.power1 == "1")
{
return(RedirectToAction("../Phone/CallNameSelectClass"));
}
//看明細的管理人員
if (pu.power1 == "3")
{
return(RedirectToAction("../details/QCdetail"));
}
}
//驗證文員賬號
user = Sys_user.GetSys_Users(UserID1, Password1);
if (user.Emp_no != null)
{
flag = false;
Session["BU"] = user.Item3;
// BU = user.Item3;
return(RedirectToAction("../Staff/StaffSearch"));
// return View("../Staff/StaffSearch");
}
if (flag)
{
string msg = "验证失败";
var script = string.Format("alert('{0}');", msg);
//return JavaScript(script);
return(Content("<script>alert('验证失败');history.go(-1);</script>"));
}
}
return(View());
//return Content("密碼錯誤");
}
