public frmObjectSearch(string proj)
: this()
{
mProj = new TB_PROJECT();
List <PTS_TABLE_SRC> srclist = new List <PTS_TABLE_SRC>();
PTS_TABLE_SRC tmp = new PTS_TABLE_SRC();
tmp.TABLE_NAME = "请选择";
tmp.TABLE_VALUE = "0";
tmp.ID = 0;
PTS_TABLE_SRC[] arr = PTS_TABLE_SRCDAO.FindAll(new EqExpression("TABLE_ID", "PTS_TABLE_OBJECT_TYPE"));
if (arr.Length > 0)
{
srclist = new List <PTS_TABLE_SRC>(arr);
srclist.Insert(0, tmp);
}
this.cmbObjType.ItemsSource = null;
this.cmbObjType.ItemsSource = srclist;
this.cmbObjType.DisplayMemberPath = "TABLE_NAME";
this.cmbObjType.SelectedIndex = 0;
this.txtObjName.Text = proj;
TB_PROJECT[] _arr = TB_PROJECTDAO.FindAll(new LikeExpression("OBJECTNAME", "%" + this.txtObjName.Text + "%"), new EqExpression("STATUS", 1));
if (_arr.Length > 0)
{
mList = new List <TB_PROJECT>(_arr);
}
this.dgObject.ItemsSource = screening(mList);
}
private PTS_TABLE_SRC getUserRole(int ROLEID = -1)
{
try
{
PTS_TABLE_SRC item = PTS_TABLE_SRCDAO.FindFirst(new EqExpression("ID", ROLEID));
return(item);
}
catch (Exception ex)
{
throw ex;
}
}
private void BindSourceData()
{
List <PTS_TABLE_SRC> list = null;
PTS_TABLE_SRC[] arr = PTS_TABLE_SRCDAO.FindAll(new EqExpression("STATUS", 1), new EqExpression("TABLE_ID", "PTS_TABLE_OBJECT_TYPE"));
if (arr.Length > 0)
{
list = new List <PTS_TABLE_SRC>(arr);
PTS_TABLE_SRC _tmp = new PTS_TABLE_SRC();
_tmp.TABLE_NAME = "请选择";
list.Insert(0, _tmp);
}
this.cmbObjType.ItemsSource = null;
this.cmbObjType.ItemsSource = list;
this.cmbObjType.DisplayMemberPath = "TABLE_NAME";
this.cmbObjType.SelectedIndex = 0;
}
public frmObjectSearch(int type = 0)
{
InitializeComponent();
mType = type;
mProj = new TB_PROJECT();
List <PTS_TABLE_SRC> srclist = new List <PTS_TABLE_SRC>();
PTS_TABLE_SRC tmp = new PTS_TABLE_SRC();
tmp.TABLE_NAME = "请选择";
tmp.TABLE_VALUE = "0";
tmp.ID = 0;
PTS_TABLE_SRC[] arr = PTS_TABLE_SRCDAO.FindAll(new EqExpression("TABLE_ID", "PTS_TABLE_OBJECT_TYPE"));
if (arr.Length > 0)
{
srclist = new List <PTS_TABLE_SRC>(arr);
srclist.Insert(0, tmp);
}
this.cmbObjType.ItemsSource = null;
this.cmbObjType.ItemsSource = srclist;
this.cmbObjType.DisplayMemberPath = "TABLE_NAME";
this.cmbObjType.SelectedIndex = 0;
TB_PROJECT[] _arr = null;
//if(type==1)
// _arr = TB_PROJECTDAO.FindAll(new LikeExpression("OBJECTNAME", "%" + this.txtObjName.Text + "%"), new EqExpression("STATUS", 1), new NotExpression(new EqExpression("BILLSTATUS", "已结算")));
//else
_arr = TB_PROJECTDAO.FindAll(new LikeExpression("OBJECTNAME", "%" + this.txtObjName.Text + "%"), new EqExpression("STATUS", 1));
if (_arr.Length > 0)
{
mList = new List <TB_PROJECT>(_arr);
for (int i = 0; i < mList.Count; i++)
{
if (!string.IsNullOrEmpty(mList[i].OBJECTTYPENAME))
{
string identity = Comment.setProjIdentity(mList[i].OBJECTTYPENAME);
mList[i].ProjIdentity = identity;
}
}
if (type == 1)
{
mList = mList.FindAll(a => a.BILLSTATUS == "已结算");
}
}
this.dgObject.ItemsSource = screening(mList);
}
private void BindStaticData()
{
//获取静态报销类型数据
this.cmbExprenseItem.ItemsSource = null;
PTS_TABLE_SRC tmp = new PTS_TABLE_SRC();
tmp.TABLE_NAME = "请选择";
tmp.TABLE_VALUE = "0";
PTS_TABLE_SRC[] arr = PTS_TABLE_SRCDAO.FindAll(new EqExpression("TABLE_ID", "PTS_TABLE_EXPENSE_ITEM"), new EqExpression("STATUS", 1));
if (arr.Length > 0)
{
mList = new List <PTS_TABLE_SRC>(arr);
mList.Insert(0, tmp);
}
this.cmbExprenseItem.ItemsSource = mList;
this.cmbExprenseItem.DisplayMemberPath = "TABLE_NAME";
this.cmbExprenseItem.SelectedIndex = 0;
}
private void BindDataSource()
{
//报销类型
List <PTS_TABLE_SRC> src_list = null;
PTS_TABLE_SRC[] src_arr = PTS_TABLE_SRCDAO.FindAll(new EqExpression("TABLE_ID", "PTS_TABLE_EXPENSE_ITEM")); //没有过滤status=0
if (src_arr.Length > 0)
{
src_list = new List <PTS_TABLE_SRC>(src_arr);
PTS_TABLE_SRC tmp = new PTS_TABLE_SRC();
tmp.TABLE_NAME = "请选择";
tmp.ID = 0;
src_list.Insert(0, tmp);
}
this.cmbExpenseType.ItemsSource = null;
this.cmbExpenseType.ItemsSource = src_list;
this.cmbExpenseType.DisplayMemberPath = "TABLE_NAME";
this.cmbExpenseType.SelectedIndex = 0;
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
List <TB_EXPENSE> ls = new List <TB_EXPENSE>();
TB_PROJECT proj = this.txtProj.Tag as TB_PROJECT; //工程类型
PTS_TABLE_SRC src = this.cmbExpenseType.SelectedItem as PTS_TABLE_SRC; //报销类型
//查询条件
int expenxeType = 0;
int expenxeType2 = 0;
int objectID = 0;
if (txtProj.Tag != null)
{
objectID = (txtProj.Tag as TB_PROJECT).Id;
}
string userCode = string.Empty;
if (txtUser.Tag != null)
{
userCode = (txtUser.Tag as TB_User).USER_CODE;
}
if (src != null)
{
expenxeType2 = src.ID;
}
//ls = Comments.Comment.QueryExpense2(userCode, expenxeType, objectls = Comments.Comment.QueryExpense2(userCode, expenxeType, objectID);
ls = Comments.Comment.QueryExpense(Global.g_usercode, expenxeType, objectID, expenxeType2, int.Parse(cmbYear.Text), int.Parse(cmbMonth.Text));
this.dgExpense.ItemsSource = null;
for (int i = 0; i < ls.Count; i++)
{
if (ls[i].RESPONSESTATUS == 1)
{
ls[i].StrResponseStatus = "驳回/修改";
}
else if (ls[i].RESPONSESTATUS == 2)
{
ls[i].StrResponseStatus = "已更正";
}
}
this.dgExpense.ItemsSource = ls;
}
public frmUser()
{
InitializeComponent();
#region 获取静态角色数据
this.cmbUserRole.ItemsSource = null;
PTS_TABLE_SRC tmp = new PTS_TABLE_SRC();
tmp.TABLE_NAME = "请选择";
tmp.TABLE_VALUE = "0";
PTS_TABLE_SRC[] arr = PTS_TABLE_SRCDAO.FindAll(new EqExpression("STATUS", 1), new EqExpression("TABLE_ID", "PTS_TABLE_USER_ROLE"));
List <PTS_TABLE_SRC> list = new List <PTS_TABLE_SRC>();
if (arr.Length > 0)
{
list = new List <PTS_TABLE_SRC>(arr);
list.Insert(0, tmp);
}
this.cmbUserRole.ItemsSource = list;
this.cmbUserRole.DisplayMemberPath = "TABLE_NAME";
this.cmbUserRole.SelectedIndex = 0;
#endregion
bindUserData();
}
private void dgUser_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
try
{
TB_User user = this.dgUser.SelectedItem as TB_User;
this.txtName.Text = user.USER_NAME;
this.txtCode.Text = user.USER_CODE;
this.txtDept.Text = user.DEPT;
PTS_TABLE_SRC role = getUserRole(user.ROLEID);
if (role != null)
{
this.cmbUserRole.Text = role.TABLE_NAME;
}
else
{
this.cmbUserRole.SelectedIndex = 0;
}
}
catch (Exception ex)
{
MessageHelper.ShowMessage(ex.Message);
}
}
private void btnSubmit_Click(object sender, RoutedEventArgs e)
{
if (this.rdoObject.IsChecked == false && this.rdoPersinal.IsChecked == false)
{
MessageHelper.ShowMessage("请选择项目报销或个人报销");
if (this.rdoObject.IsChecked == true && this.txtProj.Tag == null)
{
MessageHelper.ShowMessage("请选择报销所对应的工程项目");
}
}
else
{
try
{
int ISMEMBER = 0;
int RESPONSESTATUS = 0; //默认审核通过
//int ISCOMPLETE = 0; //默认提交状态
PTS_TABLE_SRC src = this.cmbExprenseItem.SelectedItem as PTS_TABLE_SRC;
DateTime sysDate = TableManager.DBServerTime();
DateTime expenseDate = this.dtpDate.DateTime;
if (expenseDate < sysDate.AddMonths(-6))
{
MessageHelper.ShowMessage("发票日期不能超过半年！");
return;
}
if (string.IsNullOrEmpty(txtFPHM.Text))
{
MessageHelper.ShowMessage("请填写发票号码！");
return;
}
if (src.ID == 0)
{
MessageHelper.ShowMessage("请选择报销类型!");
return;
}
else
{
if (this.rdoObject.IsChecked == true)
{
if (chkQTCT.IsChecked == true && String.IsNullOrEmpty(txtCusName.Text))
{
MessageHelper.ShowMessage("公司账户填报必须填写客户名称！");
txtCusName.Focus();
return;
}
//判断报销填报人员是否是项目内的成员
if (this.chkQTCT.IsChecked == false && Global.g_usercode != (txtProj.Tag as TB_PROJECT).TEAMLEDER && ((txtProj.Tag as TB_PROJECT).TEAMMEMBER).IndexOf(Global.g_usercode) < 0)
{
if (MessageBox.Show("您不属于" + txtProj.Text + "项目的成员，是否需要保存报销信息？", "提示", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No)
{
return;
}
else
{
ISMEMBER = 1;
RESPONSESTATUS = 0;
}
}
}
else
{
RESPONSESTATUS = 0;
}
decimal money = -1;
if (!String.IsNullOrEmpty(txtMoney.Text))
{
decimal.TryParse(txtMoney.Text, out money);
}
if (money <= 0)
{
MessageHelper.ShowMessage("报销填报金额格式错误!");
return;
}
if (mExp == null)
{
DateTime date = DateTime.Parse(new BaseBusiness().date());
{
int day = date.Day;
if (day > 26)
{
MessageHelper.ShowMessage("每月报销25日截止！");
return;
}
}
TB_EXPENSE expense = new TB_EXPENSE();
expense.OBJECTID = 0;
if (txtProj.Tag != null)
{
expense.OBJECTID = (txtProj.Tag as TB_PROJECT).Id;
expense.OBJECTNAME = txtProj.Text;
}
expense.OPUID = Global.g_userid;
expense.OPNAME = Global.g_usercode; //工号
expense.EXPENS = src.TABLE_NAME; //报销类型名称
expense.EXPENSTYPE = src.ID; //报销类型ID
expense.MONEY = money;
expense.ISMEMBER = ISMEMBER;
expense.CREATEDATE = this.dtpDate.DateTime; //当前系统时间
expense.BILLNO = txtFPHM.Text;
expense.COMMENTS = txtComments.Text;
expense.RESPONSESTATUS = RESPONSESTATUS;
expense.ISCOMPLETE = 0; //提交状态 默认未提交
expense.STATUS = 1;
BaseBusiness bs = new BaseBusiness();
string strTime = bs.date();
DateTime time = DateTime.Parse(strTime);
expense.YEAR = time.Year;
expense.MONTH = time.Month;
expense.LEADERRESPONSESTATUS = RESPONSESTATUS;
if (chkQTCT.IsChecked == true && !String.IsNullOrEmpty(txtCusName.Text))
{
expense.OPNAME = txtCusName.Text;
expense.ISQTCT = 1;
expense.RESPONSESTATUS = 0;
expense.LEADERRESPONSESTATUS = 0;
}
expense.Save(); //新增报销
}
else //update
{
mExp.OBJECTID = 0;
if (txtProj.Tag != null)
{
mExp.OBJECTID = (txtProj.Tag as TB_PROJECT).Id;
mExp.OBJECTNAME = txtProj.Text;
}
mExp.OPUID = Global.g_userid;
mExp.OPNAME = Global.g_usercode; //工号
mExp.EXPENS = src.TABLE_NAME; //报销类型名称
mExp.EXPENSTYPE = src.ID; //报销类型ID
mExp.MONEY = money;
mExp.ISMEMBER = ISMEMBER;
mExp.CREATEDATE = this.dtpDate.DateTime; //当前系统时间
mExp.BILLNO = txtFPHM.Text;
mExp.COMMENTS = txtComments.Text;
mExp.STATUS = 1;
if (mExp.RESPONSESTATUS == 1)
{
mExp.RESPONSESTATUS = 0; //待审
}
if (mExp.LEADERRESPONSESTATUS == 1)
{
mExp.LEADERRESPONSESTATUS = 0; //待审
}
if (chkQTCT.IsChecked == true && !String.IsNullOrEmpty(txtCusName.Text))
{
mExp.OPNAME = txtCusName.Text;
mExp.ISQTCT = 1;
mExp.RESPONSESTATUS = 2;
mExp.LEADERRESPONSESTATUS = 2;
}
mExp.Update();
this.btnSubmit.Content = "新 增";
mExp = null;
}
refreshForm();
}
}
catch (Exception ex)
{
MessageHelper.ShowMessage(ex.Message);
}
}
BindExpenseData();
}
private void btnSubmit_Click(object sender, RoutedEventArgs e)
{
if (this.rdoObject.IsChecked == false && this.rdoPersinal.IsChecked == false)
{
MessageHelper.ShowMessage("请选择项目报销或个人报销");
if (this.rdoObject.IsChecked == true && this.txtProj.Tag == null)
{
MessageHelper.ShowMessage("请选择报销所对应的工程项目");
}
}
else
{
try
{
int ISMEMBER = 0;
PTS_TABLE_SRC src = this.cmbExprenseItem.SelectedItem as PTS_TABLE_SRC;
if (string.IsNullOrEmpty(txtFPHM.Text))
{
MessageHelper.ShowMessage("请填写发票号码！");
return;
}
if (src.ID == 0)
{
MessageHelper.ShowMessage("请选择报销类型!");
return;
}
else
{
if (this.rdoObject.IsChecked == true)
{
if (txtFPHM.Text.IndexOf(';') > -1)
{
MessageHelper.ShowMessage("项目报销不允许多发票填报");
return;
}
//判断报销填报人员是否是项目内的成员
if (Global.g_usercode != (txtProj.Tag as TB_PROJECT).TEAMLEDER && ((txtProj.Tag as TB_PROJECT).TEAMMEMBER).IndexOf(Global.g_usercode) < 0)
{
if (MessageBox.Show("您不属于" + txtProj.Text + "项目的成员，是否需要保存报销信息？", "提示", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No)
{
return;
}
else
{
ISMEMBER = 1;
}
}
}
decimal money = -1;
if (!String.IsNullOrEmpty(txtMoney.Text))
{
decimal.TryParse(txtMoney.Text, out money);
}
if (money <= 0)
{
MessageHelper.ShowMessage("报销填报金额格式错误!");
return;
}
if (mExp == null)
{
TB_EXPENSE expense = new TB_EXPENSE();
expense.OBJECTID = 0;
if (txtProj.Tag != null)
{
expense.OBJECTID = (txtProj.Tag as TB_PROJECT).Id;
expense.OBJECTNAME = txtProj.Text;
}
expense.OPUID = Global.g_userid;
expense.OPNAME = Global.g_usercode; //工号
expense.EXPENS = src.TABLE_NAME; //报销类型名称
expense.EXPENSTYPE = src.ID; //报销类型ID
expense.MONEY = money;
expense.ISMEMBER = ISMEMBER;
expense.CREATEDATE = this.dtpDate.DateTime; //当前系统时间
expense.BILLNO = txtFPHM.Text;
expense.COMMENTS = txtComments.Text;
expense.STATUS = 1;
BaseBusiness bs = new BaseBusiness();
string strTime = bs.date();
DateTime time = DateTime.Parse(strTime);
expense.YEAR = time.Year;
expense.MONTH = time.Month;
expense.Save();
}
else
{
mExp.OBJECTID = 0;
if (txtProj.Tag != null)
{
mExp.OBJECTID = (txtProj.Tag as TB_PROJECT).Id;
mExp.OBJECTNAME = txtProj.Text;
}
mExp.OPUID = Global.g_userid;
mExp.OPNAME = Global.g_usercode; //工号
mExp.EXPENS = src.TABLE_NAME; //报销类型名称
mExp.EXPENSTYPE = src.ID; //报销类型ID
mExp.MONEY = money;
mExp.ISMEMBER = ISMEMBER;
mExp.CREATEDATE = this.dtpDate.DateTime; //当前系统时间
mExp.BILLNO = txtFPHM.Text;
mExp.COMMENTS = txtComments.Text;
mExp.STATUS = 1;
//mExp.RESPONSESTATUS = 2;
mExp.Update();
}
MessageHelper.ShowMessage("保存成功!");
//refreshForm();
this.Close();
}
}
catch (Exception ex)
{
MessageHelper.ShowMessage(ex.Message);
}
}
BindExpenseData();
}
