/// <summary> /// 插入模板 /// </summary> /// <param name="entity"></param> /// <returns></returns> public string AddTemplate(SalaryItemTemplet entity) { PayRollTempalteDB oTemplateDB = new PayRollTempalteDB(); if (oTemplateDB.IsExist(entity.name)) { return("指定名称己经存在,请换个名称!"); } try { oTemplateDB.Insert(entity); return(null); } catch (System.Data.SqlClient.SqlException) { return("写数据库出错,请再试一次!"); } }
private void btnOK_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.txtTemplateName.Text.Trim())) { CommUI.MsgOK("模板名称不能为空!"); this.txtTemplateName.Focus(); this.DialogResult = DialogResult.None; return; } SalaryItemTemplet entity = new SalaryItemTemplet(); FrmReadyPayOff pWin = this.Owner.ActiveMdiChild as FrmReadyPayOff; //被选中的工资项 var chkBoxs = pWin.panPayRoll_flp.Controls.OfType <CheckBox>().Where(p => p.Checked == true); //数据库中有多少个工资项字段 var pItems = entity.GetType().GetProperties().Where(p => p.Name.StartsWith("item")); if (chkBoxs.Count() > pItems.Count()) { CommUI.AlertError("您选的工资项太多,数据库不能存储,请偿试减少工资项!"); return; } //设置工资模板的工资项 for (int i = 0; i < chkBoxs.Count(); i++) { pItems.ElementAt(i).SetValue(entity, chkBoxs.ElementAt(i).Text, null); } entity.name = this.txtTemplateName.Text.Trim(); entity.inputDate = DateTime.Now; entity.inputMan = this.UserName; string strResult = new PayRollTemplateLogic().AddTemplate(entity); if (string.IsNullOrEmpty(strResult)) { //CommUI.MsgOK(); } else { CommUI.AlertError(strResult); } }