/// <summary>
/// 得到一个实体对象
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public static Model.ContractApplication GetModel(string id)
{
string strSql = "select * from ContractApplication where ID='" + id + "' ";
Model.ContractApplication model = new Model.ContractApplication();
DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString);
if (ds.Tables[0].Rows.Count > 0)
{
model.ID = Convert.ToString(ds.Tables[0].Rows[0]["ID"]);
model.UserName = Convert.ToString(ds.Tables[0].Rows[0]["UserName"]);
model.Contacts = Convert.ToString(ds.Tables[0].Rows[0]["Contacts"]);
model.Phone = Convert.ToString(ds.Tables[0].Rows[0]["Phone"]);
model.Address = Convert.ToString(ds.Tables[0].Rows[0]["Address"]);
model.ContractFile = Convert.ToString(ds.Tables[0].Rows[0]["ContractFile"]);
model.Type = Convert.ToString(ds.Tables[0].Rows[0]["Type"]);
model.Price = Convert.ToString(ds.Tables[0].Rows[0]["Price"]);
model.ApplicationTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["ApplicationTime"]);
model.Remark = Convert.ToString(ds.Tables[0].Rows[0]["Remark"]);
return(model);
}
else
{
return(null);
}
}
protected void Unnamed1_Click(object sender, EventArgs e)
{
//try
//{
// string fullPathUrl = Server.MapPath(aaPh);//获取下载文件的路劲
// System.IO.FileInfo file = new System.IO.FileInfo(fullPathUrl);
// if (file.Exists)//判断文件是否存在
// {
// Response.Clear();
// Response.ClearHeaders();
// Response.Buffer = false;
// Response.AddHeader("content-disposition", "attachment;filename=" + file.Name);
// Response.AddHeader("cintent_length", "attachment;filename=" + HttpUtility.UrlDecode(file.Name));
// Response.AddHeader("cintent_length", file.Length.ToString());
// Response.ContentType = "application/octet-stream";
// Response.WriteFile(file.FullName);//通过response对象，执行下载操作
// Response.Flush();
// Response.End();
// }
// else
// {
// ScriptManager.RegisterStartupScript(this, this.GetType(), "dd", "alert('文件不存在')", true);
// }
//}
//catch
//{
// ScriptManager.RegisterStartupScript(this, this.GetType(), "dd", "alert('下载成功')", true);
//}
Model.ContractApplication contractApplication = new Model.ContractApplication();
Model.InvoiceList invoiceList = DAL.InvoiceList.GetModel(Convert.ToInt32(Session["id"]));
invoiceList.ContractStatus = 4;
DAL.InvoiceList.Update(invoiceList);
string num = cs.VerifyCodeHelper.Number(4, true);
contractApplication.ID = invoiceList.UserName + DateTime.Now.Year + "0" + DateTime.Now.Month + num;
contractApplication.UserName = invoiceList.UserName;
string id = contractApplication.ID;
contractApplication.Address = this.address.Value;
contractApplication.Contacts = this.contacts.Value;
contractApplication.Phone = this.phone.Value;
contractApplication.Price = invoiceList.Price;
contractApplication.Type = "0";
string aaPh = "/upload/Invoice/合同.docx";
// System.IO.FileInfo file = new System.IO.FileInfo(aaPh);
//contractApplication.ContractFile = file;
contractApplication.ContractFile = aaPh;
DAL.ContractApplication.Add(contractApplication);
Response.Redirect("EndContract.aspx?ID=" + id + "");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserName"] == null || Session["UserType"] == null || Convert.ToInt32(Session["UserType"]) < 0 || Convert.ToInt32(Session["UserType"]) > 5)
{
Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/forms/publicforms/Login/Login.aspx\";</script>");
Response.End();
}
if (Request["action"] != null && Request["action"] == "GetData")
{
if (!Get_invoice())
{
Response.Write("0");
}
}
if (Request["action"] != null && Request["action"] == "DeleteCors")
{
DeleteCors();
}
if (Request["invoiceListId"] != null)
{
string invoiceListID = Request["invoiceListID"].ToString();
Model.InvoiceList invoiceList = DAL.InvoiceList.GetModel(Convert.ToInt32(Request["invoiceListID"]));
invoiceList.ContractStatus = 2;
DAL.InvoiceList.Update(invoiceList);
Response.Write("success");
Response.End();
}
if (Request["action"] != null && Request["action"] == "downloadfile")
{
string ID = Request["id"].ToString();
Model.ContractApplication contract = DAL.ContractApplication.GetModel(ID);
if (contract.UserName != Session["UserName"].ToString())
{
Response.End();
}
else
{
//string fileName = invoiceList.InvoiceFile;//客户端保存的文件名
//string filePath = Server.MapPath("DownLoad/aaa.txt");//路径
string filePath = this.Server.MapPath(contract.ContractFile);//文件路径，可用相对路径
FileInfo fileInfo = new FileInfo(filePath);
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode(fileInfo.Name.ToString()));
Response.AddHeader("Content-Length", fileInfo.Length.ToString());
Response.AddHeader("Content-Transfer-Encoding", "binary");
Response.ContentType = "application/octet-stream";
Response.ContentEncoding = System.Text.Encoding.Default;
Response.WriteFile(fileInfo.FullName);
Response.Flush();
Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["ID"] != "" && Request["ID"] != null)
{
Session["id"] = Request.QueryString["ID"].ToString();
Model.ContractApplication contractApplication = DAL.ContractApplication.GetModel(Session["id"].ToString());
ContractId.Text = contractApplication.ID;
}
if (Request["action"] != null && Request["action"] == "DownloadAll")
{
DownloadAll();
}
}
public static bool Update1(Model.ContractApplication model)
{
string strSql = "update ContractApplication set UserName=@UserName, Contacts=@Contacts, Phone=@Phone, Address=@Address, ContractFile=@ContractFile,Type=@Type,Price=@Price,ApplicationTime=@ApplicationTime,Remark=@Remark where ID = '" + model.ID.Trim().ToString() + "'";
SqlParameter UserName = new SqlParameter("UserName", SqlDbType.NVarChar); UserName.Value = model.UserName;
SqlParameter Contacts = new SqlParameter("Contacts", SqlDbType.NVarChar); Contacts.Value = model.Contacts;
SqlParameter Phone = new SqlParameter("Phone", SqlDbType.NVarChar); Phone.Value = model.Phone;
SqlParameter Address = new SqlParameter("Address", SqlDbType.NVarChar); Address.Value = model.Address;
SqlParameter ContractFile = new SqlParameter("ContractFile", SqlDbType.NVarChar); ContractFile.Value = model.ContractFile;
SqlParameter Type = new SqlParameter("Type", SqlDbType.NVarChar); Type.Value = model.Type;
SqlParameter Price = new SqlParameter("Price", SqlDbType.NVarChar); Price.Value = model.Price;
SqlParameter ApplicationTime = new SqlParameter("ApplicationTime", SqlDbType.NVarChar); ApplicationTime.Value = model.ApplicationTime;
SqlParameter Remark = new SqlParameter("Remark", SqlDbType.NVarChar); Remark.Value = model.Remark;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { UserName, Contacts, Phone, Address, ContractFile, Type, Price, ApplicationTime, Remark }, connectionString) == 1 ? true : false);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Num.Value = Request.QueryString["id"].ToString();
Session["ContractID"] = Request.QueryString["id"].ToString();
Model.ContractApplication contractApplication = DAL.ContractApplication.GetModel(Session["ContractID"].ToString());
phone.Value = contractApplication.Phone;
string SMS = "http://39.108.107.73:8090/sysmonitor/services/monitor/sendmessage.json?key=is8ji3&phone=@phone&message=@message";
Session["num"] = cs.VerifyCodeHelper.Number(4, true);
string message = "您的短信验证码为：" + Session["num"] + "，用于正式合同转换，为保证信息安全，请勿将验证码告知他人";
SMS = SMS.Replace("@message", message);
SMS = SMS.Replace("@phone", contractApplication.Phone);
if (cs.HttpHelper.SendSMS(SMS))
{
}
else
{
cs.WebLogger.WriteErroLog("注册短信发送错误"); //输出到文件中
}
}
if (Request["action"] == "register")
{
Model.ContractApplication contractApplication = DAL.ContractApplication.GetModel(Session["ContractID"].ToString());
string user = Request.Form["userPhone"].ToString();
string userNum = Session["num"].ToString();
if (Request.Form["userPhone"] == Session["num"].ToString())
{
contractApplication.Type = "1";
DAL.ContractApplication.Update1(contractApplication);
Response.Write("1");
Response.End();
}
}
}
/// <summary>
/// 增加一个单位信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Add(Model.ContractApplication model)
{
string strSql = "insert into ContractApplication(ID,UserName,Contacts,Phone,Address,Price,ContractFile,Type,ApplicationTime,Remark) values(@ID,@UserName,@Contacts,@Phone,@Address,@Price,@ContractFile,@Type,@ApplicationTime,@Remark)";
SqlParameter ID = new SqlParameter("ID", SqlDbType.NVarChar); ID.Value = model.ID;
SqlParameter UserName = new SqlParameter("UserName", SqlDbType.NVarChar); UserName.Value = model.UserName;
SqlParameter Contacts = new SqlParameter("Contacts", SqlDbType.NVarChar); Contacts.Value = model.Contacts;
SqlParameter Phone = new SqlParameter("Phone", SqlDbType.NVarChar); Phone.Value = model.Phone;
SqlParameter Address = new SqlParameter("Address", SqlDbType.NVarChar); Address.Value = model.Address;
SqlParameter Price = new SqlParameter("Price", SqlDbType.NVarChar); Price.Value = model.Price;
SqlParameter ContractFile = new SqlParameter("ContractFile", SqlDbType.NVarChar); ContractFile.Value = model.ContractFile;
SqlParameter Type = new SqlParameter("Type", SqlDbType.NVarChar); Type.Value = model.Type;
SqlParameter ApplicationTime = new SqlParameter("ApplicationTime", SqlDbType.NVarChar); ApplicationTime.Value = model.ApplicationTime;
SqlParameter Remark = new SqlParameter("Remark", SqlDbType.NVarChar); Remark.Value = model.Remark;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { ID, UserName, Contacts, Phone, Address, Price, ContractFile, Type, ApplicationTime, Remark }, connectionString) == 1 ? true : false);
}
private void DownloadAll()
{
if (Session["UserName"] == null)
{
}
else
{
Model.ContractApplication contractApplication = DAL.ContractApplication.GetModel(Session["id"].ToString());
try
{
string fullPathUrl = Server.MapPath(contractApplication.ContractFile); //获取下载文件的路劲
System.IO.FileInfo file = new System.IO.FileInfo(fullPathUrl);
if (file.Exists) //判断文件是否存在
{
Response.Clear();
Response.ClearHeaders();
Response.Buffer = false;
Response.AddHeader("content-disposition", "attachment;filename=" + file.Name);
Response.AddHeader("cintent_length", "attachment;filename=" + HttpUtility.UrlDecode(file.Name));
Response.AddHeader("cintent_length", file.Length.ToString());
Response.ContentType = "application/octet-stream";
Response.WriteFile(file.FullName);//通过response对象，执行下载操作
Response.Flush();
Response.End();
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "dd", "alert('文件不存在')", true);
}
}
catch
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "dd", "alert('下载成功')", true);
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Model.ContractApplication contractApplication = DAL.ContractApplication.GetModel(Session["id"].ToString());
Response.Redirect("FormalContract.aspx?id=" + contractApplication.ID);
}
