public JsonResult JsonMobileLogin(string username, string pwd)
{
bool IsSuccess = false;
string Msg = "失敗…";
try
{
if (LoginModel.Login(username.Trim(), pwd.Trim()))
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
var login = (from row in db.MobileLogin where row.login_name == username select row).FirstOrDefault();
if (login != null)
{
login.login_Time = DateTime.Now;
db.SubmitChanges();
}
else
{
MobileLogin ML = new MobileLogin();
ML.login_name = username;
ML.login_Time = DateTime.Now;
db.MobileLogin.InsertOnSubmit(ML);
db.SubmitChanges();
}
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1,
username,//你想要存放在 User.Identy.Name 的值，通常是使用者帳號
DateTime.Now,
DateTime.Now.AddMinutes(30),
false, //將管理者登入的 Cookie 設定成 Session Cookie
"", //userdata看你想存放啥
FormsAuthentication.FormsCookiePath);
string encTicket = FormsAuthentication.Encrypt(ticket);
Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName, encTicket));
IsSuccess = true;
Msg = "登入成功";
}
}
else
{
IsSuccess = false;
Msg = "登入失敗";
}
}
catch (Exception ex)
{
IsSuccess = false;
Msg = ex.Message;
}
return(Json(new { IsSuccess = IsSuccess, Msg = Msg }, JsonRequestBehavior.AllowGet));
}
public ActionResult EditScheduleChart(int ATSID, string ATName, string TCBIDString)
{
if (!string.IsNullOrEmpty((string)Session["UserID"]))
{
ViewBag.Title = WebCMS.Menu.EditTCBook;
try
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
ViewData["ATName"] = ATName;
ViewData["TCBookData"] = db.vw_TCBook_info.Where(x => x.Login_name == (string)Session["UserID"]).ToList();
var ATCList = db.ATC_info.Where(x => x.ATSID == ATSID).ToList();
if (ATCList != null && ATCList.Count > 0)
{
db.ATC_info.DeleteAllOnSubmit(ATCList);
db.SubmitChanges();
}
if (TCBIDString.Length > 0)
{
string[] S = TCBIDString.Split(',');
foreach (string item in S)
{
ATC_info ATC = new ATC_info();
ATC.ATSID = ATSID;
ATC.TCBID = int.Parse(item);
db.ATC_info.InsertOnSubmit(ATC);
}
db.SubmitChanges();
}
ViewBag.Message = WebCMS.Menu.Edit + "ok";
}
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
}
}
else
{
ViewBag.MessageType = "警告";
ViewBag.Message = "您無權限使用本功能或長時間未使用已自動登出，請重新登入，如有疑問請洽管理員，謝謝…";
return(View("Message"));
}
return(View());
}
public JsonResult JsonMobileLogout(string username)
{
bool IsSuccess = false;
string Msg = "失敗…";
try
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
var ML = from row in db.MobileLogin where row.login_name == username select row;
db.MobileLogin.DeleteAllOnSubmit(ML.ToList());
db.SubmitChanges();
FormsAuthentication.SignOut();
}
IsSuccess = true;
Msg = "登出成功";
}
catch (Exception ex)
{
IsSuccess = false;
Msg = ex.Message;
}
return(Json(new { IsSuccess = IsSuccess, Msg = Msg }, JsonRequestBehavior.AllowGet));
}
public static string Update(SensorTagModel s)
{
try
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
var r = (from row in db.plc_info where row.plc_id == s.plc_id select row).SingleOrDefault();
if (r != null)
{
r.LinkProcessData = s.LinkProcessData;
r.SensorTag = s.sensorTag;
r.ChamberTag = s.chamberTag;
//if (!r.Any())
//{
// db.SenSorTag_info.InsertOnSubmit(tmp);
//}
db.SubmitChanges();
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
return(null);
}
internal string Update(string p)
{
string tempString = "";
try
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
var r = db.ATSchedule_info.Where(x => x.ATSID == ATSID).SingleOrDefault();
if (r != null)
{
r.ATName = ATName;
r.DataCycle = DataCycle;
r.DataRangeTime = new TimeSpan(DataRangeHour, DataRangeMinute, 0);
r.DataType = DataType;
r.ExecuteCycle = ExecuteCycle;
r.ExecuteTime = new TimeSpan(ExecuteHour, ExecuteMinute, 0);
r.ExecuteType = ExecuteType;
r.SamplingTime = SamplingTime;
if (ExecuteType == "d")
{
r.ExecuteCycle = 0;
}
db.SubmitChanges();
tempString = WebCMS.Menu.Edit + "ok";
}
}
}
catch (Exception ex)
{
tempString = ex.Message;
}
return(tempString);
}
internal string Add(string Login_name)
{
string tempString = "";
try
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
ATSchedule_info ATS = new ATSchedule_info();
ATS.ATName = ATName;
ATS.buileDate = DateTime.Now;
ATS.DataCycle = DataCycle;
ATS.DataRangeTime = new TimeSpan(DataRangeHour, DataRangeMinute, 0);
ATS.DataType = DataType;
ATS.ExecuteCycle = ExecuteCycle;
ATS.ExecuteTime = new TimeSpan(ExecuteHour, ExecuteMinute, 0);
ATS.ExecuteType = ExecuteType;
ATS.SamplingTime = SamplingTime;
ATS.Login_name = Login_name;
if (ExecuteType == "d")
{
ATS.ExecuteCycle = 0;
}
db.ATSchedule_info.InsertOnSubmit(ATS);
db.SubmitChanges();
}
}
catch (Exception ex)
{
tempString = ex.Message;
}
return(tempString);
}
internal static string Delete(int ATSID)
{
string tempString = "";
try
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
var r = db.ATSchedule_info.Where(x => x.ATSID == ATSID).SingleOrDefault();
if (r != null)
{
db.ATSchedule_info.DeleteOnSubmit(r);
db.SubmitChanges();
tempString = WebCMS.Menu.Delete + "ok";
}
}
}
catch (Exception ex)
{
tempString = ex.Message;
}
return(tempString);
}
