protected void ImageButton1_Click(object sender, EventArgs e)
{
//判断名称是否唯一性
if (ZWL.Common.PublicMethod.IFExists("YinZhangName", "ERPYinZhang", 0, this.TextBox1.Text) == false)
{
ZWL.Common.MessageBox.Show(this, "该印章名称已经存在！");
return;
}
string FileNameStr = ZWL.Common.PublicMethod.UploadFileIntoDir(this.FileUpload1, DateTime.Now.Ticks.ToString() + System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName));
if (FileNameStr.Trim().Length > 0)
{
ZWL.BLL.ERPYinZhang MyModel = new ZWL.BLL.ERPYinZhang();
MyModel.ImgPath = FileNameStr;
MyModel.TimeStr = DateTime.Now;
MyModel.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyModel.YinZhangLeiBie = Request.QueryString["Type"].ToString();
MyModel.YinZhangMiMa = this.TextBox2.Text;
MyModel.YinZhangName = this.TextBox1.Text;
MyModel.Add();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户添加印章信息(" + this.TextBox1.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "印章信息添加成功！", "PublicSeal.aspx?Type=" + Request.QueryString["Type"].ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPYinZhang MyModel = new ZWL.BLL.ERPYinZhang();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.Image1.ImageUrl = "../UploadFile/" + MyModel.ImgPath;
this.Label1.Text = MyModel.YinZhangName;
this.Label2.Text = MyModel.YinZhangMiMa;
}
}
public void DataBindToGridview()
{
ZWL.BLL.ERPYinZhang MyModel = new ZWL.BLL.ERPYinZhang();
if (Request.QueryString["Type"].ToString() == "公共印章")
{
GVData.DataSource = MyModel.GetList("YinZhangName Like '%" + this.TextBox1.Text + "%' and YinZhangLeiBie='公共印章' order by ID desc");
}
else
{
GVData.DataSource = MyModel.GetList("YinZhangName Like '%" + this.TextBox1.Text + "%' and YinZhangLeiBie='私人印章' and UserName='******' order by ID desc");
}
GVData.DataBind();
LabPageSum.Text = Convert.ToString(GVData.PageCount);
LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1));
this.GoPage.Text = LabCurrentPage.Text.ToString();
}
protected void Button2_Click(object sender, EventArgs e)
{
DataSet MYDTDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select UserName from ERPUser");
for (int i = 0; i < MYDTDT.Tables[0].Rows.Count; i++)
{
string filePath = Server.MapPath("../UpLoadFile/" + MYDTDT.Tables[0].Rows[i]["UserName"].ToString() + "") + ".jpg"; //文件路径
if (System.IO.File.Exists(filePath))//判断文件是否存在
{
ZWL.BLL.ERPYinZhang MyModel = new ZWL.BLL.ERPYinZhang();
MyModel.ImgPath = MYDTDT.Tables[0].Rows[i]["UserName"].ToString()+".jpg";
MyModel.TimeStr = DateTime.Now;
MyModel.UserName = MYDTDT.Tables[0].Rows[i]["UserName"].ToString();
MyModel.YinZhangLeiBie = "私人印章";
MyModel.YinZhangMiMa = "123456";
MyModel.YinZhangName = MYDTDT.Tables[0].Rows[i]["UserName"].ToString()+"个人签名";
MyModel.Add();
}
}
}
public void DataBindToGridview()
{
GVData.PageSize = AspNetPager1.PageSize;
GVData.PageIndex = AspNetPager1.CurrentPageIndex - 1;
ZWL.BLL.ERPYinZhang MyModel = new ZWL.BLL.ERPYinZhang();
DataSet ds = new DataSet();
if (Request.QueryString["Type"].ToString() == "公共印章")
{
ds = MyModel.GetList("YinZhangName Like '%" + this.TextBox1.Text + "%' and YinZhangLeiBie='公共印章' order by ID desc");
}
else
{
ds = MyModel.GetList("YinZhangName Like '%" + this.TextBox1.Text + "%' and YinZhangLeiBie='私人印章' and UserName='******' order by ID desc");
}
GVData.DataSource = ds;
GVData.DataBind();
AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;
}
protected void Button2_Click(object sender, EventArgs e)
{
DataSet MYDTDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select UserName from ERPUser");
for (int i = 0; i < MYDTDT.Tables[0].Rows.Count; i++)
{
string filePath = Server.MapPath("../UpLoadFile/" + MYDTDT.Tables[0].Rows[i]["UserName"].ToString() + "") + ".jpg"; //文件路径
if (System.IO.File.Exists(filePath)) //判断文件是否存在
{
ZWL.BLL.ERPYinZhang MyModel = new ZWL.BLL.ERPYinZhang();
MyModel.ImgPath = MYDTDT.Tables[0].Rows[i]["UserName"].ToString() + ".jpg";
MyModel.TimeStr = DateTime.Now;
MyModel.UserName = MYDTDT.Tables[0].Rows[i]["UserName"].ToString();
MyModel.YinZhangLeiBie = "私人印章";
MyModel.YinZhangMiMa = "123456";
MyModel.YinZhangName = MYDTDT.Tables[0].Rows[i]["UserName"].ToString() + "个人签名";
MyModel.Add();
}
}
}