using DevExpress.ClipboardSource.SpreadsheetML;
|
using DevExpress.XtraEditors;
|
using Gs.DevApp.Entity;
|
using Gs.DevApp.ToolBox;
|
using Gs.DevApp.UserControl;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using System.Windows.Forms;
|
using System.Windows.Media.Animation;
|
|
namespace Gs.DevApp.DevFrm.JJGZ
|
{
|
public partial class Frm_MesJSSalary : DevExpress.XtraEditors.XtraForm
|
{
|
string _webServiceName = "MesJjgzJssalary/";
|
List<FilterEntity> _filterList = new List<FilterEntity>();
|
|
public Frm_MesJSSalary()
|
{
|
InitializeComponent();
|
this.toolBarMenu1.btnAddClick += ToolBarMenu1_btnAddClick;
|
this.toolBarMenu1.btnEdtClick += ToolBarMenu1_btnEdtClick;
|
this.toolBarMenu1.btnSaveClick += ToolBarMenu1_btnSaveClick;
|
this.toolBarMenu1.btnLoadClick += ToolBarMenu1_btnLoadClick;
|
this.toolBarMenu1.btnDelClick += ToolBarMenu1_btnDelClick1;
|
this.toolBarMenu1.btnEscClick += ToolBarMenu1_btnEscClick;
|
toolBarMenu1.btnChkClick += ToolBarMenu1_btnChkClick;
|
toolBarMenu1.btnFChkClick += ToolBarMenu1_btnFChkClick;
|
this.toolBarMenu1.getXmlConfig();
|
Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, picCheckBox, this, "checkStatus", "", (value) =>
|
{
|
Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 0);
|
}, tips);
|
Gs.DevApp.ToolBox.UtilityHelper.SetTabParameter(gridView1, xtraTabControl1, pageBar1, (value) =>
|
{
|
getModel(value);
|
}, (value) =>
|
{
|
getPageList(this.pageBar1.CurrentPage);
|
}, lbGuid);
|
getPageList(1);
|
pageBar1.PagerEvent += PageBar1_PagerEvent;
|
GetTimeType();
|
}
|
|
/// <summary>
|
/// 获取下拉框数据
|
/// </summary>
|
private void GetTimeType()
|
{
|
try
|
{
|
string strJson = UtilityHelper.HttpPost("", _webServiceName + "GetTimeType", "");
|
ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
|
if (_rtn.rtnCode > 0)
|
{
|
dynamic dy = _rtn.rtnData;
|
JObject _job = JObject.Parse(strJson);
|
JArray array = new JArray();
|
foreach (var a in _job["rtnData"]["list"])
|
{
|
array.Add(a);
|
}
|
DataTable dt = JsonConvert.DeserializeObject<DataTable>(array.ToString());
|
|
foreach (DataRow row in dt.Rows)
|
{
|
this.txt_HourlyType.Properties.Items.Add(row["name"].ToString());
|
}
|
}
|
else
|
{
|
ToolBox.MsgHelper.Warning("提示：" + _rtn.rtnMsg);
|
}
|
}
|
catch (Exception ex)
|
{
|
ToolBox.MsgHelper.Warning("提示：" + ex.Message);
|
}
|
}
|
|
private async void GridView1_ColumnFilterChanged(object sender, EventArgs e)
|
{
|
_filterList = Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns, gridView1);
|
await Task.Delay(100);
|
getPageList(1);
|
}
|
|
/// <summary>
|
/// 分页事件
|
/// </summary>
|
/// <param name="curPage"></param>
|
/// <param name="pageSize"></param>
|
private void PageBar1_PagerEvent(int curPage, int pageSize)
|
{
|
getPageList(curPage);
|
}
|
/// <summary>
|
/// 查询事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnQueryClick(object sender, EventArgs e)
|
{
|
gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged;
|
gridView1.ActiveFilter.Clear();
|
gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged;
|
var frm = new ShowFilter(gridView1.Columns, _filterList, this.GetType().FullName);
|
frm.UpdateParent += Frm_UpdateParent;
|
frm.ShowDialog();
|
}
|
/// <summary>
|
/// 查询回调
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void Frm_UpdateParent(object sender, UpdateParentEventArgs e)
|
{
|
_filterList = e.FilterList;
|
getPageList(1);
|
}
|
/// <summary>
|
/// 审核事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnChkClick(object sender, EventArgs e)
|
{
|
_toolCk(1);
|
}
|
|
/// <summary>
|
/// 反审核
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
/// <exception cref="NotImplementedException"></exception>
|
private void ToolBarMenu1_btnFChkClick(object sender, EventArgs e)
|
{
|
_toolCk(0);
|
}
|
/// <summary>
|
/// 取消事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnEscClick(object sender, EventArgs e)
|
{
|
Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 1);
|
}
|
|
/// <summary>
|
/// 删除事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnDelClick1(object sender, EventArgs e)
|
{
|
string rowGuid = "", rowName = "";
|
(rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_Guid, gridView1, "hourlyType");
|
if (string.IsNullOrEmpty(rowGuid))
|
{
|
ToolBox.MsgHelper.Warning("请先选择你要操作的行！");
|
return;
|
}
|
if (!MsgHelper.AskQuestion("你选择了【" + rowName + "】，确定删除吗？"))
|
return;
|
List<dynamic> lst = new List<dynamic>();
|
lst.Add(rowGuid);
|
var _obj = new
|
{
|
guid = rowGuid,
|
mxGuid = Guid.Empty.ToString(),
|
};
|
try
|
{
|
string strJson = UtilityHelper.HttpPost("", _webServiceName + "DeleteModel", JsonConvert.SerializeObject(_obj));
|
ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
|
if (_rtn.rtnCode > 0)
|
{
|
if (xtraTabControl1.SelectedTabPageIndex == 0)
|
{ }
|
else
|
Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 2);
|
getPageList(this.pageBar1.CurrentPage);
|
}
|
ToolBox.MsgHelper.Warning("提示：" + _rtn.rtnMsg);
|
}
|
catch (Exception ex)
|
{
|
ToolBox.MsgHelper.Warning("提示：" + ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 刷新事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnLoadClick(object sender, EventArgs e)
|
{
|
if (xtraTabControl1.SelectedTabPageIndex == 1)
|
getModel(lbGuid.Text.Trim());
|
else
|
{
|
//_filterList.Clear();
|
//if (gridView1.ActiveFilter.Count > 0)
|
//{
|
// gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged;
|
// gridView1.ActiveFilter.Clear();
|
// gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged;
|
//}
|
//getPageList(1);
|
getPageList(this.pageBar1.CurrentPage);
|
}
|
}
|
|
/// <summary>
|
/// 新增事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnAddClick(object sender, EventArgs e)
|
{
|
lbGuid.Text = "";
|
Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 4);
|
UtilityHelper.CleanValueByControl(this.layoutMx1.Controls, true);
|
GetTimeType();
|
getPageList(this.pageBar1.CurrentPage);
|
}
|
private void ToolBarMenu1_btnEdtClick(object sender, EventArgs e)
|
{
|
string rowGuid, rowName;
|
(rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1,
|
lbGuid, txt_Guid, gridView1);
|
if (string.IsNullOrEmpty(rowGuid))
|
{
|
MsgHelper.Warning("请先选择你要操作的行！");
|
return;
|
}
|
Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 3);
|
|
getModel(rowGuid);
|
GetTimeType();
|
getPageList(this.pageBar1.CurrentPage);
|
}
|
|
/// <summary>
|
/// 保存事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnSaveClick(object sender, EventArgs e)
|
{
|
toolBarMenu1.isSetBtn = false;
|
string hourlyType = txt_HourlyType.Text.Trim();//计时类型
|
string hourlySalary = txt_HourlySalary.Text.Trim();//计时工资
|
string beginTime = txt_BeginTime.Text.Trim();//生效日期
|
string endTime = txt_EndTime.Text.Trim();//失效日期
|
string remark = txt_Remark.Text.Trim();//计时说明
|
string salaryType = txt_SalaryType.Text.Trim();//工资计入
|
if (string.IsNullOrWhiteSpace( txt_HourlyType.Text))
|
{
|
Gs.DevApp.ToolBox.MsgHelper.Warning("请选择计时类型！");
|
txt_HourlyType.Focus();
|
return;
|
}
|
if (string.IsNullOrWhiteSpace(txt_HourlySalary.Text))
|
{
|
Gs.DevApp.ToolBox.MsgHelper.Warning("请选择计时工资！");
|
txt_HourlySalary.Focus();
|
return;
|
}
|
if (string.IsNullOrWhiteSpace(txt_BeginTime.Text))
|
{
|
Gs.DevApp.ToolBox.MsgHelper.Warning("请选择生效日期！");
|
txt_BeginTime.Focus();
|
return;
|
}
|
if (string.IsNullOrWhiteSpace(txt_EndTime.Text))
|
{
|
Gs.DevApp.ToolBox.MsgHelper.Warning("请选择失效日期！");
|
txt_EndTime.Focus();
|
return;
|
}
|
if (string.IsNullOrWhiteSpace(txt_SalaryType.Text))
|
{
|
Gs.DevApp.ToolBox.MsgHelper.Warning("请选择工资计入！");
|
txt_SalaryType.Focus();
|
return;
|
}
|
|
try
|
{
|
var _obj = new
|
{
|
guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), //主建
|
hourlyType = hourlyType,
|
hourlySalary = hourlySalary,
|
beginTime = beginTime,
|
endTime = endTime,
|
remark = remark,
|
salaryType = salaryType
|
};
|
string strJson = UtilityHelper.HttpPost("", _webServiceName + "EditModel", JsonConvert.SerializeObject(_obj));
|
ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
|
ToolBox.MsgHelper.Warning("提示：" + _rtn.rtnMsg);
|
if (_rtn.rtnCode > 0)
|
{
|
lbGuid.Text = _rtn.rtnData.outGuid;
|
toolBarMenu1.isSetBtn = true;
|
UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, false);
|
toolBarMenu1.currentAction = "";
|
Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 6);
|
}
|
}
|
catch (Exception ex)
|
{
|
ToolBox.MsgHelper.Warning("提示：" + ex.Message);
|
}
|
}
|
|
/// <summary>
|
///
|
/// </summary>
|
/// <param name="curPage">第几页</param>
|
/// <param name="pageSize">每页几条</param>
|
private void getPageList(int curPage)
|
{
|
gcMain1.DataSource = null; var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList);
|
var pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "", "", "", _sbSqlWhere.ToString());
|
var json = JsonConvert.SerializeObject(pgq);
|
try
|
{
|
var strReturn = UtilityHelper.HttpPost("",
|
_webServiceName + "GetListPage", json);
|
var dd = UtilityHelper.ReturnToTablePage(strReturn);
|
if (dd.rtnCode > 0)
|
{
|
DataTable dt = dd.rtnData.list;
|
gcMain1.BindingContext = new BindingContext();
|
gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged;
|
if (dt.Rows.Count > 0)
|
{
|
gcMain1.DataSource = dt;
|
gcMain1.ForceInitialize();
|
gridView1.BestFitColumns(); Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gridView1);
|
}
|
else
|
UtilityHelper.SetDefaultTable(gcMain1, gridView1);
|
gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged;
|
pageBar1.TotalPages = dd.rtnData.pages;//总页
|
pageBar1.CurrentPage = curPage;//当前页
|
pageBar1.RecordCount = dd.rtnData.total;//总记录数
|
}
|
else
|
{
|
ToolBox.MsgHelper.ShowError("提示：" + dd.rtnMsg);
|
}
|
}
|
catch (Exception ex)
|
{
|
MsgHelper.ShowError("提示：" + ex.Message);
|
}
|
}
|
/// <summary>
|
///
|
/// </summary>
|
/// <param name="strGuid">主键</param>
|
/// <param name="isEdit">是否可编辑</param>
|
/// <param name="tabIdx">选项卡序号</param>
|
private void getModel(string strGuid)
|
{
|
bool isEdit = false;
|
if (toolBarMenu1.currentAction == "add") return;
|
if (toolBarMenu1.currentAction == "edit") isEdit = true;
|
if (string.IsNullOrEmpty(strGuid))
|
{
|
ToolBox.MsgHelper.Warning("请先选择你要操作的行！");
|
return;
|
}
|
var _obj = new
|
{
|
guid = strGuid,//主建
|
};
|
try
|
{
|
string strJson = UtilityHelper.HttpPost("", _webServiceName + "GetModel", JsonConvert.SerializeObject(_obj));
|
ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
|
if (_rtn.rtnCode > 0)
|
{
|
dynamic dy = _rtn.rtnData;
|
lbGuid.Text = strGuid;
|
UtilityHelper.SetValueByObj(this.layoutMx1.Controls, dy, isEdit);
|
|
}
|
else
|
ToolBox.MsgHelper.Warning("提示：" + _rtn.rtnMsg);
|
}
|
catch (Exception ex)
|
{
|
ToolBox.MsgHelper.Warning("提示：" + ex.Message);
|
}
|
}
|
|
|
/// <summary>
|
/// 工具条事件
|
/// </summary>
|
/// <param name="inFieldValue"></param>
|
private void _toolCk(int _inFieldValue)
|
{
|
string strMsg = "";
|
switch (_inFieldValue)
|
{
|
case 1:
|
strMsg = "审核";
|
break;
|
case 0:
|
strMsg = "反审核";
|
break;
|
}
|
;
|
toolBarMenu1.guidKey = "";
|
string rowGuid, rowName;
|
(rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_SalaryType, gridView1, "hourlyType");
|
if (string.IsNullOrEmpty(rowGuid))
|
{
|
MsgHelper.Warning("请先选择你要操作的行！");
|
return;
|
}
|
if (!MsgHelper.AskQuestion("你选择了【" + rowName + "】，确定" + strMsg + "吗？"))
|
return;
|
var _obj = new
|
{
|
guid = rowGuid,
|
ckValue = _inFieldValue,
|
parameter = "MES_JJGZ_JSSALARY,check_Date,check_Status,check_user"
|
};
|
try
|
{
|
var strJson = UtilityHelper.HttpPost("", "General/GeneralCheck",
|
JsonConvert.SerializeObject(_obj));
|
var _rtn = UtilityHelper.ReturnToDynamic(strJson);
|
if (_rtn.rtnCode > 0)
|
{
|
MsgHelper.ShowInformation(_rtn.rtnData.outMsg.ToString());
|
if (xtraTabControl1.SelectedTabPageIndex == 1)
|
{
|
getModel(lbGuid.Text.Trim());
|
}
|
int rowHandle = gridView1.LocateByValue(1, gridView1.Columns["guid"], rowGuid);
|
gridView1.FocusedRowHandle = rowHandle;
|
UtilityHelper.SetCheckIco(gridView1, "checkStatus", "checkBy", "checkDate", picCheckBox, this, _inFieldValue.ToString());
|
}
|
else
|
MsgHelper.ShowError(_rtn.rtnData.outMsg.ToString());
|
}
|
catch (Exception ex)
|
{
|
MsgHelper.ShowError("提示：" + ex.Message);
|
}
|
}
|
|
}
|
}
|
