protected void btnImport_Click(object sender, EventArgs e)
{
string strFileName = ConfigurationManager.AppSettings["UploadPath"] + this.ddlEnterpriseID.SelectedValue + @"\Logistics\Prod_Logistics.xls";
if (!System.IO.File.Exists(strFileName))
{
JScript.Instance.ShowMessage(this.updatePanel, Resources.Resource.EP_ProductLogisticsExcelNotExists);
return;
}
Js.BLL.Enterprise.CheckDal dal = new Js.BLL.Enterprise.CheckDal(FormID, cnKey);
DataTable dt = dal.ImportProductLogistics1(Session["EnterpriseID"].ToString(), Session["User"].ToString());
DataTable dtTemp = dal.GetProductLogisticsTemp("1=2");
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dtTemp.NewRow();
dr["UserName"] = Session["User"].ToString();
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
dtTemp.Rows.Add(dr);
}
dal.SaveProductLogistics(dtTemp, Session["User"].ToString());
SetBtnEnabled("");
}
protected void btnCompare_Click(object sender, EventArgs e)
{
Js.BLL.Enterprise.CheckDal dal = new Js.BLL.Enterprise.CheckDal(FormID, cnKey);
dal.UpdateCheckState(Session["EnterpriseID"].ToString());
SetBtnEnabled("");
}
protected void btnCheck_Click(object sender, EventArgs e)
{
Js.BLL.Enterprise.CheckDal dal = new Js.BLL.Enterprise.CheckDal(FormID, cnKey);
dal.Check(this.ddlEnterpriseID.SelectedValue, Session["User"].ToString());
SetBtnEnabled("");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["cnKey"] != null)
cnKey = Session["cnKey"].ToString();
EnterpriseID = Request.QueryString["EnterpriseID"] + "";
FormID = Request.QueryString["FormID"] + "";
LogisticsID = Request.QueryString["ID"] + "";
if (!IsPostBack)
{
Js.BLL.Enterprise.CheckDal cdal = new Js.BLL.Enterprise.CheckDal(FormID, cnKey);
string filter = string.Format("EnterpriseID= '{0}' and LogisticsID='{1}'", EnterpriseID, LogisticsID);
DataTable dt = cdal.GetModifyRecord(FormID,filter);
this.GridView1.DataSource = dt.DefaultView;
this.GridView1.DataBind();
}
}
private void BindGrid()
{
Js.BLL.BaseDal bdal = new Js.BLL.BaseDal(FormID);
DataTable dtSub = bdal.GetSubDetail("").Tables[0];
Js.BLL.Account.UserDal dal = new Js.BLL.Account.UserDal();
if (Session["UserType"].ToString() == "BU")
{
//營運用戶
DataTable dt = dal.GetAllUsers().Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["UserName"].ToString() != Session["User"].ToString())
{
DataRow dr = dtSub.NewRow();
dr["AnnounceID"] = this.txtAnnounceID.Text;
dr["ReceiverUserName"] = dt.Rows[i]["UserName"];
dr["ReceiverFlag"] = 0;
Js.BLL.BusinessUnit.CompanyDal cdal = new Js.BLL.BusinessUnit.CompanyDal();
Js.Model.BusinessUnit.CompanyInfo model = cdal.GetModel();
dr["ReceiveUnitNo"] = model.CompanyNo;
dr["Receiver"] = dt.Rows[i]["PersonName"];
dtSub.Rows.Add(dr);
}
}
//各企業用戶
DataTable dtEP = dal.GetEnterprise();
for (int i = 0; i < dtEP.Rows.Count; i++)
{
Js.BLL.Account.UserDal edal = new Js.BLL.Account.UserDal(dtEP.Rows[i]["EnterpriseID"].ToString());
DataTable dtUser = edal.GetAllUsers().Tables[0];
for (int j = 0; j < dtUser.Rows.Count; j++)
{
DataRow dr = dtSub.NewRow();
dr["AnnounceID"] = this.txtAnnounceID.Text;
dr["ReceiverUserName"] = dtUser.Rows[j]["UserName"];
dr["ReceiverFlag"] = 1;
dr["ReceiveUnitNo"] = dtEP.Rows[i]["EnterpriseID"].ToString();
dr["Receiver"] = dtUser.Rows[j]["PersonName"];
dtSub.Rows.Add(dr);
}
}
}
else
{
Js.BLL.Account.UserDal edal = new Js.BLL.Account.UserDal(Session["EnterpriseID"].ToString());
DataTable dtUser = edal.GetAllUsers().Tables[0];
for (int i = 0; i < dtUser.Rows.Count; i++)
{
if (dtUser.Rows[i]["UserName"].ToString() != Session["User"].ToString())
{
DataRow dr = dtSub.NewRow();
dr["AnnounceID"] = this.txtAnnounceID.Text;
dr["ReceiverUserName"] = dtUser.Rows[i]["UserName"];
dr["ReceiverFlag"] = 1;
dr["ReceiveUnitNo"] = Session["EnterpriseID"].ToString();
dr["Receiver"] = dtUser.Rows[i]["PersonName"];
dtSub.Rows.Add(dr);
}
}
//營運管理用戶
Js.BLL.Enterprise.CheckDal checkdal = new Js.BLL.Enterprise.CheckDal();
dtUser = checkdal.GetManagerUser(Session["EnterpriseID"].ToString());
Js.BLL.BusinessUnit.CompanyDal cdal = new Js.BLL.BusinessUnit.CompanyDal();
Js.Model.BusinessUnit.CompanyInfo model = cdal.GetModel();
for (int i = 0; i < dtUser.Rows.Count; i++)
{
DataRow dr = dtSub.NewRow();
dr["AnnounceID"] = this.txtAnnounceID.Text;
dr["ReceiverUserName"] = dtUser.Rows[i]["UserName"];
dr["ReceiverFlag"] = 0;
dr["ReceiveUnitNo"] = model.CompanyNo;
dr["Receiver"] = dtUser.Rows[i]["PersonName"];
dtSub.Rows.Add(dr);
}
}
this.GridView1.DataSource = dtSub.DefaultView;
this.GridView1.DataBind();
}
public string IsExistsByFilter(string FormID, string EnterpriseID, string ID, string cnKey)
{
ID = Server.UrlDecode(ID);
EnterpriseID = Server.UrlDecode(EnterpriseID);
string filter = string.Format("EnterpriseID='{0}'", EnterpriseID);
Js.BLL.BaseDal dal = new Js.BLL.BaseDal(FormID, cnKey);
Js.BLL.Enterprise.CheckDal cdal = new Js.BLL.Enterprise.CheckDal(FormID, cnKey);
byte strTemp = 0;
if (ID.Length > 0)
{
if (dal.Exists(ID, filter))
strTemp = 1;
else
strTemp = 0;
}
if (FormID == "EP_Department" || FormID == "EP_Person")
{ }
else
{
if (strTemp == 0)
{
if (cdal.IsEnterpriseChecked(EnterpriseID))
strTemp = 2;
}
}
return strTemp.ToString();
}
protected void btnUpload_Click(object sender, EventArgs e)
{
Js.BLL.Enterprise.CheckDal dal = new Js.BLL.Enterprise.CheckDal(FormID, cnKey);
dal.UpoladBusinessUnit(Session["EnterpriseID"].ToString(), Session["User"].ToString());
this.txtUploadDate.Text = Js.Com.PageValidate.ParseDateTime(DateTime.Now.ToString());
SetBtnEnabled("");
JScript.Instance.ShowMessage(this.updatePanel, Resources.Resource.EP_ProductLogisticsUploadSuccess);
}
protected void btnUnCheck_Click(object sender, EventArgs e)
{
Js.BLL.Enterprise.CheckDal dal = new Js.BLL.Enterprise.CheckDal(FormID, cnKey);
dal.UnCheck(this.ddlEnterpriseID.SelectedValue);
this.txtUploadDate.Text = "";
SetBtnEnabled("");
}