// public dynamic GetModel(int id) { try { dynamic model = null; string strSql = string.Format(" select Id,FK_LiceTranId,FK_UploadTypeIndicatorId,ScanUrl,UploadName,UploadDate from T_LiceTranScan where Id = {0}", id); using (dynamic read = DbHelperSQL.ExecuteReader(strSql)) { if (read.Read()) { model = new LiceTranScan(); try { model.Id = int.Parse(read["Id"].ToString()); } catch { } model.FK_LiceTranId = int.Parse(read["FK_LiceTranId"].ToString()); model.FK_UploadTypeIndicatorId = int.Parse(read["FK_UploadTypeIndicatorId"].ToString()); model.ScanUrl = read["ScanUrl"].ToString(); model.UploadName = read["UploadName"].ToString(); model.UploadDate = DateTime.Parse(read["UploadDate"].ToString()); } read.Dispose(); } return(model); } catch { throw; } }
// private dynamic Delete(HttpContext context) { try { SysLogBll.Create("出让/受让方上传附件", "删除出让/受让方上传附件操作", adminUser.AdminName); int Id = 0; try { Id = int.Parse(context.Request.QueryString["Id"].ToString()); } catch { } if (dal.Exists(Id)) { LiceTranScan obj = dal.GetModel(Id); if (dal.Delete(Id)) { Component.DeleteImg("~/Super/Scan/lt/" + obj.FK_LiceTranId + "/" + obj.ScanUrl); return("删除成功!"); } else { return("删除失败请重新操作! "); } } else { return("数据已经开始受理中无法删除操作!"); } } catch (Exception ex) { SystemErrorPlug.ErrorRecord("时间:[" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "]类名:[" + this.GetType().Name + "],行号:[" + Component.GetLineNum().ToString() + "行],错误信息:[" + ex.Message + "]"); return("删除失败请重新操作,错误代码:500 "); } }
// private dynamic GetModels(HttpContext context) { LiceTranScan model = new LiceTranScan(); try { model.Id = int.Parse(context.Request.Form["Id"].ToString()); } catch { } model.FK_LiceTranId = int.Parse(context.Request.Form["FK_LiceTranId"].ToString()); model.FK_UploadTypeIndicatorId = int.Parse(context.Request.Form["FK_UploadTypeIndicatorId"].ToString()); string ImgName = new UpLoadImgPlug().UploadImg("~/Super/Scan/lt/" + model.FK_LiceTranId + "/", 0); string imgUrl = HttpContext.Current.Server.MapPath("~/Super/Scan/lt/" + model.FK_LiceTranId + "/" + ImgName); string pdfUrl = "~/Super/Scan/lt/" + model.FK_LiceTranId + "/"; new ProducePdfPlug().CreatePdf(imgUrl, pdfUrl, ImgName.Split('.')[0] + ".pdf"); model.ScanUrl = ImgName.Split('.')[0] + ".pdf"; model.UploadName = UserName; model.UploadDate = DateTime.Now; return(model); }
// private SqlParameter[] GetSqlParameter(LiceTranScan model) { SqlParameter[] parameters = { new SqlParameter("@FK_LiceTranId", SqlDbType.Int, 4), new SqlParameter("@FK_UploadTypeIndicatorId", SqlDbType.Int, 4), new SqlParameter("@ScanUrl", SqlDbType.NVarChar, 100), new SqlParameter("@UploadName", SqlDbType.NVarChar, 100), new SqlParameter("@UploadDate", SqlDbType.DateTime), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.FK_LiceTranId; parameters[1].Value = model.FK_UploadTypeIndicatorId; parameters[2].Value = model.ScanUrl; parameters[3].Value = model.UploadName; parameters[4].Value = model.UploadDate; parameters[5].Value = model.Id; return(parameters); }
// public bool Create(LiceTranScan model) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_LiceTranScan("); strSql.Append("FK_LiceTranId,FK_UploadTypeIndicatorId,ScanUrl,UploadName,UploadDate)"); strSql.Append(" values ("); strSql.Append("@FK_LiceTranId,@FK_UploadTypeIndicatorId,@ScanUrl,@UploadName,@UploadDate)"); if (DbHelperSQL.ExecuteSql(strSql.ToString(), GetSqlParameter(model)) > 0) { return(true); } else { return(false); } } catch { throw; } }
// public bool Update(LiceTranScan model) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_LiceTranScan set "); strSql.Append("FK_LiceTranId=@FK_LiceTranId,"); strSql.Append("FK_UploadTypeIndicatorId=@FK_UploadTypeIndicatorId,"); strSql.Append("ScanUrl=@ScanUrl,"); strSql.Append("UploadName=@UploadName,"); strSql.Append("UploadDate=@UploadDate"); strSql.Append(" where Id=@Id"); if (DbHelperSQL.ExecuteSql(strSql.ToString(), GetSqlParameter(model)) > 0) { return(true); } else { return(false); } } catch { throw; } }
protected void Button1_Click(object sender, EventArgs e) { AdminUser adminUser = Session["SuperAdminUserSession"] as AdminUser; if (this.FileUpload1.HasFile) { string strtype = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower();//ToLower转化为小写 if (strtype == ".jpg" || strtype == ".gif" || strtype == ".jpeg" || strtype == ".png" || strtype == ".pdf") { //获得上传文件的大小 int filesize = FileUpload1.PostedFile.ContentLength; if (filesize > 1024 * 1024 * 25) { MessageBox.Show(this, "你上传的文件太大!"); return; } else { LiceTranScan model = new LiceTranScan(); try { } catch { } try { model.FK_LiceTranId = int.Parse(Request.QueryString["p"]); } catch { } model.FK_UploadTypeIndicatorId = int.Parse(this.txtFK_UploadTypeIndicatorId.SelectedValue); string strname = Guid.NewGuid().ToString("N") + System.IO.Path.GetExtension(FileUpload1.FileName); string strpath = Server.MapPath("~/Super/Scan/lt/" + model.FK_LiceTranId + ""); if (!System.IO.Directory.Exists(strpath)) { System.IO.Directory.CreateDirectory(strpath); } FileUpload1.SaveAs(strpath + "/" + strname); //string ImgName = new UpLoadImgPlug().UploadImg("~/Super/Scan/lt/" + model.FK_LiceTranId + "/", 0); //string imgUrl = HttpContext.Current.Server.MapPath("~/Super/Scan/lt/" + model.FK_LiceTranId + "/" + ImgName); //string pdfUrl = "~/Super/Scan/lt/" + model.FK_LiceTranId + "/"; //new ProducePdfPlug().CreatePdf(imgUrl, pdfUrl, ImgName.Split('.')[0] + ".pdf"); model.ScanUrl = strname; model.UploadName = adminUser.AdminName; model.UploadDate = DateTime.Now; try { SysLogBll.Create("出让/受让方上传附件", "增加出让/受让方上传附件操作", adminUser.AdminName); LiceTranScanDal dal = new LiceTranScanDal(); if (dal.Create(model)) { MessageBox.Show(this, "上传成功。"); } else { MessageBox.Show(this, "上传失败,请重新操作! "); } } catch (Exception ex) { SystemErrorPlug.ErrorRecord("时间:[" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "]类名:[" + this.GetType().Name + "],行号:[" + Component.GetLineNum().ToString() + "行],错误信息:[" + ex.Message + "]"); MessageBox.Show(this, "添加失败请重新操作,错误代码:500 "); } } } else { MessageBox.Show(this, "上传的附件格式后缀名只能为.jpg,.gif,.jpeg,.png,.pdf,其他格式暂不允许上传"); return; } } else { MessageBox.Show(this, "请选择附件进行上传"); return; } }