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);
}
}