/// <summary> /// 初始化大事件数据 /// </summary> /// <param name="nameid"></param> /// <returns></returns> private string InitGreatEventData(string nameid) { string str = ""; PersonRewardPunishInfoModel model = new PersonRewardPunishInfoModel(); List <PersonRewardPunishInfo> list = model.GetPersonRewardPunishInfos("", "", nameid, "", "", ""); foreach (PersonRewardPunishInfo item in list) { string datestr = ""; try { datestr = Convert.ToDateTime(item.RPTIME).ToString("yyyy年MM月dd日") + " , "; } catch { } string rpStr = "奖励"; if (item.RPTYPE == "0") { rpStr = "奖励"; } else if (item.RPTYPE == "1") { rpStr = "扣除"; } str += " " + datestr + item.INCIDENT + " " + rpStr + " " + item.FRACTION + "分。 \r\n"; } return(str); }
/// <summary> /// 初始化数据 /// </summary> private void InitData(string type) { PersonRewardPunishInfoModel model = new PersonRewardPunishInfoModel(); infoList = model.GetPersonRewardPunishInfos(type, "", "", "", "", ""); this.dg_GrouperList.ItemsSource = null; this.dg_GrouperList.ItemsSource = infoList; }
private void buttonModify_Click(object sender, RoutedEventArgs e) { PersonRewardPunishInfoModel model = new PersonRewardPunishInfoModel(); foreach (PersonRewardPunishInfo tempInfo in infoList) { if (tempInfo.ISCHECKED == true) { PersonRewardPunishInfoDialog dialog = new PlanDatabase.PersonRewardPunishInfoDialog(tempInfo, false); dialog.Closed += Dialog_Closed; dialog.Show(); } } }
private void buttonDelete_Click(object sender, RoutedEventArgs e) { PersonRewardPunishInfoModel model = new PersonRewardPunishInfoModel(); foreach (PersonRewardPunishInfo tempInfo in infoList) { if (tempInfo.ISCHECKED == true) { model.DeletePersonRewardPunishInfo(tempInfo.ID); } } MessageBox.Show("删除完毕!"); InitData(rptype); }
private void btn_ExpExcel_Click(object sender, RoutedEventArgs e) { //DataTable dt = NPOIHelper.ImportExceltoDt(@"c:\统计\外出情况统计.xlsx"); //dt.Rows[4][3] = "test"; PersonRewardPunishInfoModel model = new PersonRewardPunishInfoModel(); //string[,] updateData = new string[10,100]; DataTable dt = model.GetPersonRewardPunishDataTable("", "", "", "", "", ""); //Data //dr[0][0]=1; //dt.Rows.Add(); NPOIHelper.DataTableToExcelForRewaor(dt, @"e:\外出情况统计.xlsx", 3, 3); //NPOIHelper.ExportDTtoExcel(dt, "12344555", @"c:\统计\外出情况统计.xlsx"); }
private void InitData(string nameid) { PersonRewardPunishInfoModel model = new PersonRewardPunishInfoModel(); List <PersonRewardPunishInfo> list = model.GetPersonRewardPunishInfos("", "", nameid, "", "", ""); foreach (PersonRewardPunishInfo item in list) { LayoutItem li = new LayoutItem(); TextBlock tb = new TextBlock(); string datestr = ""; try { datestr = Convert.ToDateTime(item.RPTIME).ToString("yyyy年MM月dd天") + " , "; } catch { } string rpStr = "奖励"; if (item.RPTYPE == "0") { rpStr = "奖励"; } else if (item.RPTYPE == "1") { rpStr = "扣除"; } tb.Text = " " + datestr + item.INCIDENT + " " + item.RPTYPE + " " + item.FRACTION + "分。"; tb.TextWrapping = TextWrapping.Wrap; li.Content = tb; this.LayoutGroup_Container.Children.Add(li); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { PersonBasicInfo bi = this.cb_PersonList.SelectedItem as PersonBasicInfo; info.NAMEID = bi.NAMEID; info.NAME = bi.NAME; CodeDicItem cdI = this.cb_type.SelectedItem as CodeDicItem; info.INCIDENT = cdI.CODE; PersonRewardPunishInfoModel model = new PersonRewardPunishInfoModel(); bool isresult = false; if (IsModify == false) { isresult = model.InsertPersonRewardPunishInfo(info); } else { isresult = model.ModifyPersonRewardPunishInfo(info); } if (isresult) { MessageBox.Show("保存人员量化考核信息成功!"); this.Close(); } else { MessageBox.Show("保存人员量化考核信息失败 请确认后再进行保存!"); } }