public void LoadReportData()
{
//抓到主要報表
TB_Report lReMain = Tool.GetNowReport((TB_User)Session[GlobalInfo.Session_User]).FirstOrDefault();
DateTime dt = DateTime.Now;
using (var en = new WeekReportEntities())
{
//抓到訂單報表
TB_OrderReport Order = en.TB_OrderReport
.Where(p => p.OrderReID == lReMain.OrderReID)
.FirstOrDefault();
//抓到對應的配件報表
TB_CarAssRe CarAss = en.TB_CarAssRe.Where(p => p.CarAssReID == lReMain.CarAssReID).FirstOrDefault();
if (CarAss != null)
{
txtRefinementNum.Text = CarAss.RefinementNum.ToString();
txtVAudioNum.Text = CarAss.VAudioNum.ToString();
lbRefinePush.Text = ((decimal)CarAss.RefinementNum / (decimal)(Order.OrderedCount * 0.8) * 100).ToString("00.00");
lbVAudioPush.Text = ((decimal)CarAss.VAudioNum / (decimal)(Order.OrderedCount * 0.5) * 100).ToString("00.00");
txtRefineDetail.Text = CarAss.RefineDetail;
txtAssProNum.Text = CarAss.AssProNum.ToString();
txtPDSProNum.Text = CarAss.PDSProNum.ToString();
txtOtherProDetail.Text = CarAss.OthersProDetail;
txtSelfNum.Text = CarAss.SelfNumber.ToString();
}
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
using (var en = new WeekReportEntities())
{
//var dd = en.Table_2.ToList();
TB_User user = (from q in en.TB_User
where q.Acc == txtAcc.Text && q.pass == txtCode.Text
select q).FirstOrDefault();
if (user != null)
{
Session[GlobalInfo.Session_User] = user;
if (user.lv == 3)
{
Response.Redirect("~/L2/FrmL2Bridge.aspx");
}
if (user.lv == 2)
{
Response.Redirect("~/L1/L1Bridge.aspx");
}
if (user.lv == 1)
{
Response.Redirect("~/UserInput/FrmUserInputBrige.aspx");
}
}
else
{
Response.Write("沒有此帳號或是密碼錯誤");
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
var lR = GetMainReport().FirstOrDefault();
using (var en = new WeekReportEntities())
{
var OldCarReport = en.TB_OldCarSaleRe.Where(p => p.OldCarSaleReID == lR.OldCarSaleReID).FirstOrDefault();
if (OldCarReport != null)
{
OldCarReport.ChangeBuy = int.Parse(txtChangeBuy.Text);
OldCarReport.BuyEx = int.Parse(txtBuyEx.Text);
OldCarReport.DealNum = int.Parse(txtDealNum.Text);
OldCarReport.FailDealDetail = txtFailDealDetail.Text;
OldCarReport.SelfNumber = int.Parse(txtSelfNumber.Text);
en.SaveChanges();
}
else
{
en.TB_OldCarSaleRe.Add(new TB_OldCarSaleRe
{
OldCarSaleReID = lR.OldCarSaleReID,
ChangeBuy = int.Parse(txtChangeBuy.Text),
BuyEx = int.Parse(txtBuyEx.Text),
DealNum = int.Parse(txtDealNum.Text),
FailDealDetail = txtFailDealDetail.Text,
SelfNumber = int.Parse(txtSelfNumber.Text)
});
en.SaveChanges();
}
}
}
//儲存表單
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
List <TB_Report> lRe = GetMainReport();
string OrIDFromMainRe = lRe.FirstOrDefault().OrderReID;
using (var en = new WeekReportEntities())
{
TB_OrderReport Order = en.TB_OrderReport.Where(p => p.OrderReID == OrIDFromMainRe).FirstOrDefault();
if (Order == null)
{
en.TB_OrderReport.Add(new TB_OrderReport
{
OrderReID = OrIDFromMainRe,
OrderedCount = int.Parse(txtOrderCount.Text),
SaleCount = int.Parse(txtSaleCount.Text),
OnControl = int.Parse(txtOnControl.Text),
Expectations = int.Parse(txtExpectation.Text),
OrderDetail = txtOrderDetail.Text,
WeekCar = txtWeekCar.Text,
UnorderDetail = txtUnOrderDetail.Text,
Others = txtOthers.Text,
SelfNumber = int.Parse(txtSelfnumber.Text)
});
en.SaveChanges();
}
else
{
Order.OrderedCount = int.Parse(txtOrderCount.Text);
Order.SaleCount = int.Parse(txtSaleCount.Text);
Order.OnControl = int.Parse(txtOnControl.Text);
Order.Expectations = int.Parse(txtExpectation.Text);
Order.OrderDetail = txtOrderDetail.Text;
Order.WeekCar = txtWeekCar.Text;
Order.UnorderDetail = txtUnOrderDetail.Text;
Order.Others = txtOthers.Text;
Order.SelfNumber = int.Parse(txtSelfnumber.Text);
en.SaveChanges();
}
this.LoadReportData();
}
}
catch (Exception ex)
{
ErrorManage.Show(ex.ToString());
}
}
/// <summary>
/// 抓出某課所有的報表
/// </summary>
/// <param name="p_User"></param>
/// <returns></returns>
public static List <TB_Report> ShowOldReport(TB_User p_User)
{
using (var en = new WeekReportEntities())
{
//end必須從新設定
List <TB_Report> data = (from q in en.TB_Report
where q.Bureau == p_User.Bureau &&
q.Class == p_User.Class
select q).ToList();
return(data);
}
}
/// <summary>
/// 取出某課當周的主報表
/// </summary>
/// <param name="p_User"></param>
/// <returns></returns>
public static List <TB_Report> GetNowReport(TB_User p_User)
{
using (var en = new WeekReportEntities())
{
List <TB_Report> data = (from q in en.TB_Report
where q.Bureau == p_User.Bureau &&
q.Class == p_User.Class &&
q.TimeStart <= DateTime.Now &&
q.TimeEnd >= DateTime.Now
select q).ToList();
return(data);
}
}
/// <summary>
/// 抓出本周所有課報表
/// </summary>
/// <param name="p_User"></param>
/// <returns></returns>
public static List <TB_Report> GeAllClasstMainReport(TB_User p_User)
{
using (var en = new WeekReportEntities())
{
TB_User user = p_User;
//end必須從新設定
List <TB_Report> data = (from q in en.TB_Report
where q.Bureau == user.Bureau &&
q.TimeStart <= DateTime.Now &&
q.TimeEnd >= DateTime.Now
select q).ToList();
return(data);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
using (var en = new WeekReportEntities())
{
TB_Report ReMain = Tool.GetNowReport((TB_User)Session[GlobalInfo.Session_User]).FirstOrDefault();
TB_CarAssRe CarAssRe = en.TB_CarAssRe.Where(p => p.CarAssReID == ReMain.CarAssReID).FirstOrDefault();
if (CarAssRe != null)
{
CarAssRe.RefinementNum = Convert.ToInt32(txtRefinementNum.Text);
CarAssRe.VAudioNum = Convert.ToInt32(txtVAudioNum.Text);
CarAssRe.RefineDetail = txtRefineDetail.Text;
CarAssRe.AssProNum = Convert.ToInt32(txtAssProNum.Text);
CarAssRe.PDSProNum = Convert.ToInt32(txtPDSProNum.Text);
CarAssRe.OthersProDetail = txtOtherProDetail.Text;
CarAssRe.SelfNumber = Convert.ToInt32(txtSelfNum.Text);
en.SaveChanges();
}
else
{
en.TB_CarAssRe.Add(new TB_CarAssRe
{
CarAssReID = ReMain.CarAssReID,
RefinementNum = Convert.ToInt32(txtRefinementNum.Text),
VAudioNum = Convert.ToInt32(txtVAudioNum.Text),
RefineDetail = txtRefineDetail.Text,
AssProNum = Convert.ToInt32(txtAssProNum.Text),
PDSProNum = Convert.ToInt32(txtPDSProNum.Text),
OthersProDetail = txtOtherProDetail.Text,
SelfNumber = Convert.ToInt32(txtSelfNum.Text)
});
en.SaveChanges();
}
LoadReportData();
}
}
catch (Exception ex)
{
ErrorManage.Show(ex.ToString());
}
}
public void LoadReportData()
{
List <TB_Report> lRe = GetMainReport();
DateTime dt = DateTime.Now;
string OrIDFromMainRe = lRe.FirstOrDefault().OrderReID;
using (var en = new WeekReportEntities())
{
TB_OrderReport Order = en.TB_OrderReport.Where(p => p.OrderReID == OrIDFromMainRe).FirstOrDefault();
TB_User user = ((TB_User)Session[GlobalInfo.Session_User]);
//月目標
int goal = (int)en.TB_MonthGoal.Where(p => p.Bureau == user.Bureau &&
p.Class == user.Class &&
p.yyyy == DateTime.Now.Year &&
p.mm == DateTime.Now.Month).FirstOrDefault().OrderNum;
lbMonthGoal.Text = goal.ToString();
//有資料時候輸出網頁
if (Order != null)
{
txtOrderCount.Text = Order.OrderedCount.ToString();
txtSaleCount.Text = Order.SaleCount.ToString();
txtOnControl.Text = Order.OnControl.ToString();
txtExpectation.Text = Order.Expectations.ToString();
lbIdeaRate.Text = (((goal * 100 / DateTime.DaysInMonth(dt.Year, dt.Month)) * dt.Day) / goal).ToString() + "%";
lbOrderRate.Text = (Order.OrderedCount * 100 / goal).ToString() + "%";
lbSaleRate.Text = (Order.SaleCount * 100 / goal).ToString() + "%";
lbControlRate.Text = (Order.OnControl * 100 / goal).ToString() + "%";
lbExpectRate.Text = (Order.Expectations * 100 / goal).ToString() + "%";
txtWeekCar.Text = Order.WeekCar;
txtOrderDetail.Text = Order.OrderDetail;
txtUnOrderDetail.Text = Order.UnorderDetail;
txtOthers.Text = Order.Others;
txtSelfnumber.Text = Order.SelfNumber.ToString();
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
using (var en = new WeekReportEntities())
{
TB_Report ReMain = Tool.GetNowReport((TB_User)Session[GlobalInfo.Session_User]).FirstOrDefault();
TB_HumanRe HumanRe = en.TB_HumanRe.Where(p => p.HumanResourceReID == ReMain.HumanManageReID).FirstOrDefault();
if (HumanRe == null)
{
en.TB_HumanRe.Add(new TB_HumanRe
{
HumanResourceReID = ReMain.HumanManageReID,
PeopleNeed = Convert.ToInt32(txtHumanLess.Text),
Interview = Convert.ToInt32(txtInterview.Text),
NewEmpDetail = txtObservation.Text,
SpecialEmp = txtWeekPeople.Text,
WeekGoodEmp = txtGoodSales.Text,
SelfNumber = Convert.ToInt32(txtSelfNumber.Text)
});
en.SaveChanges();
}
else
{
HumanRe.PeopleNeed = Convert.ToInt32(txtHumanLess.Text);
HumanRe.Interview = Convert.ToInt32(txtInterview.Text);
HumanRe.NewEmpDetail = txtObservation.Text;
HumanRe.SpecialEmp = txtWeekPeople.Text;
HumanRe.WeekGoodEmp = txtGoodSales.Text;
HumanRe.SelfNumber = Convert.ToInt32(txtSelfNumber.Text);
en.SaveChanges();
}
}
}
catch (Exception ex)
{
ErrorManage.Show(ex.ToString());
}
}
public void LoadReportData()
{
//抓到主要報表
TB_Report lReMain = Tool.GetNowReport((TB_User)Session[GlobalInfo.Session_User]).FirstOrDefault();
using (var en = new WeekReportEntities())
{
TB_HumanRe HumanRe = en.TB_HumanRe.Where(p => p.HumanResourceReID == lReMain.HumanManageReID).FirstOrDefault();
if (HumanRe != null)
{
txtHumanLess.Text = HumanRe.PeopleNeed.ToString();
txtInterview.Text = HumanRe.Interview.ToString();
txtObservation.Text = HumanRe.NewEmpDetail;
txtWeekPeople.Text = HumanRe.SpecialEmp;
txtGoodSales.Text = HumanRe.WeekGoodEmp;
txtSelfNumber.Text = HumanRe.SelfNumber.ToString();
}
}
}
//建立一個新的周報表
protected void BtnStartClick(object sender, EventArgs e)
{
try
{
TB_User user = ((TB_User)Session[GlobalInfo.Session_User]);
using (var en = new WeekReportEntities())
{
//新增報表
en.TB_Report.Add(new TB_Report
{
TimeStart = GetTime0((DateTime)Session[GlobalInfo.Session_StartTime]),
TimeEnd = GetTime1((DateTime)Session[GlobalInfo.Session_EndTime]),
Bureau = user.Bureau,
Class = user.Class,
Writer = user.name,
//給編號 所別+課別+起始日
OrderReID = user.Bureau + user.Class + "Or" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("-", "").Replace(":", ""),
InsurenceReID = user.Bureau + user.Class + "In" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("-", "").Replace(":", ""),
OldCarSaleReID = user.Bureau + user.Class + "Ol" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("-", "").Replace(":", ""),
CarAssReID = user.Bureau + user.Class + "Ca" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("-", "").Replace(":", ""),
HumanManageReID = user.Bureau + user.Class + "Hu" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("-", "").Replace(":", "")
});
en.SaveChanges();
}
if (CheckExist())
{
btnStart.Enabled = false;
btnCa.Enabled = true;
btnHu.Enabled = true;
btnIn.Enabled = true;
btnOl.Enabled = true;
btnOr.Enabled = true;
}
}
catch (Exception ex)
{
ErrorManage.Show(ex.ToString());
}
}
public void LoadReportData()
{
List <TB_Report> lR = GetMainReport();
var mainReport = lR.FirstOrDefault();
TB_User user = ((TB_User)Session[GlobalInfo.Session_User]);
using (var en = new WeekReportEntities())
{
var OldCarReport = en.TB_OldCarSaleRe.Where(p => p.OldCarSaleReID == mainReport.OldCarSaleReID).FirstOrDefault();
if (OldCarReport != null)
{
txtChangeBuy.Text = OldCarReport.ChangeBuy.ToString();
txtBuyEx.Text = OldCarReport.BuyEx.ToString();
txtDealNum.Text = OldCarReport.DealNum.ToString();
txtFailDealDetail.Text = OldCarReport.FailDealDetail;
txtSelfNumber.Text = OldCarReport.SelfNumber.ToString();
}
}
}
//抓出報表主檔
public List <TB_Report> GetMainReport()
{
using (var en = new WeekReportEntities())
{
TB_User user = ((TB_User)Session[GlobalInfo.Session_User]);
//end必須從新設定
List <TB_Report> data = (from q in en.TB_Report
where q.Bureau == user.Bureau &&
q.Class == user.Class &&
q.TimeStart <= DateTime.Now &&
q.TimeEnd >= DateTime.Now
select q).ToList();
//偵錯
if (data.Count() > 1)
{
ErrorManage.Show("比數大於二有問題");
}
return(data);
}
}
//true 已經有資料
public bool CheckExist()
{
TB_User user = ((TB_User)Session[GlobalInfo.Session_User]);
using (var en = new WeekReportEntities())
{
//end必須從新設定
List <TB_Report> data = (from q in en.TB_Report
where q.Bureau == user.Bureau &&
q.Class == user.Class &&
q.TimeStart <= DateTime.Now &&
q.TimeEnd >= DateTime.Now
select q).ToList();
if (data.Count() != 0)
{
return(true);
}
else
{
return(false);
}
}
}
public void ShowData()
{
int reID = (int)Session[GlobalInfo.Session_ShowAllParam];
using (var en = new WeekReportEntities())
{
//抓到目前的報表主檔
TB_Report MainRe = en.TB_Report.Where(p => p.ReportID == reID).FirstOrDefault();
//目前報表當月目標
TB_MonthGoal MonthGoal = en.TB_MonthGoal.Where(p => p.Bureau == MainRe.Bureau &&
p.Class == MainRe.Class &&
p.yyyy == MainRe.TimeStart.Value.Year &&
p.mm == MainRe.TimeStart.Value.Month)
.FirstOrDefault();
//訂單報表
TB_OrderReport OrderRe = en.TB_OrderReport.Where(p => p.OrderReID == MainRe.OrderReID).FirstOrDefault();
//保險報表
TB_InsurenceRe InsureRe = en.TB_InsurenceRe.Where(p => p.InsurenceID == MainRe.InsurenceReID).FirstOrDefault();
//中古車報表
TB_OldCarSaleRe OldCarRe = en.TB_OldCarSaleRe.Where(p => p.OldCarSaleReID == MainRe.OldCarSaleReID).FirstOrDefault();
//精裝配件
TB_CarAssRe CarAssRe = en.TB_CarAssRe.Where(p => p.CarAssReID == MainRe.CarAssReID).FirstOrDefault();
//人員管理概要
TB_HumanRe HumanRe = en.TB_HumanRe.Where(p => p.HumanResourceReID == MainRe.HumanManageReID).FirstOrDefault();
#region ---------------------------訂單部分-----------------------------
//本月目標
MonthGoalLabel.Text = MonthGoal.OrderNum.ToString();
DateTime dt = ((DateTime)MainRe.TimeEnd);
Decimal rate = (decimal)((DateTime)MainRe.TimeEnd).Day / (decimal)DateTime.DaysInMonth(dt.Year, dt.Month);
rlgMonthGoal.Pointer.Value = rate * 100;
//累積至本周受定台數
OrderedCountLabel.Text = Convert.ToString(OrderRe.OrderedCount);
rlgOrderedCount.Pointer.Value = (decimal)OrderRe.OrderedCount / (decimal)MonthGoal.OrderNum * 100;
if (rlgOrderedCount.Pointer.Value < rlgMonthGoal.Pointer.Value)
{
rlgOrderedCount.Pointer.Color = System.Drawing.Color.Red;
}
//累積至本周販賣台數
SaleCountLabel.Text = OrderRe.SaleCount.ToString();
rlgSaleCount.Pointer.Value = (decimal)OrderRe.SaleCount / (decimal)MonthGoal.OrderNum * 100;
if (rlgSaleCount.Pointer.Value < rlgMonthGoal.Pointer.Value)
{
rlgSaleCount.Pointer.Color = System.Drawing.Color.Red;
}
//目前掌握台數
OnControlLabel.Text = OrderRe.OnControl.ToString();
rlgOnControl.Pointer.Value = (decimal)OrderRe.OnControl / (decimal)MonthGoal.OrderNum * 100;
if (rlgOnControl.Pointer.Value < rlgMonthGoal.Pointer.Value)
{
rlgOnControl.Pointer.Color = System.Drawing.Color.Red;
}
//至月底預估台數
ExpectationsLabel.Text = OrderRe.Expectations.ToString();
rlgExpectations.Pointer.Value = (decimal)OrderRe.Expectations / (decimal)MonthGoal.OrderNum * 100;
if (rlgExpectations.Pointer.Value < rlgMonthGoal.Pointer.Value)
{
rlgExpectations.Pointer.Color = System.Drawing.Color.Red;
}
//各業專本周受訂狀況
OrderDetailLabel.Text = OrderRe.OrderDetail;
//未開市人員
UnorderDetailLabel.Text = OrderRe.UnorderDetail;
//針對本周該課(新訂弱勢車種)說明
WeekCarLabel.Text = OrderRe.WeekCar;
//其他問題點改善說明
OthersLabel.Text = OrderRe.Others;
//販賣管理自評
SelfNumberLabel.Text = OrderRe.SelfNumber.ToString();
#endregion
#region ---------------------------保險部分-----------------------------
//本月目標件數
InGoalLabel.Text = MonthGoal.InGoalNum.ToString();
//累積至本周任意件數
AnyCaseToNowLabel.Text = InsureRe.AnyCaseToNow.ToString();
rlgAnyCaseToNow.Pointer.Value = (decimal)InsureRe.AnyCaseToNow / (decimal)MonthGoal.InGoalNum * 100;
//累積至本周車體(甲乙丙)件數
CarBdCaseToNowLabel.Text = InsureRe.CarBdCaseToNow.ToString();
rlgCarBdCaseToNow.Pointer.Value = (decimal)InsureRe.CarBdCaseToNow / (decimal)MonthGoal.InGoalNum * 100;
//本月目標保費
lbInsurenceBill.Text = (MonthGoal.InGoalNum * 0.76 * 11000).ToString();
//累積至本周任意總保費
MoneyToNowLabel.Text = InsureRe.MoneyToNow.ToString();
rlgMoneyToNow.Pointer.Value = (decimal)InsureRe.MoneyToNow / (decimal)(MonthGoal.InGoalNum * 0.76 * 11000) * 100;
//本月預估保費達成率
MonTotalExRLabel.Text = InsureRe.MonTotalExR.ToString() + "%";
//任意目標件數
InSecConLabel.Text = MonthGoal.InAny.ToString();
//累積至本周任意件數
AnyCaseSecLabel.Text = MonthGoal.InAny.ToString();
rlgAnyCaseSec.Pointer.Value = (decimal)MonthGoal.InAny / (decimal)MonthGoal.InAny * 100;
//本月預估達成率
MonAnyExRLabel.Text = InsureRe.MonAnyExR.ToString() + "%";
//車體目標件數
CarBdSecLabel.Text = InsureRe.CarBdSec.ToString();
//累積至本周車體(甲乙)件數
WeekTotalBdLabel.Text = InsureRe.WeekTotalBd.ToString();
rlgWeekTotalBd.Pointer.Value = (decimal)InsureRe.WeekTotalBd / (decimal)MonthGoal.InBd * 100;
//本月預估達成率
MonBdExRLabel.Text = InsureRe.MonBdExR.ToString() + "%";
//弱勢險種改善計畫
txtRefinProject.Text = InsureRe.RefinProject;
//本月目標
lbInstallmentsMonthGoal.Text = ((decimal)(MonthGoal.OrderNum * 0.45)).ToString("0");
//累積至本周販賣台數
lbSaleCount.Text = OrderRe.SaleCount.ToString();
//累積至本周進件台數
TotalWeekImportLabel.Text = InsureRe.TotalWeekImport.ToString();
rlgInsurenceInstallments.Pointer.Value = (decimal)InsureRe.TotalWeekImport / (decimal)OrderRe.SaleCount * 100;
//保險/分期管理自評
SelfNumber1Label.Text = InsureRe.SelfNumber.ToString();
#endregion
#region ---------------------------中古車部分---------------------------
//換購台數
ChangeBuyLabel.Text = OldCarRe.ChangeBuy.ToString();
//本周查估台數
BuyExLabel.Text = OldCarRe.BuyEx.ToString();
//成交台數
DealNumLabel.Text = OldCarRe.DealNum.ToString();
//戰敗車原因及流向說明
FailDealDetailTextBox.Text = OldCarRe.FailDealDetail.ToString();
//中古車管理自評
SelfNumber2Label.Text = OldCarRe.SelfNumber.ToString();
#endregion
#region --------------------------精裝配件------------------------------
//精裝招攬累計件數
RefinementNumLabel.Text = CarAssRe.RefinementNum.ToString();
//影音招攬累計件數
VAudioNumLabel.Text = CarAssRe.VAudioNum.ToString();
//精裝推販問題原因說明/改善計畫
RefineDetailTextBox.Text = CarAssRe.RefineDetail.ToString();
//車美仕配件問題件數
AssProNumLabel.Text = CarAssRe.AssProNum.ToString();
//PDS整備問題件數
PDSProNumLabel.Text = CarAssRe.PDSProNum.ToString();
//其他問題點回饋
OthersProDetailTextBox.Text = CarAssRe.OthersProDetail.ToString();
//精裝管理自評
SelfNumber3Label.Text = CarAssRe.SelfNumber.ToString();
#endregion
#region --------------------------人員管理------------------------------
//本課別尚缺人數
PeopleNeedLabel.Text = HumanRe.PeopleNeed.ToString();
//當周面試人數
InterviewLabel.Text = HumanRe.Interview.ToString();
//2年以下新入社人員狀況觀察
NewEmpDetailTextBox.Text = HumanRe.NewEmpDetail;
//本周特別關懷弱勢人員
SpecialEmpTextBox.Text = HumanRe.SpecialEmp;
//本周優良業專
WeekGoodEmpTextBox.Text = HumanRe.WeekGoodEmp;
//人員自評管理
SelfNumber4Label.Text = HumanRe.SelfNumber.ToString();
#endregion
}
}
public void LoadReportData()
{
List <TB_Report> lR = GetMainReport();
var mainReport = lR.FirstOrDefault();
TB_User user = ((TB_User)Session[GlobalInfo.Session_User]);
using (var en = new WeekReportEntities())
{
//訂單資料
var OrderReport = en.TB_OrderReport.Where(p => p.OrderReID == mainReport.OrderReID).FirstOrDefault();
//保險資料
TB_InsurenceRe InReport = (from q in en.TB_InsurenceRe
where q.InsurenceID == mainReport.InsurenceReID
select q).FirstOrDefault();
//抓其他資料表的資料
var Goal = en.TB_MonthGoal.Where(p => p.Bureau == user.Bureau &&
p.Class == user.Class &&
p.yyyy == DateTime.Now.Year &&
p.mm == DateTime.Now.Month).FirstOrDefault();
int InGoalNum = (int)Goal.InGoalNum;
int InAny = (int)Goal.InAny;
int InBd = (int)Goal.InBd;
lbGoalNumber.Text = Goal.InGoalNum.ToString();
lbInSecCon.Text = Goal.InAny.ToString();
lbCarBdSec.Text = Goal.InBd.ToString();
lbGoalMoney.Text = (InGoalNum * 0.76 * 11000).ToString();
if (InReport != null)
{
int AnyCaseToNow = (int)InReport.AnyCaseToNow;
int CarBdCaseToNow = (int)InReport.CarBdCaseToNow;
int MoneyToNow = (int)InReport.MoneyToNow;
int AnyCaseSec = (int)InReport.AnyCaseSec;
int WeekTotalBd = (int)InReport.WeekTotalBd;
txtAnyCaseToNow.Text = InReport.AnyCaseToNow.ToString();
txtCarBdCaseToNow.Text = InReport.CarBdCaseToNow.ToString();
txtMoneyToNow.Text = InReport.MoneyToNow.ToString();
txtAnyCaseSec.Text = InReport.AnyCaseSec.ToString();
txtWeekTotalBd.Text = InReport.WeekTotalBd.ToString();
lbContinuePushR.Text = (AnyCaseToNow * 100 / InGoalNum).ToString() + "%";
lbBdContinuePushR.Text = (CarBdCaseToNow * 100 / InGoalNum).ToString() + "%";
lbMoneyPushR.Text = (MoneyToNow * 100 / (InGoalNum * 0.76 * 11000)).ToString("0.00") + "%";
lbAnySecPushR.Text = (AnyCaseSec * 100 / InAny).ToString() + "%";
lbAnyBdR.Text = (WeekTotalBd * 100 / InBd).ToString() + "%";
txtMonTotalExR.Text = InReport.MonTotalExR.ToString();
txtMonAnyExR.Text = InReport.MonAnyExR.ToString();
txtMonBdExR.Text = InReport.MonBdExR.ToString();
lbGoalMonth.Text = OrderReport.OrderedCount.ToString();
lbOrderCount.Text = OrderReport.SaleCount.ToString();
txtImportC.Text = InReport.TotalWeekImport.ToString();
lbInstallments.Text = ((int)InReport.TotalWeekImport * 100 / (int)OrderReport.SaleCount).ToString();
txtRefineProject.Text = InReport.RefinProject;
txtSelfNumber.Text = InReport.SelfNumber.ToString();
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
var lR = GetMainReport().FirstOrDefault();
using (var en = new WeekReportEntities())
{
TB_InsurenceRe InReport = en.TB_InsurenceRe.Where(p => p.InsurenceID == lR.InsurenceReID).FirstOrDefault();
if (InReport != null)
{
InReport.AnyCaseToNow = int.Parse(txtAnyCaseToNow.Text);
InReport.CarBdCaseToNow = int.Parse(txtCarBdCaseToNow.Text);
InReport.MoneyToNow = int.Parse(txtMoneyToNow.Text);
InReport.AnyCaseSec = int.Parse(txtAnyCaseSec.Text);
InReport.WeekTotalBd = int.Parse(txtWeekTotalBd.Text);
InReport.MonTotalExR = int.Parse(txtMonTotalExR.Text);
InReport.MonAnyExR = int.Parse(txtMonAnyExR.Text);
InReport.MonBdExR = int.Parse(txtMonBdExR.Text);
InReport.TotalWeekImport = int.Parse(txtImportC.Text);
InReport.RefinProject = txtRefineProject.Text;
InReport.SelfNumber = int.Parse(txtSelfNumber.Text);
en.SaveChanges();
}
else
{
en.TB_InsurenceRe.Add(new TB_InsurenceRe
{
InsurenceID = lR.InsurenceReID,
AnyCaseToNow = int.Parse(txtAnyCaseToNow.Text),
CarBdCaseToNow = int.Parse(txtCarBdCaseToNow.Text),
MoneyToNow = int.Parse(txtMoneyToNow.Text),
AnyCaseSec = int.Parse(txtAnyCaseSec.Text),
WeekTotalBd = int.Parse(txtWeekTotalBd.Text),
MonTotalExR = int.Parse(txtMonTotalExR.Text),
MonAnyExR = int.Parse(txtMonAnyExR.Text),
MonBdExR = int.Parse(txtMonBdExR.Text),
TotalWeekImport = int.Parse(txtImportC.Text),
RefinProject = txtRefineProject.Text,
SelfNumber = int.Parse(txtSelfNumber.Text)
});
en.SaveChanges();
}
this.LoadReportData();
}
}
catch (Exception ex)
{
ErrorManage.Show(ex.ToString());
}
}
