private void btnDel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
gvDetail.CloseEditor();
gvConditions.CloseEditor();
gvDetail.BeforeLeaveRow -= gvDetail_BeforeLeaveRow;
if (FocusGV == "gvDetail")
{
DetailQueryInfo Curr_Detail = bsDetailQuery.Current as DetailQueryInfo;
if (Curr_Detail == null)
{
return;
}
bsDetailQuery.RemoveCurrent();
bsDetailQuery.ResetBindings(false);
}
else if (FocusGV == "gvConditions")
{
DetailCondition Curr_Condition = bsCondition.Current as DetailCondition;
if (Curr_Condition == null)
{
return;
}
bsCondition.RemoveCurrent();
bsCondition.ResetBindings(false);
}
}
catch (Exception ex)
{ MsgBox.ShowError(ex.Message); }
finally
{ gvDetail.BeforeLeaveRow += gvDetail_BeforeLeaveRow; }
}
private void gvCondition_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
try
{
DetailCondition Curr_Condtion = bsCondtions.Current as DetailCondition;
if (Curr_Condtion != null)
{
this.rtxtShowExam.Text = Curr_Condtion.ConditionName;
}
}
catch (Exception ex)
{ MsgBox.ShowError(ex.Message); }
}
public PMS06002DetailViewModel()
{
Condition = new DetailCondition();
GroupName = " ";
UserName = "******";
EstimatedTime = " ";
ActualTime = " ";
EstimatedTimeTotal = " ";
TotalCost = " ";
TotalIncome = " ";
CbRegistType = true;
UpdateInfo = new UpdateInfo();
}
private void FrmDetailSqlSet_Shown(object sender, EventArgs e)
{
try
{
this.bsCondtions.DataSource = QueryInfo.Condition;
DetailCondition SysFuc = new DetailCondition();
SysFuc.IsSystem = true;
SysFuc.ConditionCode = "Empty_Null{|}";
SysFuc.ConditionName = "该函数指对应的条件没有值\r\n则查询所有,|前面为条件字段\r\n,后面为自定义条件,例:Empty_Null{CarCode|'[CarCode]'}";
bsCondtions.Add(SysFuc);
bsCondtions.ResetBindings(false);
}
catch (Exception ex)
{ MsgBox.ShowError(ex.Message); }
}
/// <summary>
/// Get profit member in project detail
/// </summary>
/// <param name="model"></param>
/// <param name="companyCode"></param>
/// <param name="condition"></param>
/// <returns></returns>
public PageInfo <dynamic> GetProjectMemberProfitDetail(
DataTablesModel model,
string companyCode,
DetailCondition condition)
{
var pageInfo = this._repository.GetProjectMemberProfitDetail(
model.iDisplayStart,
model.iDisplayLength,
model.sColumns,
model.iSortCol_0,
model.sSortDir_0,
companyCode,
condition);
return(pageInfo);
}
private void gvCondition_DoubleClick(object sender, EventArgs e)
{
try
{
DetailCondition Curr_Condtion = bsCondtions.Current as DetailCondition;
if (Curr_Condtion != null)
{
string ConditionCode = Curr_Condtion.ConditionCode;
if (!string.IsNullOrEmpty(ConditionCode))
{
string s = rtbSQL.Text;
int idx = rtbSQL.SelectionStart;
string res = s.Insert(idx, Curr_Condtion.IsSystem ? ConditionCode : "[" + ConditionCode + "]");
rtbSQL.Text = res;
rtbSQL.SelectionStart = idx + s.Length;
rtbSQL.Focus();
}
}
}
catch (Exception ex)
{ MsgBox.ShowError(ex.Message); }
}
/// <summary>
/// Get Actual work detail info
/// </summary>
/// <param name="condition">condition</param>
/// <returns>Work Detail</returns>
public WorkDetailInfo GetDetailInfo(DetailCondition condition, string companyCode)
{
return(repository.GetDetailInfo(condition, companyCode));
}
/// <summary>
/// Get List User Actual Work Detail
/// </summary>
/// <param name="condition">condition</param>
/// <param name="companycode">companycode</param>
/// <returns>List User Actual Work Detail</returns>
public IList <UserActualWorkDetailPlus> GetUserActualWorkDetailPlus(DetailCondition condition, string companycode)
{
return(repository.GetUserActualWorkDetailPlus(condition, companycode));
}
/// <summary>
/// Get list actual work detail new
/// </summary>
/// <param name="condition">condition</param>
/// <param name="company_code">company_code</param>
/// <returns>list actual work detail new</returns>
public IList <dynamic> GetActualWorkDetailNew(DetailCondition condition, string company_code)
{
return(repository.GetActualWorkDetailNew(company_code, condition.UserId, condition.SelectedYear, condition.SelectedMonth));
}
/// <summary>
/// get work detail for export
/// </summary>
/// <param name="condition">condition</param>
/// <param name="companyCode">companyCode</param>
/// <returns>List work detail</returns>
public IList <UserActualWorkDetail> GetWorkDetailExport(DetailCondition condition, string companyCode)
{
return(repository.GetWorkDetailExport(condition, companyCode));
}
/// <summary>
/// get work detail
/// </summary>
/// <param name="model">model</param>
/// <param name="condition">condition</param>
/// <param name="companycode">companycode</param>
/// <returns>List User Actual Work Detail</returns>
public PageInfo <UserActualWorkDetailPlus> GetWorkDetail(DataTablesModel model, DetailCondition condition, string companycode)
{
var pageInfo = this.repository.GetWorkDetail(
model.iDisplayStart,
model.iDisplayLength,
model.sColumns,
model.iSortCol_0,
model.sSortDir_0,
companycode,
condition);
return(pageInfo);
}
/// <summary>
/// get update, insert information
/// </summary>
/// <param name="condition">condition</param>
/// <param name="companyCode">companyCode</param>
/// <returns>Update info</returns>
public UpdateInfo GetUpdateInfor(DetailCondition condition, string companyCode)
{
return(repository.GetUpdateInfor(condition, companyCode));
}
