protected void tr_OfficialCity_Selected(object sender, MCSControls.MCSWebControls.SelectedEventArgs e)
{
cbl_OfficialList.Items.Clear();
DataTable dt = TreeTableBLL.GetAllChildByNodes("MCS_SYS.dbo.Addr_OfficialCity", "ID", "SuperID", tr_OfficialCity.SelectValue);
for (int i = 0; i < dt.Rows.Count; i++)
{
Addr_OfficialCityBLL city = new Addr_OfficialCityBLL((int)dt.Rows[i]["ID"]);
if (city.Model.Level == 3)
{
string fullname = TreeTableBLL.GetFullPathName("MCS_SYS.dbo.Addr_OfficialCity", city.Model.ID);
ListItem item = new ListItem(fullname, city.Model.ID.ToString());
IList <Addr_OfficialCityInOrganizeCity> organizecitys = Addr_OfficialCityInOrganizeCityBLL.GetModelList("OfficialCity=" + city.Model.ID.ToString());
if (organizecitys.Count > 0)
{
Addr_OrganizeCity organizecity = new Addr_OrganizeCityBLL(organizecitys[0].OrganizeCity).Model;
if (organizecity != null)
{
item.Text += "; 已归属于片区:【" + organizecity.Name + "】";
}
item.Enabled = false;
}
cbl_OfficialList.Items.Add(item);
}
}
}
private void BindData()
{
int id = (int)ViewState["ID"];
ORD_OrderApply apply = new ORD_OrderApplyBLL(id).Model;
if (apply == null)
{
Response.Redirect("FeeApplyList.aspx");
}
pn_OrderApply.BindData(apply);
ViewState["Type"] = apply.Type;
int month = new AC_AccountMonthBLL(apply.AccountMonth).Model.Month;
ORD_OrderLimitFactorBLL limitbll = new ORD_OrderLimitFactorBLL();
ViewState["Limit"] = limitbll.GetLimitInfo(apply.AccountMonth, apply.Client);
#region 绑定当前申请单的管理片区
Label lb_OrganizeCity = (Label)pn_OrderApply.FindControl("ORD_OrderApply_OrganizeCity");
lb_OrganizeCity.Text = TreeTableBLL.GetFullPathName("MCS_Sys.dbo.Addr_OrganizeCity", apply.OrganizeCity);
#endregion
BindGrid();
}
private void BindGrid()
{
lbl_message.Text = "费用报销审批汇总表";
int id = (int)ViewState["ID"];
FNA_FeeWriteOffBLL bll = new FNA_FeeWriteOffBLL(id);
ViewState["Details"] = bll.Items.OrderBy(p => p.Client).ThenBy(p => p.AccountTitle).ThenBy(p => p.BeginMonth).ToList();
FNA_FeeWriteOff writeoff = bll.Model;
if (writeoff == null)
{
Response.Redirect("FeeWriteOffList.aspx");
}
BindGridPrint();
string type = "";
if (writeoff["InvoiceClassAB"] != "")
{
type = DictionaryBLL.GetDicCollections("FNA_InvoiceClassAB")[writeoff["InvoiceClassAB"]].Name;
}
// type = DictionaryBLL.Dictionary_Data_GetAlllList("TableName='FNA_InvoiceClassAB' AND Code='" + writeoff["InvoiceClassAB"] + "'")[0].Name;
if (type == "")
{
type = "抵款";
}
span_sheetcode.InnerText = writeoff.SheetCode;
span_accountmonth.InnerText = new AC_AccountMonthBLL(writeoff.AccountMonth).Model.Name;
if (bll.Model["InsteadPayStaff"] != "" && bll.Model["InsteadPayStaff"] != "0")
{
p_ddtype.InnerText = "员工";
span_client.InnerText = new Org_StaffBLL(int.Parse(bll.Model["InsteadPayStaff"])).Model.RealName;
}
else
{
span_client.InnerText = new CM_ClientBLL(writeoff.InsteadPayClient).Model.FullName;
}
int city5 = TreeTableBLL.GetSuperIDByLevel("MCS_SYS.dbo.Addr_OrganizeCity", writeoff.OrganizeCity, 5);
span_orgnizecity.InnerText = TreeTableBLL.GetFullPathName("MCS_SYS.dbo.Addr_OrganizeCity", "ID", "Name", "SuperID", 1, city5 > 0 ? city5 : writeoff.OrganizeCity);
span_type.InnerText = type;
span1.InnerText = span2.InnerText = "1";
//求费用核消金额合计
decimal _totalcost = 0;
foreach (FNA_FeeWriteOffDetail _detail in bll.Items)
{
_totalcost += _detail.WriteOffCost + _detail.AdjustCost;
}
lab_SubTotalCostCN.Text = MCSFramework.Common.Rmb.CmycurD(_totalcost.ToString());
lab_SubTotalCost.Text = _totalcost.ToString("#,##0.00");
lab_SubTotalCost.Text = lab_SubTotalCost.Text;
lab_SubTotalCost.Text = lab_SubTotalCost.Text;
}
/// <summary>
/// 获取指定城市的全名
/// </summary>
/// <param name="AuthKey">匿名用户登录后的认证码</param>
/// <param name="CityID"></param>
/// <returns></returns>
public static string GetCityFullName(UserInfo User, int CityID)
{
LogWriter.WriteLog("OfficialCityService.GetCityFullName:UserName="******",CityID=" + CityID.ToString());
if (CityID <= 1)
{
return("中国");
}
return(TreeTableBLL.GetFullPathName("MCS_SYS.dbo.Addr_OfficialCity", CityID).Replace("->", " "));
}
protected void tr_OrganizeCity_Selected(object sender, SelectedEventArgs e)
{
Label lb_OrganizeCity = (Label)pn_OrderApply.FindControl("ORD_OrderApply_OrganizeCity");
lb_OrganizeCity.Text = TreeTableBLL.GetFullPathName("MCS_Sys.dbo.Addr_OrganizeCity", e.CurSelectIndex);
Label lb_SheetCode = (Label)pn_OrderApply.FindControl("ORD_OrderApply_SheetCode");
lb_SheetCode.Text = ORD_OrderApplyBLL.GenerateSheetCode(e.CurSelectIndex, AC_AccountMonthBLL.GetCurrentMonth());
MCSSelectControl select_Client = (MCSSelectControl)pn_OrderApply.FindControl("ORD_OrderApply_Client");
select_Client.PageUrl = "~/SubModule/CM/PopSearch/Search_SelectClient.aspx?ClientType=2&OrganizeCity=" + e.CurSelectIndex;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//初始化当前目录ID
ViewState["FolderID"] = Request.QueryString["FolderID"] != null ? Request.QueryString["FolderID"].ToString() : "76";
//上层目录
Rpt_FolderBLL fbll = new Rpt_FolderBLL(int.Parse((string)ViewState["FolderID"]));
superid = fbll.Model.SuperID != 0 ? fbll.Model.SuperID : 1;
//当前目录路径
//pathname = TreeTableBLL.GetFullPathName("MCS_Reports.dbo.Rpt_Folder", "ID", "Name", "SuperID", 0, int.Parse((string)ViewState["FolderID"]));
pathname = TreeTableBLL.GetFullPathName("MCS_Reports.dbo.Rpt_Folder", int.Parse((string)ViewState["FolderID"]));
BindData();
}
}
private void BindData()
{
FNA_FeeWriteOffDetail m = new FNA_FeeWriteOffBLL().GetDetailModel((int)ViewState["ID"]);
lb_AccountTitle.Text = TreeTableBLL.GetFullPathName("MCS_Pub.dbo.AC_AccountTitle", m.AccountTitle);
lb_ApplyCost.Text = m.ApplyCost.ToString("0.###");
lb_WriteOffCost.Text = m.WriteOffCost.ToString("0.###");
tbx_ApproveCost.Text = (m.WriteOffCost + m.AdjustCost).ToString("0.###");
rbl_AdjustMode.SelectedValue = m.AdjustMode.ToString();
try
{
if (new FNA_FeeWriteOffBLL(m.WriteOffID).Model["HasFeeApply"] == "N")
{
rbl_AdjustMode.Items.FindByValue("1").Enabled = false; //无申请直接核销的单子，不可选择“退回重新再核销”
rbl_AdjustMode.Items.FindByValue("2").Selected = true;
}
}
catch { }
}
private void BindGrid()
{
int month = int.Parse(ddl_Month.SelectedValue);
int organizecity = int.Parse(tr_OrganizeCity.SelectValue);
int level = int.Parse(ddl_Level.SelectedValue);
int feetype = int.Parse(ddl_FeeType.SelectedValue);
int state = int.Parse(ddl_State.SelectedValue);
if (MCSTabControl1.SelectedIndex == 0)
{
#region 显示汇总单数据源
Dictionary_Data dicFeeType = null;
if (feetype > 0)
{
dicFeeType = DictionaryBLL.GetDicCollections("FNA_FeeType")[feetype.ToString()];
}
#region 额外条件
string condition = "";
//费用代垫客户
if (select_Client.SelectValue != "")
{
condition += " AND FNA_FeeWriteOff.InsteadPayClient=" + select_Client.SelectValue;
}
//费用代垫员工
if (Select_InsteadPayStaff.SelectValue != "")
{
condition += " AND MCS_SYS.dbo.UF_Spilt2('MCS_FNA.dbo.FNA_FeeWriteOff',FNA_FeeWriteOff.ExtPropertys,'InsteadPayStaff')=" + Select_InsteadPayStaff.SelectValue;
}
//核销申请人
if (Select_InsertStaff.SelectValue != "")
{
condition += " AND FNA_FeeWriteOff.InsertStaff=" + Select_InsertStaff.SelectValue;
}
#endregion
DataTable dtSummary = FNA_FeeWriteOffBLL.GetSummaryTotal(month, organizecity, level, feetype, state, int.Parse(Session["UserID"].ToString()), condition);
if (dtSummary.Rows.Count == 0)
{
gv_List.DataBind();
return;
}
#region 矩阵化数据表，扩展表数据列
dtSummary.Columns.Add(new DataColumn("ID", Type.GetType("System.Int32")));
if (level < 10)
{
foreach (DataRow row in dtSummary.Rows)
{
row["ID"] = row["OrganizeCity"];
}
dtSummary = MatrixTable.Matrix(dtSummary, new string[] { "ID", "管理片区名称" },
new string[] { "FeeTypeName", "AccountTitleName" }, "WriteOffCost", true, true);
}
else
{
if (level == 10)
{
//按经销商查看
#region 将经销商的所属管理片区赋至管理片区列
Dictionary <int, string> dicFullOrganizeCityName = new Dictionary <int, string>();
foreach (DataRow row in dtSummary.Rows)
{
row["ID"] = row["经销商ID"] == DBNull.Value ? 0 : row["经销商ID"];
row["经销商名称"] = row["经销商名称"] == DBNull.Value ? "无" : row["经销商名称"];
if ((int)row["ID"] > 0)
{
CM_Client c = new CM_ClientBLL((int)row["ID"]).Model;
if (c != null)
{
if (!dicFullOrganizeCityName.ContainsKey(c.OrganizeCity))
{
dicFullOrganizeCityName.Add(c.OrganizeCity, TreeTableBLL.GetFullPathName("MCS_SYS.dbo.Addr_OrganizeCity", c.OrganizeCity));
}
row["管理片区名称"] = dicFullOrganizeCityName[c.OrganizeCity];
}
}
}
#endregion
dtSummary = MatrixTable.Matrix(dtSummary, new string[] { "ID", "管理片区名称", "经销商名称" },
new string[] { "FeeTypeName", "AccountTitleName" }, "WriteOffCost", true, true);
}
else if (level == 20)
{
//按门店查看
#region 将门店的所属管理片区赋至管理片区列
Dictionary <int, string> dicFullOrganizeCityName = new Dictionary <int, string>();
foreach (DataRow row in dtSummary.Rows)
{
row["ID"] = row["客户ID"] == DBNull.Value ? 0 : row["客户ID"];
row["客户名称"] = row["客户名称"] == DBNull.Value ? "无" : row["客户名称"];
if ((int)row["ID"] > 0)
{
CM_Client c = new CM_ClientBLL((int)row["ID"]).Model;
if (c != null)
{
if (!dicFullOrganizeCityName.ContainsKey(c.OrganizeCity))
{
dicFullOrganizeCityName.Add(c.OrganizeCity, TreeTableBLL.GetFullPathName("MCS_SYS.dbo.Addr_OrganizeCity", c.OrganizeCity));
}
row["管理片区名称"] = dicFullOrganizeCityName[c.OrganizeCity];
}
}
}
#endregion
dtSummary = MatrixTable.Matrix(dtSummary, new string[] { "ID", "管理片区名称", "客户名称" },
new string[] { "FeeTypeName", "AccountTitleName" }, "WriteOffCost", true, true);
}
}
dtSummary = MatrixTable.ColumnSummaryTotal(dtSummary, new int[] { 1 }, new string[] { "WriteOffCost" });
#endregion
#region 暂不计算分析数据
//dtSummary.Columns["合计"].ColumnName = "费用合计";
//dtSummary.Columns.Add("预计销量", Type.GetType("System.Decimal"));
//if (dicFeeType != null && dicFeeType.Description == "BudgetControl" && level < 10)
//{
// dtSummary.Columns.Add("预算总额", Type.GetType("System.Decimal"));
// dtSummary.Columns.Add("其中扩增额", Type.GetType("System.Decimal"));
// dtSummary.Columns.Add("预算余额", Type.GetType("System.Decimal"));
//}
//if (dicFeeType != null && dicFeeType.Description == "FeeRateControl")
// dtSummary.Columns.Add("上月余额", Type.GetType("System.Decimal"));
//dtSummary.Columns.Add("费点", Type.GetType("System.String"));
//decimal sumTotalVolume = 0, sumTotalBudget = 0, sumExtBudget = 0, sumPreMonthBudgetBalance = 0, sumUsableAmount = 0;
//foreach (DataRow row in dtSummary.Rows)
//{
// int id = 0;
// if (int.TryParse(row[0].ToString(), out id) && id > 0)
// {
// bool includechild = true;
// if (level < 10 && new Addr_OrganizeCityBLL(id).Model.Level < level) includechild = false;
// #region 计算费点
// if (level < 10)
// row["预计销量"] = SVM_SalesForcastBLL.GetTotalVolume(month, id, includechild);
// else if (level == 10 || level == 20)
// row["预计销量"] = SVM_SalesForcastBLL.GetTotalVolumeByClient(month, id);
// sumTotalVolume += (decimal)row["预计销量"];
// if (dicFeeType != null && dicFeeType.Description == "BudgetControl" && level < 10)
// {
// row["预算总额"] = (FNA_BudgetBLL.GetSumBudgetAmount(month, id, feetype, includechild) + FNA_BudgetBLL.GetSumBudgetAmount(month, id, 0, includechild));
// sumTotalBudget += (decimal)row["预算总额"];
// row["其中扩增额"] = (FNA_BudgetExtraApplyBLL.GetExtraAmount(month, id, feetype, includechild) + FNA_BudgetExtraApplyBLL.GetExtraAmount(month, id, 0, includechild));
// sumExtBudget += (decimal)row["其中扩增额"];
// row["预算余额"] = (FNA_BudgetBLL.GetUsableAmount(month, id, feetype, includechild) + FNA_BudgetBLL.GetUsableAmount(month, id, 0, includechild));
// sumUsableAmount += (decimal)row["预算余额"];
// }
// if (dicFeeType != null && dicFeeType.Description == "FeeRateControl" && level < 10)
// {
// row["上月余额"] = FNA_BudgetBLL.GetUsableAmount(month - 1, id, feetype, includechild);
// sumPreMonthBudgetBalance += (decimal)row["上月余额"];
// if ((decimal)row["预计销量"] != 0)
// row["费点"] = (((decimal)row["费用合计"] - (decimal)row["上月余额"]) / (decimal)row["预计销量"]).ToString("0.00%");
// }
// else if ((decimal)row["预计销量"] != 0)
// row["费点"] = ((decimal)row["费用合计"] / (decimal)row["预计销量"]).ToString("0.00%");
// #endregion
// }
// #region 求合计行
// if (id == 0)
// {
// row["预计销量"] = sumTotalVolume.ToString("0.00");
// #region 预算总额及余额
// if (dicFeeType != null && dicFeeType.Description == "BudgetControl" && level < 10)
// {
// row["预算总额"] = sumTotalBudget.ToString("0.00");
// row["其中扩增额"] = sumExtBudget.ToString("0.00");
// row["预算余额"] = sumUsableAmount.ToString("0.00");
// }
// #endregion
// #region 费点
// if (sumTotalVolume != 0)
// {
// if (dicFeeType != null && dicFeeType.Description == "FeeRateControl" && level < 10)
// {
// row["上月余额"] = sumPreMonthBudgetBalance;
// row["费点"] = (((decimal)row["费用合计"] - sumPreMonthBudgetBalance) / sumTotalVolume).ToString("0.##%");
// }
// else
// row["费点"] = ((decimal)row["费用合计"] / sumTotalVolume).ToString("0.##%");
// }
// #endregion
// }
// #endregion
//}
#endregion
#endregion
gv_List.DataSource = dtSummary;
gv_List.DataBind();
if (dtSummary.Columns.Count >= 24)
{
gv_List.Width = new Unit(dtSummary.Columns.Count * 55);
}
else
{
gv_List.Width = new Unit(100, UnitType.Percentage);
}
MatrixTable.GridViewMatric(gv_List);
if (level == 20)
{
//按终端门店显示时，将上下行相同管理片区合并
MatrixTable.GridViewMergSampeValueRow(gv_List, 0);
MatrixTable.GridViewMergSampeValueRow(gv_List, 1);
}
#region 是否可以批量审批
if (state != 1 || level >= 10)
{
gv_List.Columns[0].ItemStyle.Width = new Unit(1);
foreach (GridViewRow row in gv_List.Rows)
{
row.FindControl("bt_Approved").Visible = false;
row.FindControl("bt_UnApproved").Visible = false;
}
}
else
{
gv_List.Columns[0].ItemStyle.Width = new Unit(68);
}
#endregion
}
else
{
string condition = "1=1";
#region 组织明细记录的查询条件
//管理片区及所有下属管理片区
if (tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
condition += " AND FNA_FeeWriteOff.OrganizeCity IN (" + orgcitys + ")";
}
//会计月条件
condition += " AND FNA_FeeWriteOff.AccountMonth = " + ddl_Month.SelectedValue;
int accounttile = 0;
int.TryParse(tr_AccountTitle.SelectValue, out accounttile);
decimal _cost = 0;
decimal.TryParse(tbx_WriteOffCost.Text, out _cost);
//费用类型
if (ddl_FeeType.SelectedValue != "0" && !(accounttile > 1))
{
IList <AC_AccountTitleInFeeType> titles = AC_AccountTitleInFeeTypeBLL.GetModelList("FeeType=" + ddl_FeeType.SelectedValue);
string ids = "";
foreach (AC_AccountTitleInFeeType item in titles)
{
ids += item.AccountTitle + ",";
}
if (ids.EndsWith(","))
{
ids = ids.Substring(0, ids.Length - 1);
}
condition += " AND FNA_FeeWriteOff.ID IN (SELECT WriteOffID FROM MCS_FNA.dbo.FNA_FeeWriteOffDetail WHERE AccountTitle IN(" + ids + ") AND FNA_FeeWriteOffDetail.WriteOffID=FNA_FeeWriteOff.ID)";
}
//费用科目
if (accounttile > 1)
{
DataTable dt = TreeTableBLL.GetAllChildByNodes("MCS_PUB.dbo.AC_AccountTitle", "ID", "SuperID", accounttile.ToString());
string ids = "";
foreach (DataRow dr in dt.Rows)
{
ids += dr["ID"].ToString() + ",";
}
ids += accounttile.ToString();
if (_cost == 0)
{
condition += " AND FNA_FeeWriteOff.ID IN (SELECT WriteOffID FROM MCS_FNA.dbo.FNA_FeeWriteOffDetail WHERE AccountTitle IN(" + ids + ") AND FNA_FeeWriteOffDetail.WriteOffID=FNA_FeeWriteOff.ID)";
}
else
{
condition += " AND FNA_FeeWriteOff.ID IN (SELECT WriteOffID FROM MCS_FNA.dbo.FNA_FeeWriteOffDetail WHERE AccountTitle IN(" + ids + ") AND (WriteOffCost+AdjustCost)" + ddl_WriteOffCostOP.SelectedValue + " " + _cost.ToString() + " AND FNA_FeeWriteOffDetail.WriteOffID=FNA_FeeWriteOff.ID)";
}
}
else if (_cost != 0)
{ //核销金额判断
condition += " AND FNA_FeeWriteOff.ID IN (SELECT WriteOffID FROM MCS_FNA.dbo.FNA_FeeWriteOffDetail WHERE (WriteOffCost+AdjustCost)" + ddl_WriteOffCostOP.SelectedValue + " " + _cost.ToString() + " AND FNA_FeeWriteOffDetail.WriteOffID=FNA_FeeWriteOff.ID)";
}
//审批状态
if (ddl_State.SelectedValue == "0")
{
condition += " AND FNA_FeeWriteOff.State IN (2,3) ";
}
else if (ddl_State.SelectedValue == "1")
{
condition +=
@" AND FNA_FeeWriteOff.State = 2 AND FNA_FeeWriteOff.ApproveTask IN
(SELECT EWF_Task_Job.Task FROM MCS_EWF.dbo.EWF_Task_JobDecision INNER JOIN
MCS_EWF.dbo.EWF_Task_Job ON EWF_Task_JobDecision.Job = EWF_Task_Job.ID
WHERE EWF_Task_JobDecision.RecipientStaff=" + Session["UserID"].ToString() + @" AND
EWF_Task_JobDecision.DecisionResult=1 and EWF_Task_Job.Status=3)";
}
else if (ddl_State.SelectedValue == "2")
{
condition += " AND FNA_FeeWriteOff.State = 3 ";
}
else if (ddl_State.SelectedValue == "3")
{
AC_AccountMonth m = new AC_AccountMonthBLL(month).Model;
condition +=
@" AND FNA_FeeWriteOff.State IN (2,3) AND FNA_FeeWriteOff.ApproveTask IN
(SELECT EWF_Task_Job.Task FROM MCS_EWF.dbo.EWF_Task_JobDecision INNER JOIN
MCS_EWF.dbo.EWF_Task_Job ON EWF_Task_JobDecision.Job = EWF_Task_Job.ID
WHERE EWF_Task_JobDecision.RecipientStaff=" + Session["UserID"].ToString() + @" AND
EWF_Task_JobDecision.DecisionResult IN(2,5,6) AND
EWF_Task_JobDecision.DecisionTime BETWEEN DATEADD(month,-1,'" + m.BeginDate.ToString("yyyy-MM-dd") + @"') AND
DATEADD(month,3,'" + m.BeginDate.ToString("yyyy-MM-dd") + @"'))";
}
//费用代垫客户
if (select_Client.SelectValue != "")
{
condition += " AND FNA_FeeWriteOff.InsteadPayClient=" + select_Client.SelectValue;
}
//费用代垫员工
if (Select_InsteadPayStaff.SelectValue != "")
{
condition += " AND MCS_SYS.dbo.UF_Spilt2('MCS_FNA.dbo.FNA_FeeWriteOff',FNA_FeeWriteOff.ExtPropertys,'InsteadPayStaff')=" + Select_InsteadPayStaff.SelectValue;
}
//核销申请人
if (Select_InsertStaff.SelectValue != "")
{
condition += " AND FNA_FeeWriteOff.InsertStaff=" + Select_InsertStaff.SelectValue;
}
#endregion
gv_ListDetail.ConditionString = condition;
gv_ListDetail.BindGrid();
}
}
private DataTable LoadWorkingPlanDetail(int planid)
{
JN_WorkingPlanBLL bll = new JN_WorkingPlanBLL(planid);
DataTable dt = GenareateDataTable(bll.Model.BeginDate, bll.Model.EndDate);
#region 载入原工作计划
foreach (JN_WorkingPlanDetail detail in bll.Items.OrderBy(p => p.WorkingClassify))
{
DataRow[] rows = dt.Select("WorkingClassify = " + detail.WorkingClassify.ToString() +
" AND Description = '" + detail.Description + "' " +
" AND RelateStaff = " + detail.RelateStaff.ToString() +
" AND RelateClient = " + detail.RelateClient.ToString() +
" AND OfficialCity = " + detail.OfficialCity.ToString());
if (rows.Length > 0)
{
DateTime date = detail.BeginTime;
while (date <= detail.EndTime)
{
rows[0]["P" + date.ToString("MMdd")] = true;
date = date.AddDays(1);
}
}
else
{
DataRow dr = dt.NewRow();
dr["WorkingClassify"] = detail.WorkingClassify;
dr["WorkingClassifyName"] = DictionaryBLL.GetDicCollections("OA_WorkingClassify")[detail.WorkingClassify.ToString()].Name;
dr["Description"] = detail.Description;
dr["RelateClient"] = detail.RelateClient;
if (detail.RelateClient > 0)
{
dr["RelateClientName"] = new CM_ClientBLL(detail.RelateClient).Model.FullName;
}
dr["RelateStaff"] = detail.RelateStaff;
if (detail.RelateStaff > 0)
{
dr["RelateStaffName"] = new Org_StaffBLL(detail.RelateStaff).Model.RealName;
}
dr["OfficialCity"] = detail.OfficialCity;
if (detail.OfficialCity > 0)
{
dr["OfficialCityName"] = TreeTableBLL.GetFullPathName("MCS_SYS.dbo.Addr_OfficialCity", detail.OfficialCity).Replace("->", " ");
}
DateTime date = detail.BeginTime;
while (date <= detail.EndTime)
{
dr["P" + date.ToString("MMdd")] = true;
date = date.AddDays(1);
}
if (detail["Cost1"] != "")
{
dr["Cost1"] = decimal.Parse(detail["Cost1"]);
}
else
{
dr["Cost1"] = 0;
}
if (detail["Cost2"] != "")
{
dr["Cost2"] = decimal.Parse(detail["Cost2"]);
}
else
{
dr["Cost2"] = 0;
}
dt.Rows.Add(dr);
}
}
#endregion
#region 加载数据库中已填报的日志
string con = "Staff = " + bll.Model.Staff.ToString() +
" AND BeginTime BETWEEN '" + bll.Model.BeginDate.ToString("yyyy-MM-dd") + "' AND '" + bll.Model.EndDate.ToString("yyyy-MM-dd 23:59:59") + "' " +
" AND JournalType = 1";
IList <JN_Journal> Journals = JN_JournalBLL.GetModelList(con);
foreach (JN_Journal journal in Journals.OrderBy(p => p.WorkingClassify))
{
DataRow[] rows = dt.Select("WorkingClassify = " + journal.WorkingClassify.ToString() +
" AND Description = '" + journal.Title + "' " +
" AND RelateStaff = " + (journal.WorkingClassify == 2 ? journal.RelateStaff.ToString() : "0") +
" AND RelateClient = " + (journal.WorkingClassify == 1 ? journal.RelateClient.ToString() : "0") +
" AND OfficialCity = " + journal.OfficialCity.ToString());
if (rows.Length == 0)
{
rows = dt.Select("WorkingClassify = " + journal.WorkingClassify.ToString() +
" AND Description = '' " +
" AND RelateStaff = " + (journal.WorkingClassify == 2 ? journal.RelateStaff.ToString() : "0") +
" AND RelateClient = " + (journal.WorkingClassify == 1 ? journal.RelateClient.ToString() : "0") +
" AND OfficialCity = " + journal.OfficialCity.ToString());
}
if (rows.Length > 0)
{
rows[0]["J" + journal.BeginTime.ToString("MMdd")] = true;
rows[0]["JID" + journal.BeginTime.ToString("MMdd")] = journal.ID;
DateTime date = journal.BeginTime;
while (date <= journal.EndTime)
{
rows[0]["J" + date.ToString("MMdd")] = true;
rows[0]["JID" + date.ToString("MMdd")] = journal.ID;
date = date.AddDays(1);
}
}
else
{
#region 增加无计划的日志
DataRow dr = dt.NewRow();
dr["WorkingClassify"] = journal.WorkingClassify;
if (journal.WorkingClassify > 0)
{
dr["WorkingClassifyName"] = DictionaryBLL.GetDicCollections("OA_WorkingClassify")[journal.WorkingClassify.ToString()].Name;
}
dr["Description"] = journal.Title;
dr["RelateClient"] = journal.RelateClient;
if (journal.RelateClient > 0)
{
dr["RelateClientName"] = new CM_ClientBLL(journal.RelateClient).Model.FullName;
}
dr["RelateStaff"] = journal.RelateStaff;
if (journal.RelateStaff > 0)
{
dr["RelateStaffName"] = new Org_StaffBLL(journal.RelateStaff).Model.RealName;
}
dr["OfficialCity"] = journal.OfficialCity;
if (journal.OfficialCity > 0)
{
dr["OfficialCityName"] = TreeTableBLL.GetFullPathName("MCS_SYS.dbo.Addr_OfficialCity", journal.OfficialCity).Replace("->", " ");
}
DateTime date = journal.BeginTime;
while (date <= journal.EndTime)
{
dr["J" + date.ToString("MMdd")] = true;
dr["JID" + date.ToString("MMdd")] = journal.ID;
date = date.AddDays(1);
}
dt.Rows.Add(dr);
#endregion
}
}
#endregion
return(dt);
}
/// <summary>
/// Bind data to the control by special NameValueCollection
/// </summary>
public void BindData(NameValueCollection dataobjects)
{
foreach (object key in HTDataObjectControlInfo.Keys)
{
DataObjectControlInfo _dataobjectcontrolinfo = (DataObjectControlInfo)HTDataObjectControlInfo[key];
EWF_Flow_DataObject _dataobjct = new EWF_Flow_DataObjectBLL(_dataobjectcontrolinfo.DataObjectID).Model;
try
{
switch (_dataobjectcontrolinfo.ControlType)
{
case 1: //Label控件
if (_dataobjct.RelationType == 3)
{
((Label)this.FindControl(_dataobjectcontrolinfo.ControlName)).Text = dataobjects[key.ToString()];
}
else
{
if (_dataobjct.RelationType == 2 && new UD_TableListBLL(_dataobjct.RelationTableName).Model.TreeFlag == "Y")
{
//关联到实体树形结构表时，显示全路径
int value = 0;
if (int.TryParse(dataobjects[key.ToString()], out value))
{
((Label)this.FindControl(_dataobjectcontrolinfo.ControlName)).Text = TreeTableBLL.GetFullPathName(_dataobjct.RelationTableName, value);
}
}
else
{
((Label)this.FindControl(_dataobjectcontrolinfo.ControlName)).Text = GetRelateTextByValue(_dataobjct, dataobjects[key.ToString()]);
}
}
break;
case 2:
case 5:
if (_dataobjct.RelationType == 3)
{
((TextBox)this.FindControl(_dataobjectcontrolinfo.ControlName)).Text = dataobjects[key.ToString()];
}
else
{
((TextBox)this.FindControl(_dataobjectcontrolinfo.ControlName)).Text = GetRelateTextByValue(_dataobjct, dataobjects[key.ToString()]);
}
break;
case 3:
if (dataobjects[key.ToString()] != "")
{
((DropDownList)this.FindControl(_dataobjectcontrolinfo.ControlName)).SelectedValue = dataobjects[key.ToString()];
}
break;
case 4:
if (dataobjects[key.ToString()] != "")
{
((RadioButtonList)this.FindControl(_dataobjectcontrolinfo.ControlName)).SelectedValue = dataobjects[key.ToString()];
}
break;
case 6: //带选择功能的控件
if (dataobjects[key.ToString()] != "")
{
((MCSSelectControl)this.FindControl(_dataobjectcontrolinfo.ControlName)).SelectValue = dataobjects[key.ToString()];
((MCSSelectControl)this.FindControl(_dataobjectcontrolinfo.ControlName)).SelectText = GetRelateTextByValue(_dataobjct, dataobjects[key.ToString()]);
}
break;
case 7:
if (dataobjects[key.ToString()] != "")
{
((MCSTreeControl)this.FindControl(_dataobjectcontrolinfo.ControlName)).SelectValue = dataobjects[key.ToString()];
}
break;
}
}
catch { }
}
}
private void BindData()
{
int id = (int)ViewState["ID"];
ORD_OrderDelivery m = new ORD_OrderDeliveryBLL(id).Model;
if (m == null)
{
Response.Redirect("OrderDeliveryList.aspx");
}
pn_OrderDelivery.BindData(m);
#region 绑定当前申请单的管理片区
Label lb_OrganizeCity = (Label)pn_OrderDelivery.FindControl("ORD_OrderDelivery_OrganizeCity");
lb_OrganizeCity.Text = TreeTableBLL.GetFullPathName("MCS_Sys.dbo.Addr_OrganizeCity", m.OrganizeCity);
tr_OrganizeCity.SelectValue = m.OrganizeCity.ToString();
tr_OrganizeCity.Enabled = false;
select_Client.PageUrl = "~/SubModule/CM/PopSearch/Search_SelectClient.aspx?ClientType=2&OrganizeCity=" + tr_OrganizeCity.SelectValue;
#endregion
#region 根据状态控制页面显示
switch (m.State)
{
case 1: //未发货
if (m.ApproveFlag == 2)
{ //未审核
BindOrderApplyCanDelivery();
pn_OrderDelivery.SetPanelVisible("Panel_LGS_OrderDeliveryDetail_02", false);
bt_ConfirmDelivery.Visible = false;
gv_OrderList.Columns[gv_OrderList.Columns.Count - 1].Visible = true;
}
else
{
bt_Approve.Visible = false;
tr_FeeApplyList.Visible = false;
bt_Save.Visible = false;
bt_Delete.Visible = false;
}
bt_ConfirmSignIn.Visible = false;
bNoDelivery = true;
pn_OrderDelivery.SetPanelVisible("Panel_LGS_OrderDeliveryDetail_03", false);
break;
case 2: //已发货
bt_Save.Visible = false;
bt_Delete.Visible = false;
bt_Approve.Visible = false;
bt_ConfirmDelivery.Visible = false;
tr_FeeApplyList.Visible = false;
bNoSignIn = true;
gv_OrderList.Columns[gv_OrderList.Columns.Count - 4].Visible = true;
gv_OrderList.Columns[gv_OrderList.Columns.Count - 3].Visible = true;
gv_OrderList.Columns[gv_OrderList.Columns.Count - 2].Visible = true;
pn_OrderDelivery.SetPanelEnable("Panel_LGS_OrderDeliveryDetail_02", false);
break;
case 3: //已签收
bt_Save.Visible = false;
bt_Delete.Visible = false;
bt_Approve.Visible = false;
bt_ConfirmDelivery.Visible = false;
bt_ConfirmSignIn.Visible = false;
tr_FeeApplyList.Visible = false;
bNoSignIn = false;
gv_OrderList.Columns[gv_OrderList.Columns.Count - 4].Visible = true;
gv_OrderList.Columns[gv_OrderList.Columns.Count - 3].Visible = true;
gv_OrderList.Columns[gv_OrderList.Columns.Count - 2].Visible = true;
pn_OrderDelivery.SetPanelEnable("Panel_LGS_OrderDeliveryDetail_02", false);
pn_OrderDelivery.SetPanelEnable("Panel_LGS_OrderDeliveryDetail_03", false);
break;
default:
break;
}
#endregion
BindGrid();
}
/// <summary>
/// 获取数据源
/// </summary>
/// <param name="ParamValue"></param>
/// <param name="CacheTime"></param>
/// <returns></returns>
public DataTable GetData(Dictionary <string, object> ParamValue, bool LoadFromCache, out DateTime CacheTime)
{
DataTable dt = null;
CacheTime = DateTime.Now;
if (LoadFromCache)
{
dt = Rpt_DataSet_DataCacheBLL.LoadDataSetCache(_m.ID, ParamValue, out CacheTime);
}
if (dt == null || dt.Rows.Count == 0)
{
SqlParameter[] param = MakeParams(ParamValue);
Rpt_DataSource source = new Rpt_DataSourceBLL(_m.DataSource).Model;
string conn = "";
if (source.ConnectionString != "")
{
conn = MCSFramework.Common.DataEncrypter.DecryptData(source.ConnectionString);
}
switch (_m.CommandType)
{
case 1:
dt = _dal.GetDataFromSQL(conn, _m.CommandText, param);
break;
case 2:
dt = _dal.GetDataFromStoreProcedure(conn, _m.CommandText, param);
break;
case 3:
Dictionary <string, Rpt_DataSetFields> dicTreeColumnList;
dt = _dal.GetDataFromSQL(conn, GenarateSelectSQL(out dicTreeColumnList), param);
#region 处理树形字段，显示指定层级的内容
for (int i = 0; i < dt.Columns.Count; i++)
{
DataColumn column = dt.Columns[i];
if (!dicTreeColumnList.ContainsKey(column.ColumnName))
{
continue;
}
DataColumn newcolumn = dt.Columns.Add("_" + column.ColumnName, Type.GetType("System.String"));
Rpt_DataSetFields field = dicTreeColumnList[column.ColumnName];
Dictionary <int, string> cachevalue = new Dictionary <int, string>();
foreach (DataRow row in dt.Rows)
{
int value = 0;
if (int.TryParse(row[column].ToString(), out value))
{
if (cachevalue.ContainsKey(value))
{
row[newcolumn] = cachevalue[value];
}
else
{
if (field.TreeLevel == 100)
{
//显示全路径
row[newcolumn] = TreeTableBLL.GetFullPathName(new UD_ModelFieldsBLL(field.FieldID, true).Model.RelationTableName, value);
}
else
{
//显示父级
if (field.DisplayMode == 1)
{
row[newcolumn] = TreeTableBLL.GetSuperIDByLevel(new UD_ModelFieldsBLL(field.FieldID, true).Model.RelationTableName, value, field.TreeLevel).ToString();
}
else
{
row[newcolumn] = TreeTableBLL.GetSuperNameByLevel(new UD_ModelFieldsBLL(field.FieldID, true).Model.RelationTableName, value, field.TreeLevel);
}
}
cachevalue.Add(value, row[newcolumn].ToString());
}
}
}
int order = column.Ordinal;
dt.Columns.Remove(column);
newcolumn.SetOrdinal(order);
newcolumn.ColumnName = newcolumn.ColumnName.Substring(1);
}
#endregion
break;
default:
break;
}
if (_m.CommandType == 1 || _m.CommandType == 2)
{
#region 加入计算列字段
IList <Rpt_DataSetFields> computefields = this.GetFields().Where(p => p.IsComputeField == "Y").ToList();
foreach (Rpt_DataSetFields field in computefields)
{
Type ColumnType;
switch (field.DataType)
{
case 1: //整型(int)
ColumnType = Type.GetType("System.Int32");
break;
case 2: //小数(decimal)
ColumnType = Type.GetType("System.Decimal");
break;
case 3: //字符串(varchar)
case 6: //字符串(nvarchar)
ColumnType = Type.GetType("System.String");
break;
case 4: //日期(datetime)
ColumnType = Type.GetType("System.DateTime");
break;
case 5: //GUID(uniqueidentifier)
ColumnType = Type.GetType("System.Guid");
break;
default:
ColumnType = Type.GetType("System.Decimal");
break;
}
try
{
dt.Columns.Add(field.FieldName, ColumnType, field.Expression);
}
catch { }
}
#endregion
}
if (dt != null && dt.Rows.Count < 200000) //只对20万行以下的数据表进行缓存
{
try
{
Rpt_DataSet_DataCacheBLL.SaveDataSetCache(_m.ID, ParamValue, dt);
CacheTime = DateTime.Now;
}
catch { System.GC.Collect(); }
}
}
return(dt);
}
private void BindData()
{
int id = (int)ViewState["ID"];
ORD_OrderApply apply = new ORD_OrderApplyBLL(id).Model;
if (apply == null)
{
Response.Redirect("OrderApplyList.aspx");
}
if (apply["ProductType"] != "1")
{
priceEnable = true;
}
pn_OrderApply.BindData(apply);
ViewState["Type"] = apply.Type;
int month = new AC_AccountMonthBLL(apply.AccountMonth).Model.Month;
ORD_OrderLimitFactorBLL limitbll = new ORD_OrderLimitFactorBLL();
ViewState["Limit"] = limitbll.GetLimitInfo(apply.AccountMonth, apply.Client);
#region 绑定当前申请单的管理片区
Label lb_OrganizeCity = (Label)pn_OrderApply.FindControl("ORD_OrderApply_OrganizeCity");
lb_OrganizeCity.Text = TreeTableBLL.GetFullPathName("MCS_Sys.dbo.Addr_OrganizeCity", apply.OrganizeCity);
#endregion
#region 根据审批状态控制页面
if (apply.State != 1 && apply.State != 8)
{
//提交 状态
pn_OrderApply.SetControlsEnable(false);
gv_ProductList.Columns[0].Visible = false; //选择 列
gv_ProductList.Columns[gv_ProductList.Columns.Count - 1].Visible = false; //删除 列
bt_Save.Visible = false;
bt_Submit.Visible = false;
bt_Delete.Visible = false;
//可见调整数量及原因
gv_ProductList.Columns[gv_ProductList.Columns.Count - 4].Visible = true; //调整原因
gv_ProductList.Columns[gv_ProductList.Columns.Count - 5].Visible = true; //调整金额
bt_SaveAdjust.Visible = false;
}
if (apply.State == 2)
{
bt_SaveAdjust.Visible = false;
///已提交状态，审批过程中，可以作申请数量调整
if (Request.QueryString["Decision"] != "" && Request.QueryString["Decision"] == "Y")
{
bt_SaveAdjust.Visible = true;
}
}
if (apply.State >= 3)
{
bt_SaveAdjust.Visible = false;
//审批通过
gv_ProductList.Columns[gv_ProductList.Columns.Count - 3].Visible = true; //已发放数量
}
#endregion
BindGrid();
}
public static string GetFullCategoryName(int ID)
{
return(TreeTableBLL.GetFullPathName("MCS_PUB.dbo.PDT_Category", ID));
}
protected void bt_AddDetail_Click(object sender, EventArgs e)
{
SaveDataTable();
if (ddl_WorkingClassify.SelectedValue == "0")
{
MessageBox.Show(this, "请先选择要增加的工作类型!");
return;
}
else if (ddl_WorkingClassify.SelectedValue == "1" && string.IsNullOrEmpty(select_RelateClient.SelectValue))
{
MessageBox.Show(this, "请先选择你要拜访的客户!");
return;
}
else if (ddl_WorkingClassify.SelectedValue == "2" && string.IsNullOrEmpty(select_RelateStaff.SelectValue))
{
MessageBox.Show(this, "请先选择你要协同拜访的员工!");
return;
}
DateTime begindate = DateTime.Parse(tbx_Begin.Text);
DateTime enddate = DateTime.Parse(tbx_End.Text);
if (begindate < (DateTime)ViewState["BeginDate"])
{
MessageBox.Show(this, "本工作项的开始日期不能小于整个计划开始日期!");
return;
}
if (enddate > (DateTime)ViewState["EndDate"])
{
MessageBox.Show(this, "本工作项的截止日期不能大于整个计划截止日期!");
return;
}
if (ViewState["WorkingPlanData"] != null)
{
DataTable dt = (DataTable)ViewState["WorkingPlanData"];
DataRow dr = dt.NewRow();
dr["WorkingClassify"] = int.Parse(ddl_WorkingClassify.SelectedValue);
dr["WorkingClassifyName"] = ddl_WorkingClassify.SelectedItem.Text;
switch (ddl_WorkingClassify.SelectedValue)
{
case "1":
#region 增加客户拜访计划
{
if (select_RelateClient.SelectValue == "" || select_RelateClient.SelectValue == "0")
{
MessageBox.Show(this, "请选择要拜访的客户！");
return;
}
if (dt.Select("WorkingClassify=1 AND RelateClient=" + select_RelateClient.SelectValue).Length > 0)
{
MessageBox.Show(this, "对不起，列表中已有相同的行了，不能重复添加！");
return;
}
dr["RelateClient"] = int.Parse(select_RelateClient.SelectValue);
dr["RelateClientName"] = select_RelateClient.SelectText;
dr["RelateStaff"] = 0;
}
#endregion
break;
case "2":
#region 循环增加协同拜访员工计划
{
int staffid = 0;
if (!int.TryParse(select_RelateStaff.SelectValue, out staffid))
{
return;
}
if (staffid == int.Parse(select_PlanStaff.SelectValue))
{
return;
}
Org_Staff staff = new Org_StaffBLL(staffid).Model;
if (staff == null)
{
return;
}
if (dt.Select("WorkingClassify=2 AND RelateStaff=" + staffid.ToString()).Length > 0)
{
MessageBox.Show(this, "对不起，列表中已有相同的行了，不能重复添加！");
return;
}
;
dr["RelateStaff"] = staffid;
dr["RelateStaffName"] = staff.RealName;
dr["RelateClient"] = 0;
if (staff.OfficialCity > 1)
{
dr["OfficialCity"] = staff.OfficialCity;
dr["OfficialCityName"] = TreeTableBLL.GetFullPathName("MCS_SYS.dbo.Addr_OfficialCity", staff.OfficialCity).Replace("->", " ");;
}
dt.Rows.Add(dr);
}
#endregion
break;
default:
#region 增加其他工作计划
{
if (dt.Select("WorkingClassify=" + ddl_WorkingClassify.SelectedValue +
" AND Description='" + tbx_Description.Text +
"' AND OfficialCity=" + tr_OfficailCity.SelectValue).Length > 0)
{
MessageBox.Show(this, "对不起，列表中已有相同的行了，不能重复添加！");
return;
}
dr["RelateStaff"] = 0;
dr["RelateClient"] = 0;
dr["Description"] = tbx_Description.Text;
}
#endregion
break;
}
if (!string.IsNullOrEmpty(tr_OfficailCity.SelectValue) && tr_OfficailCity.SelectValue != "0")
{
dr["OfficialCity"] = int.Parse(tr_OfficailCity.SelectValue);
dr["OfficialCityName"] = new Addr_OfficialCityBLL(int.Parse(tr_OfficailCity.SelectValue)).Model.Name;
}
if (tbx_Cost1.Text != "")
{
dr["Cost1"] = decimal.Parse(tbx_Cost1.Text);
}
else
{
dr["Cost1"] = 0;
}
if (tbx_Cost2.Text != "")
{
dr["Cost2"] = decimal.Parse(tbx_Cost2.Text);
}
else
{
dr["Cost2"] = 0;
}
DateTime day = begindate;
while (day <= enddate)
{
dr["P" + day.ToString("MMdd")] = true;
day = day.AddDays(1);
}
dt.Rows.Add(dr);
#region 清空已录入的工作计划数据，以便下次再录
select_RelateStaff.SelectValue = "";
select_RelateStaff.SelectText = "";
select_RelateClient.SelectValue = "";
select_RelateClient.SelectText = "";
if (ViewState["StaffOfficialCity"] != null)
{
tr_OfficailCity.SelectValue = ViewState["StaffOfficialCity"].ToString();
}
#endregion
cb_DisplayCheckedOnly.Checked = false;
BindGrid();
}
}
public void BindGrid()
{
FillDataSource();
DataBind();
Binded = true;
if (PanelCode != "" && ViewState["TreeColumn"] != null)
{
Dictionary <string, UD_Panel_ModelFields> dicTreeColumnList = (Dictionary <string, UD_Panel_ModelFields>)ViewState["TreeColumn"];
for (int i = 0; i < Columns.Count; i++)
{
DataControlField column = Columns[i];
if (column.GetType().Name == "BoundField")
{
BoundField field = (BoundField)column;
if (!column.Visible)
{
continue;
}
foreach (GridViewRow row in Rows)
{
if (row.Cells[i].Text.StartsWith("1900-01-01"))
{
row.Cells[i].Text = "";
}
}
if (!dicTreeColumnList.ContainsKey(field.DataField))
{
continue;
}
UD_Panel_ModelFields _panel_modelfields = dicTreeColumnList[field.DataField];
Dictionary <int, string> cachevalue = new Dictionary <int, string>();
foreach (GridViewRow row in Rows)
{
int value = 0;
if (int.TryParse(row.Cells[i].Text, out value))
{
if (cachevalue.ContainsKey(value))
{
row.Cells[i].Text = cachevalue[value];
}
else
{
if (_panel_modelfields.TreeLevel == 100)
{
//显示全路径
row.Cells[i].Text = TreeTableBLL.GetFullPathName(new UD_ModelFieldsBLL(_panel_modelfields.FieldID, true).Model.RelationTableName, value);
}
else
{
//显示父级
if (_panel_modelfields.DisplayMode == 1)
{
row.Cells[i].Text = TreeTableBLL.GetSuperIDByLevel(new UD_ModelFieldsBLL(_panel_modelfields.FieldID, true).Model.RelationTableName, value, _panel_modelfields.TreeLevel).ToString();
}
else
{
row.Cells[i].Text = TreeTableBLL.GetSuperNameByLevel(new UD_ModelFieldsBLL(_panel_modelfields.FieldID, true).Model.RelationTableName, value, _panel_modelfields.TreeLevel);
}
}
cachevalue.Add(value, row.Cells[i].Text);
}
}
}
}
}
}
}
protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
if (ViewState["Staff"] != null && (int)ViewState["Staff"] > 0)
{
e.Cell.HorizontalAlign = HorizontalAlign.Left;
if (e.Day.Date <= DateTime.Today && MCSTabControl1.SelectedIndex == 0)
{
ImageButton ibt = new ImageButton();
ibt.ImageUrl = "~/Images/gif/gif-0489.gif";
ibt.BorderWidth = new Unit(0);
ibt.ToolTip = "新增工作日志";
ibt.OnClientClick = "javascript:NewJournal('" + e.Day.Date.DayOfYear.ToString() + "')";
ibt.Click += new ImageClickEventHandler(ibt_Click);
e.Cell.Controls.Add(ibt);
}
#region 获取该员工当天工作日志
if (cbx_Journal.Checked)
{
IList <JN_Journal> journallists = JN_JournalBLL.GetModelList("'" + e.Day.Date.ToString("yyyy-MM-dd") + "' BETWEEN Convert(varchar(10),BeginTime,120) And EndTime AND Staff=" + ViewState["Staff"].ToString());
if (journallists.Count > 0)
{
BulletedList bt = new BulletedList();
foreach (JN_Journal j in journallists)
{
ListItem item = new ListItem();
item.Text = "";
if (j.JournalType == 1)
{
//日报
if (j.BeginTime.Hour != 0 && j.EndTime.Hour != 0)
{
item.Text += j.BeginTime.ToString("HH:mm") + "~" + j.EndTime.ToString("HH:mm") + " ";
}
if (j.WorkingClassify != 0)
{
item.Text += DictionaryBLL.GetDicCollections("OA_WorkingClassify")[j.WorkingClassify.ToString()].Name + " ";
switch (j.WorkingClassify)
{
case 1: //门店拜访
if (j.RelateClient != 0)
{
//门店拜访
CM_Client client = new CM_ClientBLL(j.RelateClient).Model;
if (client != null)
{
item.Text += client.ShortName + " ";
}
if (j["VisitClientPurpose"] != "" && j["VisitClientPurpose"] != "0")
{
item.Text += DictionaryBLL.GetDicCollections("OA_JN_VisitClientPurpose")[j["VisitClientPurpose"]].Name + " ";
}
}
break;
case 2: //协同拜访
if (j.RelateStaff != 0)
{
Org_Staff staff = new Org_StaffBLL(j.RelateStaff).Model;
if (staff != null)
{
item.Text += staff.RealName;
}
}
break;
default:
item.Text += j.Title;
break;
}
}
else
{
item.Text += j.Title;
}
}
else
{
//周报、月报
item.Text += DictionaryBLL.GetDicCollections("OA_JournalType")[j.JournalType.ToString()].Name + " ";
item.Text += j.Title;
}
item.Value = "javascript:OpenJournal(" + j.ID.ToString() + ")";
bt.Items.Add(item);
}
bt.DisplayMode = BulletedListDisplayMode.HyperLink;
bt.BulletImageUrl = "~/Images/gif/gif-0162.gif";
bt.BulletStyle = BulletStyle.CustomImage;
bt.CssClass = "calaitem";
e.Cell.Controls.Add(bt);
}
}
#endregion
#region 获取访员工当天的工作计划
if (cbx_Plan.Checked)
{
if (ViewState["PlanDetails"] == null || ((IList <JN_WorkingPlanDetail>)ViewState["PlanDetails"]).Where
(p => (p.BeginTime.Date <= e.Day.Date && p.EndTime.Date >= e.Day.Date)).Count() == 0)
{
IList <JN_WorkingPlan> plans = JN_WorkingPlanBLL.GetModelList("'" + e.Day.Date.ToString("yyyy-MM-dd") +
"' BETWEEN BeginDate AND EndDate AND Staff=" + ViewState["Staff"].ToString());
if (plans.Count > 0)
{
IList <JN_WorkingPlanDetail> plandetails = new JN_WorkingPlanBLL(plans[0].ID).Items;
ViewState["PlanDetails"] = plandetails;
}
else
{
ViewState["PlanDetails"] = null;
}
}
if (ViewState["PlanDetails"] != null)
{
IList <JN_WorkingPlanDetail> plandetails = (IList <JN_WorkingPlanDetail>)ViewState["PlanDetails"];
BulletedList bt = new BulletedList();
foreach (JN_WorkingPlanDetail plan in plandetails.Where(p => (p.BeginTime.Date <= e.Day.Date && p.EndTime.Date >= e.Day.Date)))
{
ListItem item = new ListItem();
item.Text = "";
if (plan.WorkingClassify == 0)
{
continue;
}
item.Text += DictionaryBLL.GetDicCollections("OA_WorkingClassify")[plan.WorkingClassify.ToString()].Name + " ";
switch (plan.WorkingClassify)
{
case 1: //门店拜访
if (plan.RelateClient != 0)
{
//门店拜访
CM_Client client = new CM_ClientBLL(plan.RelateClient).Model;
if (client != null)
{
item.Text += client.ShortName + " ";
}
}
break;
case 2: //协同拜访
if (plan.RelateStaff != 0)
{
Org_Staff staff = new Org_StaffBLL(plan.RelateStaff).Model;
if (staff != null)
{
item.Text += staff.RealName + " ";
}
}
break;
default:
item.Text += plan.Description + " ";
break;
}
if (plan.OfficialCity > 1)
{
item.Text += TreeTableBLL.GetFullPathName("MCS_SYS.dbo.Addr_OfficialCity", plan.OfficialCity).Replace("->", "");
}
bt.Items.Add(item);
}
bt.DisplayMode = BulletedListDisplayMode.Text;
bt.BulletImageUrl = "~/Images/gif/gif-0163.gif";
bt.BulletStyle = BulletStyle.CustomImage;
bt.CssClass = "calaitem";
e.Cell.Controls.Add(bt);
}
}
#endregion
}
}
/// <summary>
/// Bind data to the control from the special model
/// </summary>
/// <param name="_model"></param>
public void BindData(IModel _model)
{
if (_model == null || _model["ID"] == string.Empty)
{
return;
}
foreach (object _key in FieldControlsInfo.Keys)
{
FieldControlInfo fieldcontrolinfo = (FieldControlInfo)FieldControlsInfo[_key];
string fieldname = fieldcontrolinfo.FieldName;
if (fieldcontrolinfo.ModelName == _model.ModelName)
{
try
{
UD_Panel_ModelFields _panelfield = new UD_Panel_ModelFieldsBLL(fieldcontrolinfo.Panel_Field_ID, true).Model;
UD_ModelFields _modelfield = new UD_ModelFieldsBLL(fieldcontrolinfo.FieldID, true).Model;
string _formatstring = _panelfield.FormatString;
switch (fieldcontrolinfo.ControlType)
{
case 1: //Label控件
//判断是否显示关联表的文本值
if (fieldcontrolinfo.DisplayMode == 1)
{
if (_modelfield.DataType == 1)
{
((Label)this.FindControl((string)_key)).Text = int.Parse(_model[fieldname]).ToString(_formatstring);
}
else if (_modelfield.DataType == 2)
{
((Label)this.FindControl((string)_key)).Text = decimal.Parse(_model[fieldname]).ToString(_formatstring);
}
else if (_modelfield.DataType == 4)
{
if (DateTime.Parse(_model[fieldname]) != new DateTime(1900, 1, 1))
{
((Label)this.FindControl((string)_key)).Text = DateTime.Parse(_model[fieldname]).ToString(_formatstring);
}
}
else
{
((Label)this.FindControl((string)_key)).Text = _model[fieldname];
}
}
else
{
if (_panelfield.TreeLevel > 0 && new UD_TableListBLL(_modelfield.RelationTableName).Model.TreeFlag == "Y")
{
#region 字段关联到树形结构表，且要显示上层父结点信息
int value = 0;
if (int.TryParse(_model[fieldname], out value))
{
if (_panelfield.TreeLevel == 100)
{
//显示全路径
((Label)this.FindControl((string)_key)).Text = TreeTableBLL.GetFullPathName(_modelfield.RelationTableName, value);
}
else
{
//显示父级
((Label)this.FindControl((string)_key)).Text = TreeTableBLL.GetSuperNameByLevel(_modelfield.RelationTableName, value, _panelfield.TreeLevel);
}
}
#endregion
}
else
{
((Label)this.FindControl((string)_key)).Text = GetRelateTextByValue(_modelfield, _model[fieldname]);
}
}
break;
case 2: //TextBox
case 5: //MultiRowTextBox
if (_modelfield.DataType == 1)
{
((TextBox)this.FindControl((string)_key)).Text = int.Parse(_model[fieldname]).ToString(_formatstring);
}
else if (_modelfield.DataType == 2)
{
((TextBox)this.FindControl((string)_key)).Text = decimal.Parse(_model[fieldname]).ToString(_formatstring);
}
else if (_modelfield.DataType == 4)
{
if (DateTime.Parse(_model[fieldname]) != new DateTime(1900, 1, 1))
{
((TextBox)this.FindControl((string)_key)).Text = DateTime.Parse(_model[fieldname]).ToString(_formatstring);
}
}
else
{
((TextBox)this.FindControl((string)_key)).Text = _model[fieldname];
}
break;
case 3: //DropDownList
if (_model[fieldname] != "")
{
((DropDownList)this.FindControl((string)_key)).SelectedValue = _model[fieldname];
}
break;
case 4: //RadioButtonList
if (_model[fieldname] != "")
{
((RadioButtonList)this.FindControl((string)_key)).SelectedValue = _model[fieldname];
}
break;
case 6: //带选择功能的控件
if (_model[fieldname] != "")
{
((MCSSelectControl)this.FindControl((string)_key)).SelectValue = _model[fieldname];
((MCSSelectControl)this.FindControl((string)_key)).SelectText = GetRelateTextByValue(_modelfield, _model[fieldname]);
}
break;
case 7: //树形选择控件
if (_model[fieldname] != "")
{
((MCSTreeControl)this.FindControl((string)_key)).SelectValue = _model[fieldname];
}
break;
}
}
catch { }
}
}
}