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();
}
protected void Page_Load(object sender, EventArgs e)
{
ID = Request.QueryString["ID"] + "";
FormID = Request.QueryString["FormID"] + "";
if (!IsPostBack)
{
ViewState["StrWhere"] = string.Format(" AnnounceID='{0}'", ID);
if (Session["UserType"].ToString() == "BU")
{
this.txtAnnounceFlag.Text = Resources.Resource.AnnounceFlag1;
Js.BLL.BusinessUnit.CompanyDal cdal = new Js.BLL.BusinessUnit.CompanyDal();
Js.Model.BusinessUnit.CompanyInfo model = cdal.GetModel();
this.txtAnnounceUnitNo.Text = model.CompanyNo;
Js.BLL.Account.UserDal udal = new Js.BLL.Account.UserDal();
Js.Model.Account.UsersInfo umodel = udal.GetModel(Session["User"].ToString());
this.txtAnnouncer.Text = umodel.PersonName;
}
else
{
this.txtAnnounceFlag.Text = Resources.Resource.AnnounceFlag2;
this.txtAnnounceUnitNo.Text = Session["EnterpriseID"].ToString();
Js.BLL.Account.UserDal udal = new Js.BLL.Account.UserDal(Session["EnterpriseID"].ToString());
Js.Model.Account.UsersInfo umodel = udal.GetModel(Session["User"].ToString());
this.txtAnnouncer.Text = umodel.PersonName;
}
Js.BLL.BaseDal dal = new Js.BLL.BaseDal(FormID);
string strWhere = " AnnounceID like '" + this.txtAnnounceUnitNo.Text + DateTime.Now.ToString("yyyyMMdd") + "%'";
dal.GetMaxID(strWhere);
this.txtAnnounceID.Text = dal.GetMaxID(strWhere);
if(this.txtAnnounceID.Text.Length<=0)
this.txtAnnounceID.Text =this.txtAnnounceUnitNo.Text + DateTime.Now.ToString("yyyyMMdd") + "0001";
this.txtAnnouncerUserName.Text = Session["User"].ToString();
this.txtSource.Text = Resources.Resource.AnnounceSource1;
BindGrid();
}
}
public static void SystemMessage(string[] ToUserName, int ReceiverFlag, string[] ReceiveUnitNo, string Title, string Content)
{
Js.BLL.BaseDal dal = new Js.BLL.BaseDal("Sys_AnnounceMessage");
string strAnnounceUnitNo = "";
string strAnnounceID = "";
string strAnnouncer = "";
string strWhere = " AnnounceID like '" + strAnnounceUnitNo + DateTime.Now.ToString("yyyyMMdd") + "%'";
dal.GetMaxID(strWhere);
strAnnounceID = dal.GetMaxID(strWhere);
if (strAnnounceID.Length <= 0)
strAnnounceID = strAnnounceUnitNo + DateTime.Now.ToString("yyyyMMdd") + "0001";
if (HttpContext.Current.Session["UserType"].ToString() == "BU")
{
Js.BLL.BusinessUnit.CompanyDal cdal = new Js.BLL.BusinessUnit.CompanyDal();
Js.Model.BusinessUnit.CompanyInfo model = cdal.GetModel();
strAnnounceUnitNo = model.CompanyNo;
Js.BLL.Account.UserDal udal = new Js.BLL.Account.UserDal();
Js.Model.Account.UsersInfo umodel = udal.GetModel(HttpContext.Current.Session["User"].ToString());
strAnnouncer = umodel.PersonName;
}
else
{
strAnnounceUnitNo = HttpContext.Current.Session["EnterpriseID"].ToString();
Js.BLL.Account.UserDal udal = new Js.BLL.Account.UserDal(HttpContext.Current.Session["EnterpriseID"].ToString());
Js.Model.Account.UsersInfo umodel = udal.GetModel(HttpContext.Current.Session["User"].ToString());
strAnnouncer = umodel.PersonName;
}
DataTable dt = dal.GetRecord("1=2");
DataRow dr = dt.NewRow();
dr["AnnounceID"] = strAnnounceID;
dr["Announcer"] = strAnnouncer;
if (HttpContext.Current.Session["UserType"].ToString() == "BU")
dr["AnnounceFlag"] = 0;
else
dr["AnnounceFlag"] = 1;
dr["AnnounceUnitNo"] = strAnnounceUnitNo;
dr["AnnouncerUserName"] = HttpContext.Current.Session["User"].ToString();
dr["Source"] = 1;
dr["AnnounceDate"] = DateTime.Now;
dr["Title"] = Title;
dr["Contents"] = Content;
dal.Add(dr);
DataTable dtSub = dal.GetSubDetail("").Tables[0];
for (int i = 0; i < ToUserName.Length; i++)
{
DataRow subdr = dtSub.NewRow();
subdr["AnnounceID"] = strAnnounceID;
subdr["ReceiverUserName"] = ToUserName[i];
subdr["ReceiverFlag"] = ReceiverFlag;
subdr["ReceiveUnitNo"] = ReceiveUnitNo[i];
Js.BLL.Account.UserDal udal = new Js.BLL.Account.UserDal(ReceiveUnitNo[i]);
Js.Model.Account.UsersInfo umodel = udal.GetModel(ToUserName[i]);
subdr["Receiver"] = umodel.PersonName;
dtSub.Rows.Add(subdr);
}
dal.SaveDetail(dtSub, "");
}