private void cmbImage_SelectedIndexChanged(object sender, EventArgs e) { SysUserBLL userbll = new SysUserBLL(); SysUser user = userbll.getDetail(PrimaryKey); AMBaseAnnexesFileEntity AMBaseAnnexesFileEntity = new AMBaseAnnexesFileEntity(); AMBaseAnnexesFileBLL AMBaseAnnexesFileBLL = new AMBaseAnnexesFileBLL(); switch (cmbImage.Text) { case "照片1": AMBaseAnnexesFileEntity = AMBaseAnnexesFileBLL.GetEntity(user.F_Picture1); break; case "照片2": AMBaseAnnexesFileEntity = AMBaseAnnexesFileBLL.GetEntity(user.F_Picture2); break; case "照片3": AMBaseAnnexesFileEntity = AMBaseAnnexesFileBLL.GetEntity(user.F_Picture3); break; case "照片4": AMBaseAnnexesFileEntity = AMBaseAnnexesFileBLL.GetEntity(user.F_Picture4); break; case "照片5": AMBaseAnnexesFileEntity = AMBaseAnnexesFileBLL.GetEntity(user.F_Picture5); break; } //照片显示 //string strPath = System.AppDomain.CurrentDomain.BaseDirectory + AMBaseAnnexesFileEntity.F_FilePath; //FileStream fs = new FileStream(strPath, FileMode.Open, FileAccess.Read); //Byte[] mybyte = new byte[fs.Length]; //fs.Read(mybyte, 0, mybyte.Length); //fs.Close(); //MemoryStream ms = new MemoryStream(mybyte); //Bitmap myimge = new Bitmap(ms); //pictureBox1.Image = myimge; }
private void btnEdit_Click(object sender, EventArgs e) { try { if (pictureBox1.Image != null) { pictureBox1.Image.Dispose(); pictureBox1.Image = null; } if (dataGridView.SelectedRows.Count < 1) { return; } photo(); if (pictureBox1.Image == null) { untCommon.InfoMsg("请选择正确的照片!"); return; } if (file()) { string ID = Guid.NewGuid().ToString("N");//照片名称 SysUser user = new SysUser(); SysUserBLL SysUserBLL = new SysUserBLL(); string F_Account = dataGridView.SelectedRows[0].Cells["账号"].Value.ToString(); user = SysUserBLL.getDetail(F_Account); AMBaseAnnexesFileEntity AMBaseAnnexesFileEntity = new AMBaseAnnexesFileEntity(); AMBaseAnnexesFileBLL AMBaseAnnexesFileBLL = new AMBaseAnnexesFileBLL(); AMBaseAnnexesFileEntity.F_Id = ID; AMBaseAnnexesFileEntity.F_FolderId = Guid.NewGuid().ToString(); AMBaseAnnexesFileEntity.F_FileName = Path.GetFileName(imagefile);//获取文件名和扩展名 AMBaseAnnexesFileEntity.F_FilePath = "D:/fileAnnexes/shop_erp/System/" + DateTime.Now.ToString("yyyyMMdd") + "/" + AMBaseAnnexesFileEntity.F_Id; AMBaseAnnexesFileEntity.F_FileSize = fileInfoLength; AMBaseAnnexesFileEntity.F_FileExtensions = Path.GetExtension(imagefile); //获取文件扩展名 AMBaseAnnexesFileEntity.F_FileType = imagefile.Substring(imagefile.LastIndexOf(".") + 1); // Path.GetExtension(imagefile).Substring(0, 1); //AMBaseAnnexesFileEntity.F_DownloadCount = ""; AMBaseAnnexesFileEntity.F_CreateDate = DateTime.Now; AMBaseAnnexesFileEntity.F_CreateUserId = SysUser.F_Account.ToString(); AMBaseAnnexesFileEntity.F_CreateUserName = SysUser.F_RealName.ToString(); user.F_Account = F_Account; switch (cmb_Image.Text) { case "照片1": user.F_Picture1 = AMBaseAnnexesFileEntity.F_Id; break; case "照片2": user.F_Picture2 = AMBaseAnnexesFileEntity.F_Id; break; case "照片3": user.F_Picture3 = AMBaseAnnexesFileEntity.F_Id; break; } //Computer MyComputer = new Computer(); //imagefile = System.AppDomain.CurrentDomain.BaseDirectory; //MyComputer.FileSystem.RenameFile(imagefile, image);//imagefile是所要重命名的文件的全路径,image是目标文件名 //image = Path.GetFileNameWithoutExtension(imagefile);// 没有扩展名的文件名 //FaceRecognition.Get_zjdz(imagefile); string strBase64 = FaceRecognition.ImageToBase64(imagefile);//照片转base64 MesDeviceBLL MesDeviceBLL = new MesDeviceBLL(); string D_Code = dataGridView.SelectedRows[0].Cells["部门"].Value.ToString(); var MesDevice = MesDeviceBLL.GetList_Deparemaent(D_Code, ""); if (MesDevice.Count < 1 || MesDevice == null) { untCommon.InfoMsg("该部门暂无人脸识别设备!"); return; } string url = "http://" + MesDevice[0].D_IP + ":8090/face/update"; //string postData = "pass="******"\n" + "&personId=" + user.F_EnCode + "\n" + "&faceId=" + ID + "\n" + "&imgBase64:" + strBase64 + ""; string postData = "pass="******"&personId=" + user.F_EnCode + "&faceId=" + ID + "&imgBase64=" + strBase64 + ""; string strtemp = FaceRecognition.HttpPost(url, postData); if (!FaceRecognition.json(strtemp)) { untCommon.InfoMsg("该IP地址不可用!"); return; } JObject joModel = (JObject)JsonConvert.DeserializeObject(strtemp); if (!bool.Parse(joModel["success"].ToString())) { untCommon.InfoMsg(joModel["msg"].ToString()); return; } else { untCommon.InfoMsg("人脸识别更新成功!"); string F_Picture = ""; switch (cmb_Image.Text) { case "照片1": user.F_Picture1 = F_Picture; break; case "照片2": user.F_Picture2 = F_Picture; break; case "照片3": user.F_Picture3 = F_Picture; break; } if (AMBaseAnnexesFileBLL.SaveEntityTrans("", user.F_UserId, F_Picture, AMBaseAnnexesFileEntity, user) > 0) { untCommon.InfoMsg("照片上传成功!"); } else { untCommon.InfoMsg("照片上传失败!"); } } //if (AMBaseAnnexesFileBLL.SaveEntity("", AMBaseAnnexesFileEntity) > 0) //{ // if (SysUserBLL.Edit(user) > 0) // { // } // else // { // untCommon.InfoMsg("上传失败!"); // } //} //else //{ // untCommon.InfoMsg("上传失败!"); //} //string url = "183.236.45.60"; //if (FaceRecognition.uploadFileByHttp(url, imagefile)) //{ //} } } catch (Exception ex) { untCommon.ErrorMsg("照片上传失败!"); } }
/// <summary> /// 保存实体数据 /// </summary> /// <param name="keyValue">主键</param> /// <param name="entity">实体</param> /// <returns>返回值大于0:操作成功</returns> public int SaveEntity(string keyValue, AMBaseAnnexesFileEntity entity) { try { var strSql = new StringBuilder(); var paramList = new List <SqlParameter>(); if (string.IsNullOrEmpty(keyValue)) { strSql.Append("INSERT INTO AM_Base_AnnexesFile("); strSql.Append("F_Id,"); strSql.Append("F_FolderId,"); strSql.Append("F_FileName,"); strSql.Append("F_FilePath,"); strSql.Append("F_FileSize,"); strSql.Append("F_FileExtensions,"); strSql.Append("F_FileType,"); strSql.Append("F_DownloadCount,"); strSql.Append("F_CreateDate,"); strSql.Append("F_CreateUserId,"); strSql.Append("F_CreateUserName"); strSql.Append(")"); strSql.Append("VALUES("); strSql.Append("@F_Id,"); strSql.Append("@F_FolderId,"); strSql.Append("@F_FileName,"); strSql.Append("@F_FilePath,"); strSql.Append("@F_FileSize,"); strSql.Append("@F_FileExtensions,"); strSql.Append("@F_FileType,"); strSql.Append("@F_DownloadCount,"); strSql.Append("@F_CreateDate,"); strSql.Append("@F_CreateUserId,"); strSql.Append("@F_CreateUserName"); strSql.Append(")"); paramList.Add(new SqlParameter("@F_Id", entity.F_Id)); //paramList.Add(new SqlParameter("@F_Id",Guid.NewGuid().ToString())); } else { strSql.Append("UPDATE AM_Base_AnnexesFile SET "); strSql.Append("F_FolderId=@F_FolderId,"); strSql.Append("F_FileName=@F_FileName,"); strSql.Append("F_FilePath=@F_FilePath,"); strSql.Append("F_FileSize=@F_FileSize,"); strSql.Append("F_FileExtensions=@F_FileExtensions,"); strSql.Append("F_FileType=@F_FileType,"); strSql.Append("F_DownloadCount=@F_DownloadCount,"); strSql.Append("F_CreateDate=@F_CreateDate,"); strSql.Append("F_CreateUserId=@F_CreateUserId,"); strSql.Append("F_CreateUserName=@F_CreateUserName "); strSql.Append(" WHERE F_Id=@ID"); paramList.Add(new SqlParameter("@ID", keyValue)); } paramList.Add(new SqlParameter("@F_FolderId", entity.F_FolderId)); paramList.Add(new SqlParameter("@F_FileName", entity.F_FileName)); paramList.Add(new SqlParameter("@F_FilePath", entity.F_FilePath)); paramList.Add(new SqlParameter("@F_FileSize", entity.F_FileSize)); paramList.Add(new SqlParameter("@F_FileExtensions", entity.F_FileExtensions)); paramList.Add(new SqlParameter("@F_FileType", entity.F_FileType)); paramList.Add(new SqlParameter("@F_DownloadCount", entity.F_DownloadCount)); paramList.Add(new SqlParameter("@F_CreateDate", entity.F_CreateDate)); paramList.Add(new SqlParameter("@F_CreateUserId", entity.F_CreateUserId)); paramList.Add(new SqlParameter("@F_CreateUserName", entity.F_CreateUserName)); var result = db.ExecuteNonQuery(strSql.ToString(), paramList.ToArray()); return(result); } catch (Exception) { throw; } }
/// <summary> /// 更新数据 事务 /// </summary> /// <param name="keyValue">主键</param> /// <param name="AMBaseAnnexesFileEntity">实体</param> /// <returns>返回值大于0:操作成功</returns> public int SaveEntityTrans(string AM_Base_AnnexesFile_keyValue, string AM_Base_User_keyValue, string AM_Base_AnnexesFile_delete_keyValue, AMBaseAnnexesFileEntity AMBaseAnnexesFileEntity, SysUser AMBaseUserEntity) { SqlTrans trans = new SqlTrans(); SqlConnection con = trans.TranConn();; SqlTransaction tran = trans.TransBegin(con); string role = ""; try { var AM_Base_AnnexesFile_strSql = new StringBuilder(); var AM_Base_AnnexesFile_paramList = new List <SqlParameter>(); var AM_Base_User_strSql = new StringBuilder(); var AM_Base_User_paramList = new List <SqlParameter>(); var strSql = new StringBuilder(); var paramList = new List <SqlParameter>(); AM_Base_AnnexesFile_strSql.Append("INSERT INTO AM_Base_AnnexesFile("); AM_Base_AnnexesFile_strSql.Append("F_Id,"); AM_Base_AnnexesFile_strSql.Append("F_FolderId,"); AM_Base_AnnexesFile_strSql.Append("F_FileName,"); AM_Base_AnnexesFile_strSql.Append("F_FilePath,"); AM_Base_AnnexesFile_strSql.Append("F_FileSize,"); AM_Base_AnnexesFile_strSql.Append("F_FileExtensions,"); AM_Base_AnnexesFile_strSql.Append("F_FileType,"); AM_Base_AnnexesFile_strSql.Append("F_DownloadCount,"); AM_Base_AnnexesFile_strSql.Append("F_CreateDate,"); AM_Base_AnnexesFile_strSql.Append("F_CreateUserId,"); AM_Base_AnnexesFile_strSql.Append("F_CreateUserName"); AM_Base_AnnexesFile_strSql.Append(")"); AM_Base_AnnexesFile_strSql.Append("VALUES("); AM_Base_AnnexesFile_strSql.Append("@F_Id,"); AM_Base_AnnexesFile_strSql.Append("@F_FolderId,"); AM_Base_AnnexesFile_strSql.Append("@F_FileName,"); AM_Base_AnnexesFile_strSql.Append("@F_FilePath,"); AM_Base_AnnexesFile_strSql.Append("@F_FileSize,"); AM_Base_AnnexesFile_strSql.Append("@F_FileExtensions,"); AM_Base_AnnexesFile_strSql.Append("@F_FileType,"); AM_Base_AnnexesFile_strSql.Append("@F_DownloadCount,"); AM_Base_AnnexesFile_strSql.Append("@F_CreateDate,"); AM_Base_AnnexesFile_strSql.Append("@F_CreateUserId,"); AM_Base_AnnexesFile_strSql.Append("@F_CreateUserName"); AM_Base_AnnexesFile_strSql.Append(")"); AM_Base_AnnexesFile_paramList.Add(new SqlParameter("@F_Id", AM_Base_AnnexesFile_keyValue)); AM_Base_AnnexesFile_paramList.Add(new SqlParameter("@F_FolderId", AMBaseAnnexesFileEntity.F_FolderId)); AM_Base_AnnexesFile_paramList.Add(new SqlParameter("@F_FileName", AMBaseAnnexesFileEntity.F_FileName)); AM_Base_AnnexesFile_paramList.Add(new SqlParameter("@F_FilePath", AMBaseAnnexesFileEntity.F_FilePath)); AM_Base_AnnexesFile_paramList.Add(new SqlParameter("@F_FileSize", AMBaseAnnexesFileEntity.F_FileSize)); AM_Base_AnnexesFile_paramList.Add(new SqlParameter("@F_FileExtensions", AMBaseAnnexesFileEntity.F_FileExtensions)); AM_Base_AnnexesFile_paramList.Add(new SqlParameter("@F_FileType", AMBaseAnnexesFileEntity.F_FileType)); AM_Base_AnnexesFile_paramList.Add(new SqlParameter("@F_DownloadCount", AMBaseAnnexesFileEntity.F_DownloadCount)); AM_Base_AnnexesFile_paramList.Add(new SqlParameter("@F_CreateDate", AMBaseAnnexesFileEntity.F_CreateDate)); AM_Base_AnnexesFile_paramList.Add(new SqlParameter("@F_CreateUserId", AMBaseAnnexesFileEntity.F_CreateUserId)); AM_Base_AnnexesFile_paramList.Add(new SqlParameter("@F_CreateUserName", AMBaseAnnexesFileEntity.F_CreateUserName)); SqlHelper.ExecuteNonQuery(tran, CommandType.Text, AM_Base_AnnexesFile_strSql.ToString(), AM_Base_AnnexesFile_paramList.ToArray()); AM_Base_User_strSql.Append("UPDATE AM_Base_User SET "); AM_Base_User_strSql.Append("F_EnCode=@F_EnCode,"); AM_Base_User_strSql.Append("F_Account=@F_Account,"); AM_Base_User_strSql.Append("F_Password=@F_Password,"); AM_Base_User_strSql.Append("F_Secretkey=@F_Secretkey,"); AM_Base_User_strSql.Append("F_RealName=@F_RealName,"); AM_Base_User_strSql.Append("F_NickName=@F_NickName,"); AM_Base_User_strSql.Append("F_HeadIcon=@F_HeadIcon,"); AM_Base_User_strSql.Append("F_QuickQuery=@F_QuickQuery,"); AM_Base_User_strSql.Append("F_SimpleSpelling=@F_SimpleSpelling,"); AM_Base_User_strSql.Append("F_Gender=@F_Gender,"); AM_Base_User_strSql.Append("F_Birthday=@F_Birthday,"); AM_Base_User_strSql.Append("F_Mobile=@F_Mobile,"); AM_Base_User_strSql.Append("F_Telephone=@F_Telephone,"); AM_Base_User_strSql.Append("F_Email=@F_Email,"); AM_Base_User_strSql.Append("F_OICQ=@F_OICQ,"); AM_Base_User_strSql.Append("F_WeChat=@F_WeChat,"); AM_Base_User_strSql.Append("F_MSN=@F_MSN,"); AM_Base_User_strSql.Append("F_CompanyId=@F_CompanyId,"); AM_Base_User_strSql.Append("F_DepartmentId=@F_DepartmentId,"); AM_Base_User_strSql.Append("F_SecurityLevel=@F_SecurityLevel,"); AM_Base_User_strSql.Append("F_OpenId=@F_OpenId,"); AM_Base_User_strSql.Append("F_Question=@F_Question,"); AM_Base_User_strSql.Append("F_AnswerQuestion=@F_AnswerQuestion,"); AM_Base_User_strSql.Append("F_CheckOnLine=@F_CheckOnLine,"); AM_Base_User_strSql.Append("F_AllowStartTime=@F_AllowStartTime,"); AM_Base_User_strSql.Append("F_AllowEndTime=@F_AllowEndTime,"); AM_Base_User_strSql.Append("F_LockStartDate=@F_LockStartDate,"); AM_Base_User_strSql.Append("F_LockEndDate=@F_LockEndDate,"); AM_Base_User_strSql.Append("F_SortCode=@F_SortCode,"); AM_Base_User_strSql.Append("F_DeleteMark=@F_DeleteMark,"); AM_Base_User_strSql.Append("F_EnabledMark=@F_EnabledMark,"); AM_Base_User_strSql.Append("F_Description=@F_Description,"); AM_Base_User_strSql.Append("F_CreateDate=@F_CreateDate,"); AM_Base_User_strSql.Append("F_CreateUserId=@F_CreateUserId,"); AM_Base_User_strSql.Append("F_CreateUserName=@F_CreateUserName,"); AM_Base_User_strSql.Append("F_ModifyDate=@F_ModifyDate,"); AM_Base_User_strSql.Append("F_ModifyUserId=@F_ModifyUserId,"); AM_Base_User_strSql.Append("F_ModifyUserName=@F_ModifyUserName,"); AM_Base_User_strSql.Append("U_Address=@U_Address,"); AM_Base_User_strSql.Append("D_Code=@D_Code,"); AM_Base_User_strSql.Append("R_Code=@R_Code,"); AM_Base_User_strSql.Append("F_Kind=@F_Kind,"); AM_Base_User_strSql.Append("F_RFIDCode=@F_RFIDCode,"); AM_Base_User_strSql.Append("F_Group=@F_Group,"); AM_Base_User_strSql.Append("F_Indate=@F_Indate,"); AM_Base_User_strSql.Append("F_Outdate=@F_Outdate,"); AM_Base_User_strSql.Append("F_Cert=@F_Cert,"); AM_Base_User_strSql.Append("F_Nation=@F_Nation,"); AM_Base_User_strSql.Append("F_Record=@F_Record,"); AM_Base_User_strSql.Append("F_Origin=@F_Origin,"); AM_Base_User_strSql.Append("F_Picture1=@F_Picture1,"); AM_Base_User_strSql.Append("F_Picture2=@F_Picture2,"); AM_Base_User_strSql.Append("F_Picture3=@F_Picture3,"); AM_Base_User_strSql.Append("F_Picture4=@F_Picture4,"); AM_Base_User_strSql.Append("F_Picture5=@F_Picture5 "); AM_Base_User_strSql.Append(" WHERE F_Account=@ID"); AM_Base_User_paramList.Add(new SqlParameter("@ID", AM_Base_User_keyValue)); AM_Base_User_paramList.Add(new SqlParameter("@F_EnCode", AMBaseUserEntity.F_EnCode)); AM_Base_User_paramList.Add(new SqlParameter("@F_Account", AMBaseUserEntity.F_Account)); AM_Base_User_paramList.Add(new SqlParameter("@F_Password", AMBaseUserEntity.F_Password)); AM_Base_User_paramList.Add(new SqlParameter("@F_Secretkey", AMBaseUserEntity.F_Secretkey)); AM_Base_User_paramList.Add(new SqlParameter("@F_RealName", AMBaseUserEntity.F_RealName)); AM_Base_User_paramList.Add(new SqlParameter("@F_NickName", AMBaseUserEntity.F_NickName)); AM_Base_User_paramList.Add(new SqlParameter("@F_HeadIcon", AMBaseUserEntity.F_HeadIcon)); AM_Base_User_paramList.Add(new SqlParameter("@F_QuickQuery", AMBaseUserEntity.F_QuickQuery)); AM_Base_User_paramList.Add(new SqlParameter("@F_SimpleSpelling", AMBaseUserEntity.F_SimpleSpelling)); AM_Base_User_paramList.Add(new SqlParameter("@F_Gender", AMBaseUserEntity.F_Gender)); AM_Base_User_paramList.Add(new SqlParameter("@F_Birthday", AMBaseUserEntity.F_Birthday)); AM_Base_User_paramList.Add(new SqlParameter("@F_Mobile", AMBaseUserEntity.F_Mobile)); AM_Base_User_paramList.Add(new SqlParameter("@F_Telephone", AMBaseUserEntity.F_Telephone)); AM_Base_User_paramList.Add(new SqlParameter("@F_Email", AMBaseUserEntity.F_Email)); AM_Base_User_paramList.Add(new SqlParameter("@F_OICQ", AMBaseUserEntity.F_OICQ)); AM_Base_User_paramList.Add(new SqlParameter("@F_WeChat", AMBaseUserEntity.F_WeChat)); AM_Base_User_paramList.Add(new SqlParameter("@F_MSN", AMBaseUserEntity.F_MSN)); AM_Base_User_paramList.Add(new SqlParameter("@F_CompanyId", AMBaseUserEntity.F_CompanyId)); AM_Base_User_paramList.Add(new SqlParameter("@F_DepartmentId", AMBaseUserEntity.F_DepartmentId)); AM_Base_User_paramList.Add(new SqlParameter("@F_SecurityLevel", AMBaseUserEntity.F_SecurityLevel)); AM_Base_User_paramList.Add(new SqlParameter("@F_OpenId", AMBaseUserEntity.F_OpenId)); AM_Base_User_paramList.Add(new SqlParameter("@F_Question", AMBaseUserEntity.F_Question)); AM_Base_User_paramList.Add(new SqlParameter("@F_AnswerQuestion", AMBaseUserEntity.F_AnswerQuestion)); AM_Base_User_paramList.Add(new SqlParameter("@F_CheckOnLine", AMBaseUserEntity.F_CheckOnLine)); AM_Base_User_paramList.Add(new SqlParameter("@F_AllowStartTime", AMBaseUserEntity.F_AllowStartTime)); AM_Base_User_paramList.Add(new SqlParameter("@F_AllowEndTime", AMBaseUserEntity.F_AllowEndTime)); AM_Base_User_paramList.Add(new SqlParameter("@F_LockStartDate", AMBaseUserEntity.F_LockStartDate)); AM_Base_User_paramList.Add(new SqlParameter("@F_LockEndDate", AMBaseUserEntity.F_LockEndDate)); AM_Base_User_paramList.Add(new SqlParameter("@F_SortCode", AMBaseUserEntity.F_SortCode)); AM_Base_User_paramList.Add(new SqlParameter("@F_DeleteMark", AMBaseUserEntity.F_DeleteMark)); AM_Base_User_paramList.Add(new SqlParameter("@F_EnabledMark", AMBaseUserEntity.F_EnabledMark)); AM_Base_User_paramList.Add(new SqlParameter("@F_Description", AMBaseUserEntity.F_Description)); AM_Base_User_paramList.Add(new SqlParameter("@F_CreateDate", AMBaseUserEntity.F_CreateDate)); AM_Base_User_paramList.Add(new SqlParameter("@F_CreateUserId", AMBaseUserEntity.F_CreateUserId)); AM_Base_User_paramList.Add(new SqlParameter("@F_CreateUserName", AMBaseUserEntity.F_CreateUserName)); AM_Base_User_paramList.Add(new SqlParameter("@F_ModifyDate", AMBaseUserEntity.F_ModifyDate)); AM_Base_User_paramList.Add(new SqlParameter("@F_ModifyUserId", AMBaseUserEntity.F_ModifyUserId)); AM_Base_User_paramList.Add(new SqlParameter("@F_ModifyUserName", AMBaseUserEntity.F_ModifyUserName)); AM_Base_User_paramList.Add(new SqlParameter("@U_Address", AMBaseUserEntity.U_Address)); AM_Base_User_paramList.Add(new SqlParameter("@D_Code", AMBaseUserEntity.D_Code)); AM_Base_User_paramList.Add(new SqlParameter("@R_CSCode", AMBaseUserEntity.R_CSCode)); AM_Base_User_paramList.Add(new SqlParameter("@F_Kind", AMBaseUserEntity.F_Kind)); AM_Base_User_paramList.Add(new SqlParameter("@F_RFIDCode", AMBaseUserEntity.F_RFIDCode)); AM_Base_User_paramList.Add(new SqlParameter("@F_Group", AMBaseUserEntity.F_Group)); AM_Base_User_paramList.Add(new SqlParameter("@F_Indate", AMBaseUserEntity.F_Indate)); AM_Base_User_paramList.Add(new SqlParameter("@F_Outdate", AMBaseUserEntity.F_Outdate)); AM_Base_User_paramList.Add(new SqlParameter("@F_Cert", AMBaseUserEntity.F_Cert)); AM_Base_User_paramList.Add(new SqlParameter("@F_Nation", AMBaseUserEntity.F_Nation)); AM_Base_User_paramList.Add(new SqlParameter("@F_Record", AMBaseUserEntity.F_Record)); AM_Base_User_paramList.Add(new SqlParameter("@F_Origin", AMBaseUserEntity.F_Origin)); AM_Base_User_paramList.Add(new SqlParameter("@F_Picture1", AMBaseUserEntity.F_Picture1)); AM_Base_User_paramList.Add(new SqlParameter("@F_Picture2", AMBaseUserEntity.F_Picture2)); AM_Base_User_paramList.Add(new SqlParameter("@F_Picture3", AMBaseUserEntity.F_Picture3)); AM_Base_User_paramList.Add(new SqlParameter("@F_Picture4", AMBaseUserEntity.F_Picture4)); AM_Base_User_paramList.Add(new SqlParameter("@F_Picture5", AMBaseUserEntity.F_Picture5)); SqlHelper.ExecuteNonQuery(tran, CommandType.Text, AM_Base_User_strSql.ToString(), AM_Base_User_paramList.ToArray()); strSql.Append("DELETE AM_Base_AnnexesFile"); strSql.Append(" WHERE F_Id=@ID"); paramList.Add(new SqlParameter("@ID", AM_Base_AnnexesFile_delete_keyValue)); SqlHelper.ExecuteNonQuery(tran, CommandType.Text, strSql.ToString(), paramList.ToArray()); //var result = db.ExecuteNonQuery(AM_Base_AnnexesFile_strSql.ToString(), AM_Base_AnnexesFile_paramList.ToArray()); //return result; trans.TransCommit(tran); trans.TransEnd(con); return(1); } catch (Exception) { trans.TransRollback(tran); trans.TransEnd(con); throw; } }
private void btnUploadImage_Click(object sender, EventArgs e) { try { if (file()) { string ID = Guid.NewGuid().ToString("N");//照片名称 SysUser user = new SysUser(); SysUserBLL SysUserBLL = new SysUserBLL(); AMBaseAnnexesFileEntity AMBaseAnnexesFileEntity = new AMBaseAnnexesFileEntity(); AMBaseAnnexesFileBLL AMBaseAnnexesFileBLL = new AMBaseAnnexesFileBLL(); AMBaseAnnexesFileEntity.F_Id = ID; AMBaseAnnexesFileEntity.F_FolderId = Guid.NewGuid().ToString(); AMBaseAnnexesFileEntity.F_FileName = Path.GetFileName(imagefile);//获取文件名和扩展名 AMBaseAnnexesFileEntity.F_FilePath = "D:/fileAnnexes/shop_erp/System/" + DateTime.Now.ToString("yyyyMMdd") + "/" + AMBaseAnnexesFileEntity.F_Id; AMBaseAnnexesFileEntity.F_FileSize = fileInfoLength; AMBaseAnnexesFileEntity.F_FileExtensions = Path.GetExtension(imagefile); //获取文件扩展名 AMBaseAnnexesFileEntity.F_FileType = imagefile.Substring(imagefile.LastIndexOf(".") + 1); // Path.GetExtension(imagefile).Substring(0, 1); //AMBaseAnnexesFileEntity.F_DownloadCount = ""; AMBaseAnnexesFileEntity.F_CreateDate = DateTime.Now; AMBaseAnnexesFileEntity.F_CreateUserId = SysUser.F_Account.ToString(); AMBaseAnnexesFileEntity.F_CreateUserName = SysUser.F_RealName.ToString(); user.F_Account = PrimaryKey; switch (cmbImage.Text) { case "照片1": user.F_Picture1 = AMBaseAnnexesFileEntity.F_Id; break; case "照片2": user.F_Picture2 = AMBaseAnnexesFileEntity.F_Id; break; case "照片3": user.F_Picture3 = AMBaseAnnexesFileEntity.F_Id; break; case "照片4": user.F_Picture4 = AMBaseAnnexesFileEntity.F_Id; break; case "照片5": user.F_Picture5 = AMBaseAnnexesFileEntity.F_Id; break; } //Computer MyComputer = new Computer(); //imagefile = System.AppDomain.CurrentDomain.BaseDirectory; //MyComputer.FileSystem.RenameFile(imagefile, image);//imagefile是所要重命名的文件的全路径,image是目标文件名 //image = Path.GetFileNameWithoutExtension(imagefile);// 没有扩展名的文件名 //FaceRecognition.Get_zjdz(imagefile); string str = FaceRecognition.ImageToBase64(imagefile); if (AMBaseAnnexesFileBLL.SaveEntity("", AMBaseAnnexesFileEntity) > 0) { if (SysUserBLL.Edit(user) > 0) { MesDeviceBLL MesDeviceBLL = new MesDeviceBLL(); var MesDevice = MesDeviceBLL.GetList_Deparemaent(D_Code.Text, ""); user = SysUserBLL.getDetail(PrimaryKey); string url = "http://" + MesDevice[0].D_IP + ":8090/person/create"; string postData = "pass=12345678&personId=" + user.F_EnCode + "&faceId=" + ID + "&imgBase64" + str + ""; string strtemp = FaceRecognition.Port(url, postData); if (!FaceRecognition.json(strtemp)) { untCommon.InfoMsg("该IP地址不可用!"); return; } JObject joModel = (JObject)JsonConvert.DeserializeObject(strtemp); if (!bool.Parse(joModel["success"].ToString())) { untCommon.InfoMsg(joModel["msg"].ToString()); return; } else { untCommon.InfoMsg("人脸识别注册成功!"); } switch (cmbImage.Text) { case "照片1": AMBaseAnnexesFileBLL.DeleteEntity(user.F_Picture1); break; case "照片2": AMBaseAnnexesFileBLL.DeleteEntity(user.F_Picture2); break; case "照片3": AMBaseAnnexesFileBLL.DeleteEntity(user.F_Picture3); break; case "照片4": AMBaseAnnexesFileBLL.DeleteEntity(user.F_Picture4); break; case "照片5": AMBaseAnnexesFileBLL.DeleteEntity(user.F_Picture5); break; } } else { untCommon.InfoMsg("上传失败!"); } } else { untCommon.InfoMsg("上传失败!"); } //string url = "183.236.45.60"; //if (FaceRecognition.uploadFileByHttp(url, imagefile)) //{ //} } } catch (Exception ex) { untCommon.ErrorMsg("照片上传失败!"); } }
/// <summary> /// 初始化页面数据 /// </summary> private void getDetail() { try { SysUserBLL userbll = new SysUserBLL(); SysUser user = userbll.getDetail(PrimaryKey); AMBaseAnnexesFileBLL AMBaseAnnexesFileBLL = new AMBaseAnnexesFileBLL(); AMBaseAnnexesFileEntity AMBaseAnnexesFileEntity = AMBaseAnnexesFileBLL.GetEntity(user.F_Picture1); department = user.D_Code; strTeamCode = user.F_TeamCode; role = user.R_CSCode; F_Account.Text = user.F_Account; F_RealName.Text = user.F_RealName; F_Password.Text = "******";//user.F_Password ; F_Gender.SelectedItem = user.F_Gender == 1 ? "男" : "女"; F_Kind.Text = "正式工"; cmbImage.Text = "照片1"; D_Code.Text = department; if (role != null) { R_Code.SelectedValue = role; } if (strTeamCode != null) { cmbTeam.SelectedValue = strTeamCode; } F_Mobile.Text = user.F_Mobile; F_Email.Text = user.F_Email; F_OICQ.Text = user.F_OICQ; F_WeChat.Text = user.F_WeChat; F_Indate.Text = user.F_Indate.ToString(); F_Outdate.Text = user.F_Outdate.ToString(); U_Address.Text = user.U_Address; F_Description.Text = user.F_Description; F_EnabledMark.Checked = user.F_EnabledMark; F_CreateUserName.Text = user.F_CreateUserName; F_ModifyUserName.Text = user.F_ModifyUserName; switch (user.F_Kind) { case 1: F_Kind.Text = "正式工"; break; case 2: F_Kind.Text = "临时工"; break; case 3: F_Kind.Text = "劳务工"; break; } //switch (cmbImage.Text) //{ // case "照片1": // txtImageFile.Text = AMBaseAnnexesFileEntity.F_FilePath; // break; // case "照片2": // txtImageFile.Text = AMBaseAnnexesFileEntity.F_FilePath; // break; // case "照片3": // txtImageFile.Text = AMBaseAnnexesFileEntity.F_FilePath; // break; // case "照片4": // txtImageFile.Text = AMBaseAnnexesFileEntity.F_FilePath; // break; // case "照片5": // txtImageFile.Text = AMBaseAnnexesFileEntity.F_FilePath; // break; //} F_RFIDCode.Text = user.F_RFIDCode; //user.F_Indate = F_Indate.Text; //user.F_Outdate = F_Outdate.Text; F_Cert.Text = user.F_Cert; F_Nation.Text = user.F_Nation; F_Record.Text = user.F_Record; F_Origin.Text = user.F_Origin; //照片显示 //AMBaseAnnexesFileEntity = AMBaseAnnexesFileBLL.GetEntity(user.F_Picture1); //string strPath = System.AppDomain.CurrentDomain.BaseDirectory + AMBaseAnnexesFileEntity.F_FilePath; //string strPath = "http://183.236.45.60:7001/picture/" + 10006.jpg"; string strPath = Application.StartupPath + "\\img\\" + user.F_Account + ".jpg"; string url = "http://183.236.45.60:7001/picture/" + user.F_Account + ".jpg"; Down(strPath, url); if (File.Exists(strPath)) { FileStream fs = new FileStream(strPath, FileMode.Open, FileAccess.Read); Byte[] mybyte = new byte[fs.Length]; fs.Read(mybyte, 0, mybyte.Length); fs.Close(); MemoryStream ms = new MemoryStream(mybyte); Bitmap myimge = new Bitmap(ms); pictureBox1.Image = myimge; } if (user.F_CreateDate.HasValue) { F_CreateDate.Value = user.F_CreateDate.Value; } else { F_CreateDate.Value = DateTime.Now; } if (user.F_ModifyDate.HasValue) { F_ModifyDate.Value = user.F_ModifyDate.Value; } else { F_ModifyDate.Value = DateTime.Now; } } catch (Exception ex) { untCommon.ErrorMsg("用户管理加载数据异常:" + ex.Message); } }