using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;
public partial class DriverInfo : System.Web.UI.Page
{
string FilePath ="~//Photo//";
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
public string UploadPhoto()//上传照片到指定目录
{
string stringPhoto = System.DateTime.Now.ToString("yyyymmddhhMMssfff") + ".jpg";//取系统当前时间微秒为上传文件名称
if (FileUploadPhoto.HasFile)
{
FileUploadPhoto.SaveAs(Server.MapPath(FilePath.ToString().Trim() + stringPhoto));//FilePath.ToString().Trim()+ stringPhoto);//保存司机图片
return stringPhoto;
}
else
{
Response.Write("<script>alert('没有选择司机照片');history.back()</script>");
return null;
}
}
public bool GetDriverInfo()//查询司机信息是否已经存在
{
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
conn.Open();
string StrGetDriver = "SELECT SJID FROM DriverInfo where SJID='" + TxtSJID.Text.ToString().Trim() + "'";
SqlCommand comm = new SqlCommand(StrGetDriver, conn);
SqlDataReader dr = comm.ExecuteReader();
if (dr.Read())
{
Response.Write("<script>alert('该司机信息已经存在!')</script>");
conn.Close();
return false;
}
else
{
conn.Close();
return true;
}
}
protected void UpdatePhoto_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);//建立数据源
if (FileUploadPhoto.HasFile)
{
string GetPhotoName = UploadPhoto();//取得照片名字,并上传照片
try
{
conn.Open();
SqlCommand UpdateDriverPhoto = new SqlCommand("UpdateDriverPhoto",conn);
UpdateDriverPhoto.CommandType = CommandType.StoredProcedure;
UpdateDriverPhoto.Parameters.Add("@SJID",SqlDbType.Char);//司机编码
UpdateDriverPhoto.Parameters.Add("@NewSJPhoto", SqlDbType.Char);//新司机照片
UpdateDriverPhoto.Parameters.Add("@OldSJPhoto",SqlDbType.Char,40);//旧司机照片
UpdateDriverPhoto.Parameters["@SJID"].Value = TxtSJID.Text.ToString().Trim();
UpdateDriverPhoto.Parameters["@NewSJPhoto"].Value = GetPhotoName.Trim();
UpdateDriverPhoto.Parameters["@OldSJPhoto"].Direction = ParameterDirection.Output;//输出参数
UpdateDriverPhoto.ExecuteNonQuery();//更新照片信息
string Message = "成功更新司机照片" + TxtSJID.Text.ToString().Trim();//消息内容
string UserName = Session["username"].ToString().Trim();
ClassDataProcess.AddAudit(UserName, Message.Trim());//增加审计信息
//string OldSJPhoto = UpdateDriverPhoto.Parameters["@OldSJPhoto"].Value.ToString().Trim();//老照片名称
/*string FileName = FilePath.ToString().Trim() + OldSJPhoto.Trim();//上传图片服务器路径
if (FileName!=null)
{
System.IO.File.Delete(FileName);
}*/
Response.Write("<script>alert('司机照片更改成功!')</script>");
}
catch (SqlException ex)
{
throw ex;//抛出异常
}
finally
{
conn.Close();
}
}
}
}