public ActionResult package()
{
string id = Request["file"];
using (var file = new SOSOshop.BLL.Report.Qualification().GetPackageFile(id, Public.GetUserId()))
{
return(File(file.ToArray(), "application/x-zip-compressed", DateTime.Now.ToString("yyyy-MM-dd") + ".zip"));
}
}
//分页数据初始化
protected override void StartLoad(int PageIndex, string strWhere)
{
int recordCount, pageCount;
AspNetPager1.PageSize = 10;
System.Text.StringBuilder sb = new StringBuilder();
if (!string.IsNullOrEmpty(TextBox1.Text))
{
sb.AppendFormat(" and Product_Name like('%{0}%')", Library.Lang.Input.Filter(TextBox1.Text));
}
if (!string.IsNullOrEmpty(TextBox2.Text))
{
sb.AppendFormat(" and DrugsBase_Manufacturer like('%{0}%')", Library.Lang.Input.Filter(TextBox2.Text));
}
if (!string.IsNullOrEmpty(TextBox3.Text))
{
sb.AppendFormat(" and DrugsBase_ApprovalNumber like('%{0}%')", Library.Lang.Input.Filter(TextBox3.Text));
}
if (DropDownList1.SelectedValue == "1")
{
sb.Append(" and Product_ID in (SELECT Product_ID FROM dbo.product_online_v)");
}
else if (DropDownList1.SelectedValue == "2")
{
sb.Append(" and Product_ID not in (SELECT Product_ID FROM dbo.product_online_v)");
}
SOSOshop.BLL.Report.Qualification blldtr = new SOSOshop.BLL.Report.Qualification();
if (DropDownList2.SelectedValue == "1")
{
string ids = blldtr.GetProducts_Id();
if (ids == "")
{
ids = "-1";
}
sb.AppendFormat(" and Product_ID in ({0})", ids);
}
else if (DropDownList2.SelectedValue == "2")
{
string ids = blldtr.GetProducts_Id();
if (ids == "")
{
ids = "-1";
}
sb.AppendFormat(" and Product_ID not in ({0})", ids);
}
var dt = bll.GetListByPage("Product", "*,0 is_ZYC", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, "Product_id desc", sb.ToString(), out recordCount, out pageCount);
tablist.DataSource = dt;
AspNetPager1.RecordCount = recordCount;
tablist.DataBind();
}
/// <summary>
/// 上传药检报告
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SearchManage_Click(object sender, EventArgs e)
{
if (!isAdd())
{
Library.Client.Jscript.Alert(this.Page, "您没有添加权限!");
return;
}
DateTime outOfDate = DateTime.MinValue;
if (!DateTime.TryParse(txtoutOfDate.Text, out outOfDate))
{
if (txtoutOfDate.Text.Length == 8)
{
string time = txtoutOfDate.Text.Substring(0, 4) + "-" + txtoutOfDate.Text.Substring(4, 2) + "-" + txtoutOfDate.Text.Substring(6, 2);
DateTime.TryParse(time, out outOfDate);
}
//else{
// Response.Write("<script>alert('请输入正确的时间格式，如：20150707')</script>");
// return;
//}
}
string url = "product_qualification.aspx?ProductName=" + hidProductName.Value + "&FactoryName=" + hidFactoryName.Value + "&CodeNum=" + hidCodeNum.Value + "&IsUpload=" + hidIsUpload.Value + "&IsForHead=" + hidIsForHead.Value + "";
//修改
if (hidUpdateId.Value.Length > 4)
{
bll = bll.GetModle(hidUpdateId.Value);
bll.outOfDate = outOfDate;
bll.created = DateTime.Now;
if (HiddenField1.Value != "")
{
bll.file = bll.AddFile(HiddenField1.Value, System.IO.Path.GetExtension(TextBox2.Text));
}
bll.QualType = int.Parse(DropDownList1.SelectedValue);
bll.editer = base.UserName;
bll.Update();
ShowRight(url, false);
}
else //新增
{
int Product_ID = int.Parse(Request.QueryString["id"]);
bll.created = DateTime.Now;
bll.outOfDate = outOfDate;
bll.dowCount = 0;
if (HiddenField1.Value != "")
{
bll.file = bll.AddFile(HiddenField1.Value, System.IO.Path.GetExtension(TextBox2.Text));
}
else
{
ShowError("文件不能为空!");
return;
}
LogAdd("上传了或修改了商品资质:商品编号：{0},资质类型：{1}", bll.Products_Id, DropDownList1.SelectedItem.Text);
bll.Products_Id = Product_ID;
HiddenField2.Value = "";
bll.QualType = int.Parse(DropDownList1.SelectedValue);
bll.editer = base.UserName;
bll.Insert();
init();
ShowRight(url, false);
}
}
