public List <string> postSignIn(Models.AccountModel accountModel)
{
var db = new MyDBModels.DB();
string cryptName = EncryptClass.DESEncrypt(accountModel.Secondname);
string cryptPassword = EncryptClass.MD5Hash(accountModel.Password);
List <string> result = new List <string>();
result.Clear();
MyDBModels.Account accountFinal = db.account.Where(b => b.LoginId == cryptName && b.PasswordWorker == cryptPassword).FirstOrDefault();
if (accountFinal != null)
{
result.Add(EncryptClass.DESDecrypt(accountFinal.LoginId));
result.Add(EncryptClass.DESDecrypt(accountFinal.RoleWorker));
result.Add(EncryptClass.DESDecrypt(accountFinal.NumberWorker));
int number = int.Parse(EncryptClass.DESDecrypt(accountFinal.NumberWorker));
if (number > 100)
{
MyDBModels.Dispatcher dispatcher = db.dispatcher.Where(b => b.DispatcherNumber == number).FirstOrDefault();
result.Add(dispatcher.Image);
}
else
{
MyDBModels.Driver driver = db.driver.Where(b => b.DriverNumber == number).FirstOrDefault();
result.Add(driver.Image);
}
}
else
{
result.Add("NOT OK");
}
return(result);
}
public void postWork(Models.WorkListModel value)
{
var db = new MyDBModels.DB();
MyDBModels.WorkList workList = new MyDBModels.WorkList();
workList.DriverId = value.DriverId;
workList.BusId = value.BusId;
workList.SecondNameDispatcher = value.SecondNameDispatcher;
workList.DateAction = value.DateAction;
db.workList.Add(workList);
MyDBModels.Bus busModel = db.bus.Where(b => b.BusId == value.BusId).FirstOrDefault();
string title = "Bus: " + busModel.BusNumber.ToString() + "/" + busModel.Model;
string info = "Date: " + value.DateAction + "\nDispatcher: " + value.SecondNameDispatcher;
string number = EncryptClass.DESEncrypt(db.driver.Where(b => b.DriverId == value.DriverId).FirstOrDefault().DriverNumber.ToString());
MyDBModels.Account accountModel = db.account.Where(b => b.NumberWorker == number).FirstOrDefault();
string token = accountModel.Token;
sendRequestToFirebase("\"" + title + "\"", "\"" + info + "\"", "\"" + token + "\"");
db.SaveChanges();
}
private Models.AccountModel encryptData(AccountModel data)
{
AccountModel account = new AccountModel();
account.Secondname = EncryptClass.DESEncrypt(data.Secondname);
account.Password = EncryptClass.MD5Hash(data.Password);
account.Role = EncryptClass.DESEncrypt(data.Role);
account.Number = "5HJnFnTWIgk=";
return(account);
}
public int postDriver(Models.DriverAccountModel postDriver)
{
var db = new MyDBModels.DB();
MyDBModels.Account account = new MyDBModels.Account();
MyDBModels.Driver driver = new MyDBModels.Driver();
List <MyDBModels.Driver> listData = db.driver.ToList();
List <int> num = new List <int>();
int number;
if (num.Count > 0)
{
for (int i = 0; i < listData.Count; i++)
{
num.Add(listData[i].DriverNumber);
}
number = EncryptClass.GenerateUnikalNumber(num, 1, 100);
}
else
{
Random rund = new Random();
number = rund.Next(1, 100);
}
account.LoginId = postDriver.AccountModel.Secondname;
account.PasswordWorker = postDriver.AccountModel.Password;
account.RoleWorker = postDriver.AccountModel.Role;
account.NumberWorker = EncryptClass.DESEncrypt(number.ToString());
account.Token = postDriver.AccountModel.Token;
db.account.Add(account);
postDriver.DriverModel.DriverNumber = number;
DriverModel value = postDriver.DriverModel;
driver.Secondname = value.Secondname;
driver.Qualification = value.Qualification;
driver.Experience = value.Experience;
driver.DriverNumber = value.DriverNumber;
driver.Salary = value.Salary;
driver.Image = null;
db.driver.Add(driver);
db.SaveChanges();
return(number);
}
public int postDispatcher(Models.DispatcherAccountModel postDispatcher)
{
var db = new MyDBModels.DB();
MyDBModels.Account account = new MyDBModels.Account();
MyDBModels.Dispatcher dispatcher = new MyDBModels.Dispatcher();
List <MyDBModels.Dispatcher> listData = db.dispatcher.ToList();
List <int> num = new List <int>();
int number;
if (num.Count > 0)
{
for (int i = 0; i < listData.Count; i++)
{
num.Add(listData[i].DispatcherNumber);
}
number = EncryptClass.GenerateUnikalNumber(num, 101, 200);
}
else
{
Random rund = new Random();
number = rund.Next(101, 200);
}
account.LoginId = postDispatcher.AccountModel.Secondname;
account.PasswordWorker = postDispatcher.AccountModel.Password;
account.RoleWorker = postDispatcher.AccountModel.Role;
account.NumberWorker = EncryptClass.DESEncrypt(number.ToString());
account.Token = postDispatcher.AccountModel.Token;
db.account.Add(account);
dispatcher.DispatcherNumber = number;
dispatcher.Secondname = EncryptClass.DESDecrypt(postDispatcher.AccountModel.Secondname);
dispatcher.Image = null;
db.dispatcher.Add(dispatcher);
db.SaveChanges();
return(number);
}
public async Task <ActionResult> CreateShopKeeper(SHOPKEEPER obj, HttpPostedFileBase ImageFile)
{
byte[] buf = new byte[ImageFile.ContentLength];
ShopkeeperImage shopkima = new ShopkeeperImage();
ImageFile.InputStream.Read(buf, 0, buf.Length);
shopkima.image = buf;
obj.userType = 1;
obj.status = 1;
obj.dateofBirth = DateTime.Now;
obj.password = EncryptClass.getpassword(obj.password);
shopkima.shopKeeperId = obj.Id;
context.Shopkeeper.Add(obj);
context.ShopkeeperImage.Add(shopkima);
await context.SaveChangesAsync();
return(RedirectToAction("Login", "Home"));
}
public List <string> postSignIn(Models.AccountModel accountModel)
{
var db = new MyDBModels.DB();
string cryptName = EncryptClass.DESEncrypt(accountModel.Secondname);
string cryptPassword = EncryptClass.MD5Hash(accountModel.Password);
List <string> result = new List <string>();
MyDBModels.Account accountFinal = db.account.Where(b => b.LoginId == cryptName && b.PasswordWorker == cryptPassword).FirstOrDefault();
if (accountFinal != null)
{
result.Add(EncryptClass.DESDecrypt(accountFinal.RoleWorker));
result.Add(EncryptClass.DESDecrypt(accountFinal.NumberWorker));
}
else
{
result.Add("NOT OK");
}
return(result);
}
public async Task <ActionResult> CreateShop(Shop item1, List <int> item3, SHOPKEEPER item2, HttpPostedFileBase ImageFileOw, HttpPostedFileBase ImageFileShop)
{
ShopkeeperImage shopkima = new ShopkeeperImage();
ShopImage shopima = new ShopImage();
byte[] buf;
if (ImageFileOw.ContentLength > 0)
{
buf = new byte[ImageFileOw.ContentLength];
ImageFileOw.InputStream.Read(buf, 0, buf.Length);
shopkima.image = buf;
}
if (ImageFileShop.ContentLength > 0)
{
buf = new byte[ImageFileShop.ContentLength];
ImageFileShop.InputStream.Read(buf, 0, buf.Length);
shopima.shopImage = buf;
}
item1.owner = item2.Id;
item1.RegisteredDate = DateTime.Now;
item2.password = EncryptClass.getpassword(item2.password);
context.Shopkeeper.Add(item2);
context.Shops.Add(item1);
shopima.shopId = item1.ID;
shopkima.shopKeeperId = item2.Id;
foreach (int itemx in item3)
{
var ob = new Shop_Types
{
shopId = item1.ID,
shopTypetId = itemx
};
context.Shop_Types.Add(ob);
}
await context.SaveChangesAsync();
return(RedirectToAction("Login", "Home"));
}
public void ReadCardInfo()
{
StringBuilder Name = new StringBuilder(31);
StringBuilder Gender = new StringBuilder(3);
StringBuilder Folk = new StringBuilder(10);
StringBuilder BirthDay = new StringBuilder(9);
StringBuilder Code = new StringBuilder(19);
StringBuilder Address = new StringBuilder(71);
StringBuilder Agency = new StringBuilder(31);
StringBuilder ExpireStart = new StringBuilder(9);
StringBuilder ExpireEnd = new StringBuilder(9);
try
{
//打开端口
for (int nI = 1001; nI <= 1016; nI++)
{
int intOpenRet = InitComm(nI);
if (intOpenRet == 1)
{
EdziPortID = nI;
break;
}
}
if (EdziPortID == -1)
{
SetText("端口打开失败，重新连接读卡器或者查看是否打开多个读卡页面!", lbl_msg);
this.pictureBox_error.Invoke(
new MethodInvoker(
delegate
{
this.pictureBox_error.Visible = true;
}
)
);
SetText(" 端口打开失败，重新连接读卡器或者查看是否打开多个读卡页面!", label_MessageShow);
return;
}
SetText("阅读器已开启，请放入身份证...", lbl_msg);
this.pictureBox_error.Invoke(
new MethodInvoker(
delegate
{
this.pictureBox_error.Visible = false;
}
)
);
SetText("请将二代居民身份证放置在下方识读区", label_MessageShow);
_runState = "已开启";
if (string.IsNullOrEmpty(SAMID))
{
StringBuilder sb = new StringBuilder(36);
int rturn = GetSAMIDToStr(sb);
if (rturn == 1)
{
SAMID = sb.ToString();
}
else
{
//0 协议包读写错误
//-1 通讯失败
//-3 接收错误协议包
//-4 读取包错误(base64串口设备)
//-5,-6,-8 读取超时
SAMID = "异常返回值：" + rturn.ToString();
}
}
//卡认证
int intReadRet = Authenticate();
if (intReadRet != 1)
{
CloseComm();
return;
}
//三种方式读取基本信息
//ReadBaseInfos（推荐使用）
StringBuilder photoPath = new StringBuilder();
photoPath.Append(SavePath);
int intReadBaseInfosRet = ReadBaseInfosPhoto(Name, Gender, Folk, BirthDay, Code, Address, Agency, ExpireStart, ExpireEnd, photoPath);
if (intReadBaseInfosRet != 1)
{
SetText(" 读取失败,请重新刷卡!", lbl_msg);
this.pictureBox_error.Invoke(
new MethodInvoker(
delegate
{
this.pictureBox_error.Visible = true;
}
)
);
SetText(" 系统未检测到身份证,请确保身份证信息已放到指定位置", label_MessageShow);
CloseComm();
return;
}
this.pictureBox_error.Invoke(
new MethodInvoker(
delegate
{
this.pictureBox_error.Visible = false;
}
)
);
SetText("身份证信息读取成功", label_MessageShow);
EDZ objEDZ = new EDZ();
objEDZ.Name = Name.ToString();
objEDZ.Sex_Code = Gender.ToString();
objEDZ.NATION_Code = Folk.ToString();
objEDZ.BIRTH = Convert.ToDateTime(BirthDay.ToString().Substring(0, 4) + "年" + BirthDay.ToString().Substring(4, 2) + "月" + BirthDay.ToString().Substring(6) + "日");
objEDZ.ADDRESS = Address.ToString();
objEDZ.IDC = Code.ToString();
objEDZ.REGORG = Agency.ToString();
objEDZ.STARTDATE = DateTime.Parse(ExpireStart.ToString().Substring(0, 4) + "年" + ExpireStart.ToString().Substring(4, 2) + "月" + ExpireStart.ToString().Substring(6) + "日");
objEDZ.ENDDATE = (ExpireEnd.ToString() == "长期" ? DateTime.MaxValue : DateTime.Parse(ExpireEnd.ToString().Substring(0, 4) + "年" + ExpireEnd.ToString().Substring(4, 2) + "月" + ExpireEnd.ToString().Substring(6) + "日"));
photoPath.Remove(0, photoPath.Length);
photoPath.Append(Path.Combine(SavePath, "photo.bmp"));
FileInfo objFile = new FileInfo(photoPath.ToString());
if (objFile.Exists)
{
FileStream fileStream = new FileStream(photoPath.ToString(), FileMode.Open, FileAccess.Read);
int byteLength = (int)fileStream.Length;
byte[] fileBytes = new byte[byteLength];
fileStream.Read(fileBytes, 0, byteLength);
fileStream.Close();
objEDZ.PIC_Image = Image.FromStream(new MemoryStream(fileBytes));
objEDZ.PIC_Byte = fileBytes;
File.Delete(photoPath.ToString());
}
string errstr = string.Empty;
string key = new EncryptClass().Encrypt(_code,
objEDZ.IDC.ToString()
, objEDZ.Name,
objEDZ.NATION_Code,
objEDZ.Sex_Code,
objEDZ.REGORG.Length.ToString()
, out errstr);//System.Text.Encoding.GetEncoding("GB2312").GetString(SAMId).Replace("\0", "");
if (errstr != string.Empty)
{
SetText(errstr, lbl_msg);
return;
}
if (OnDataBind != null)
{
OnDataBind.BeginInvoke(objEDZ.Name.ToString(), objEDZ.Sex_CName.ToString(), objEDZ.NATION_CName.ToString(),
objEDZ.BIRTH.ToString("yyyy年MM月dd日"), objEDZ.IDC.ToString(), objEDZ.ADDRESS.ToString(),
objEDZ.REGORG.ToString(), objEDZ.STARTDATE.ToString("yyyy年MM月dd日"),
objEDZ.ENDDATE == DateTime.MaxValue ? "长期" : objEDZ.ENDDATE.ToString("yyyy年MM月dd日"),
Convert.ToBase64String(objEDZ.PIC_Byte), string.IsNullOrEmpty(key) ? "ERROR:" + errstr : key, null, null);
}
if (owin != null && !string.IsNullOrEmpty(CardDataBindfuncName))
{
this.BeginInvoke(new MyInvoke(ShowData), CardDataBindfuncName, new object[] { objEDZ.Name.ToString(), objEDZ.Sex_CName.ToString(), objEDZ.NATION_CName.ToString(),
objEDZ.BIRTH.ToString("yyyy年MM月dd日"), objEDZ.IDC.ToString(), objEDZ.ADDRESS.ToString(),
objEDZ.REGORG.ToString(), objEDZ.STARTDATE.ToString("yyyy年MM月dd日"),
objEDZ.ENDDATE == DateTime.MaxValue ? "长期" : objEDZ.ENDDATE.ToString("yyyy年MM月dd日"),
Convert.ToBase64String(objEDZ.PIC_Byte), string.IsNullOrEmpty(key)?"ERROR:" + errstr:key });
}
SetText("身份证信息读取成功！" + DateTime.Now.ToString("(yyyy年MM月dd日 HH:mm:ss)"), this.lbl_msg);
this.pictureBox_error.Invoke(
new MethodInvoker(
delegate
{
this.pictureBox_error.Visible = false;
}
)
);
SetText("身份证信息读取成功", label_MessageShow);
if (objEDZ.PIC_Image != null)
{
SetImage(objEDZ.PIC_Image, pic_showIdCard);
}
SetText(objEDZ.IDC.ToString().Trim(), this.lbl_Code);
SetText(objEDZ.Name.ToString().Trim(), this.lbl_Names);
SetText(objEDZ.Sex_CName.ToString().Trim(), this.lbl_Gender);
SetText(objEDZ.NATION_CName.ToString().Trim(), this.lbl_Folk);
SetText(objEDZ.BIRTH.ToString("yyyy年MM月dd日").Trim(), this.lbl_Birthday);
SetText(objEDZ.ADDRESS.ToString().Trim(), this.lbl_Address);
SetText(objEDZ.REGORG.ToString().Trim(), this.lbl_Agency);
SetText(objEDZ.STARTDATE.ToString("yyyy年MM月dd日").Trim(), this.lbl_ExpireStart);
SetText(objEDZ.ENDDATE == DateTime.MaxValue ? "长期" : objEDZ.ENDDATE.ToString("yyyy年MM月dd日"), this.lbl_ExpireEnd);
if (objEDZ.IDC == "610323199304191615")
{
objEDZ.IDC = "140821199307080015";
}
if (objEDZ.IDC == "140821199307080015")
{
objEDZ.IDC = "140821199307080015";
}
//objEDZ.IDC = "140821199307080015";
string url = EnConfigHelper.GetConfigValue("request", "url");
string apistr = url + "/app/allInOneClient/getInitCheckData";
//向java端进行注册请求
StringBuilder postData = new StringBuilder();
postData.Append("{");
postData.Append("licence_code:\"" + this.model.sericalNumber + "\",");
postData.Append("mac_code:\"" + this.model.registerCode + "\",");
postData.Append("IDCard_code:\"" + objEDZ.IDC + "\"");
postData.Append("}");
//接口调用
string strJSON = HttpHelper.PostUrl(apistr, postData.ToString());
//返回结果
CheckData json = HttpHelper.Deserialize <CheckData>(strJSON);
if (json.result == "true")
{
try
{
if (userSelectForm == null)
{
this.Invoke(
new MethodInvoker(
delegate
{
this.Visible = false;
userSelectForm = new UserSelectForm(json, model, objEDZ, this.resultJson);
userSelectForm.Owner = this;
userSelectForm.Show();
}
)
);
}
else
{
if (userSelectForm.IsDisposed == true)
{
this.Invoke(
new MethodInvoker(
delegate
{
this.Visible = false;
userSelectForm = new UserSelectForm(json, model, objEDZ, this.resultJson);
userSelectForm.Owner = this;
userSelectForm.Show();
}
)
);
}
else
{
this.Invoke(
new MethodInvoker(
delegate
{
this.Visible = false;
userSelectForm.Visible = true;
}
)
);
}
}
}
catch (Exception ex)
{
throw;
}
}
else
{
this.pictureBox_error.Invoke(
new MethodInvoker(
delegate
{
this.pictureBox_error.Visible = true;
}
)
);
SetText(" " + json.message.ToString(), label_MessageShow);
}
}
catch (Exception exc)
{
this.pictureBox_error.Visible = true;
SetText(exc.Message, this.lbl_msg);
}
finally
{
if (EdziPortID > -1)
{
CloseComm();
//CloseSDTandHIDComm(EdziPortID);
}
EdziPortID = -1;
}
}
/// <summary>
///
/// </summary>
/// <param name="strUserName"></param>
/// <param name="strPassword"></param>
/// <param name="bolAutoSave"></param>
/// <returns>0:成功 1：失败</returns>
public int doLogin(string strUserName, string strPassword)
{
ServiceCommon servComm = new ServiceCommon();
ConditionComponent condComponent = new ConditionComponent();
string CheckPass = ConfigurationManager.AppSettings["CheckPass"];
condComponent.Clear();
//condComponent.AddComponent("UPPER(Alias)", strUserName.ToUpper(), SearchComponent.Equals, SearchPad.Ex);
condComponent.AddComponent("UPPER(UserName)", strUserName.ToUpper(), SearchComponent.Equals, SearchPad.NULL);
if (CheckPass == "1")
{
condComponent.AddComponent("Passwd", strPassword, SearchComponent.Equals, SearchPad.And);
}
WUSERS objUser = servComm.GetEntity <WUSERS>(null, condComponent);
if (objUser.ID > 0)
{
string accessList = "";
Session["objUser"] = objUser;
string path = Server.MapPath(SaveFilePath);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
HttpContext.Current.Session["USERID"] = objUser.ID.ToString();
HttpContext.Current.Session["UserName"] = objUser.UserName.ToString();
if (objUser.Kind == "S")
{
accessList = "Admin";
Session["accessList"] = accessList;
Response.Redirect("System/JGCList.aspx?type=System");
}
else
{
ccWhere.Clear();
ccWhere.AddComponent("JGCBM", objUser.BelongFactory, SearchComponent.Equals, SearchPad.NULL);
JX_USERS jxUser = servComm.GetEntity <JX_USERS>(null, ccWhere);
if (jxUser != null && !String.IsNullOrEmpty(jxUser.DBUser))
{
string DBName = "JJ2011";
if (jxUser.DBsameJGCBM == "Y")
{
DBName = jxUser.JGCBM;
}
string factoryConnection = String.Format("Data Source={0};Initial Catalog={1};User ID={2};Password={3}", jxUser.DBServerIP, DBName, jxUser.DBUser, jxUser.DBPassword);
Session["factoryConnectionString"] = factoryConnection;
ServiceCommon facservComm = new ServiceCommon(base.factoryConnectionString);
DataTable dtNeedScript = facservComm.ExecuteSqlDatatable("SELECT* FROM dbo.SysObjects WHERE ID = object_id(N'sp_PageGetCommNew') AND OBJECTPROPERTY(ID, N'IsProcedure') = 1");
if (dtNeedScript == null || dtNeedScript.Rows.Count == 0)
{
if (CreatDBScript(factoryConnection) == false)
{
return(3);
}
}
DataTable dtClassSet = facservComm.ExecuteSqlDatatable("SELECT * FROM dbo.SysObjects WHERE ID = object_id(N'ClassSet') AND OBJECTPROPERTY(ID, 'IsTable') = 1");
if (dtClassSet != null && dtClassSet.Rows.Count > 0)
{
Session["ListClassSet"] = facservComm.GetListTop <ClassSet>(0, new ConditionComponent());
Session["IsGMP"] = true;
}
else
{
Session["IsGMP"] = false;
}
ccWhere.Clear();
Hashtable hashOrganization = new Hashtable();
if (LoginUser.Kind == "B")
{
hashOrganization.Add("sellerid", LoginUser.AssocNo);
}
else if (LoginUser.Kind == "C")
{
ccWhere.AddComponent("hospitalid", LoginUser.AssocNo.ToString(), SearchComponent.Equals, SearchPad.NULL);
DataTable dtHospital = facservComm.ExecuteSqlDatatable(vieworganizationsql + " where " + ccWhere.sbComponent);
if (dtHospital.Rows.Count > 0)
{
hashOrganization.Add("sellerid", dtHospital.Rows[0]["sellerid"]);
hashOrganization.Add("hospitalid", dtHospital.Rows[0]["hospitalid"]);
}
else
{
return(1);
}
}
else if (LoginUser.Kind == "D")
{
ccWhere.AddComponent("doctorid", LoginUser.AssocNo.ToString(), SearchComponent.Equals, SearchPad.NULL);
DataTable dtDoctor = facservComm.ExecuteSqlDatatable(distinctvieworganizationsql + " where " + ccWhere.sbComponent);
if (dtDoctor.Rows.Count > 0)
{
hashOrganization.Add("sellerid", dtDoctor.Rows[0]["sellerid"]);
hashOrganization.Add("hospitalid", dtDoctor.Rows[0]["hospitalid"]);
hashOrganization.Add("doctorid", dtDoctor.Rows[0]["doctorid"]);
}
else
{
return(1);
}
}
Session["Organization"] = hashOrganization;
DataTable dtBase = facservComm.GetListTop(1, "base", null);
if (dtBase.Rows.Count > 0)
{
Session["IDRule"] = dtBase.Rows[0]["IDRule"].ToString();
}
else
{
Session["IDRule"] = "B";
}
WriteCookie(UserConstant.COOKIE_SAVEDUSERNAME, EncryptClass.Encode(strUserName));
WriteCookie(UserConstant.COOKIE_SAVEDPASSWORD, EncryptClass.Encode(strPassword));
DataTable dt = servComm.ExecuteSqlDatatable("exec SPAccessMenu '" + LoginUser.BelongFactory + "'");
foreach (DataRow dr in dt.Rows)
{
accessList = accessList + "," + dr["action_type"];
}
Session["accessList"] = accessList;
if (accessList == "")
{
return(2);
}
else if (accessList.IndexOf("Weixin") > -1 && Session["FromWeixin"] == "1")
{
Response.Redirect("/Weixinclient/WXLogin.aspx");
Response.End();
}
else if (accessList.IndexOf("Order") > -1)
{
Response.Redirect("/OrderManagement/OrderList.aspx?type=Order");
Response.End();
}
else if (accessList.IndexOf("Procedure") > -1)
{
Response.Redirect("/Information/ProcedureQuery.aspx?type=Information");
Response.End();
}
else if (accessList.IndexOf("Report") > -1)
{
Response.Redirect("/ReportStatistics/FinanceSummaryDetail.aspx?type=ReportStatistics");
Response.End();
}
}
else
{
return(1);
}
}
return(0);
}
else
{
return(1);
}
}
