private object[] GetDeleteEmpList(UltraWebGrid ugrd, int deleteCount)
{
object[] objEmp = new object[(deleteCount == 0 ? ugrd.Rows.Count : deleteCount)];
int i = 0;
if (deleteCount == 0)
{
foreach (UltraGridRow gr in ugrd.Rows)
{
objEmp[i] = gr.Cells.FromKey("EMP_REF_ID").Value;
i++;
}
}
else
{
TemplatedColumn col_Check;
foreach (UltraGridRow gr in ugrd.Rows)
{
col_Check = (TemplatedColumn)gr.Cells.FromKey("selchk").Column;
if (((CheckBox)((CellItem)col_Check.CellItems[gr.BandIndex]).FindControl("cBox")).Checked)
{
objEmp[i] = gr.Cells.FromKey("EMP_REF_ID").Value;
i++;
}
}
}
return(objEmp);
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid;
ColumnsCollection AirlineCols = uwg.Bands[0].Columns;
ColumnsCollection WeightBreakCols = uwg.Bands[1].Columns;
AirlineCols.FromKey("airline").Hidden = true;
WeightBreakCols.FromKey("airline").Hidden = true;
AirlineCols.FromKey("dba_name").Header.Caption = "Airline";
AirlineCols.FromKey("carrier_code").Header.Caption = "Carrier Code";
AirlineCols.FromKey("share").Header.Caption = "Profit Share (%)";
WeightBreakCols.FromKey("weight_break").Header.Caption = "Weight Break";
WeightBreakCols.FromKey("kg_lb").Header.Caption = "Kg/Lb";
WeightBreakCols.FromKey("rate").Header.Caption = "Freight Charge Rate";
WeightBreakCols.FromKey("fl_rate").Header.Caption = "Fuel Surcharge Rate";
WeightBreakCols.FromKey("sec_rate").Header.Caption = "Securoty Surcharge Rate";
WeightBreakCols.FromKey("weight_break").Width = Unit.Pixel(100);
WeightBreakCols.FromKey("kg_lb").Width = Unit.Pixel(35);
WeightBreakCols.FromKey("rate").Width = Unit.Pixel(60);
WeightBreakCols.FromKey("fl_rate").Width = Unit.Pixel(60);
WeightBreakCols.FromKey("sec_rate").Width = Unit.Pixel(60);
}
/// <summary>
/// 删除抄送人员
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelActorCopy_ServerClick(object sender, System.EventArgs e)
{
try
{
Procedure procedure = (Procedure)Session["Procedure"];
Task task = (Task)Session["Task"];
task.RemoveTaskActor(this.DelObjectCode.Value, false);
DataSet ds = Rms.WorkFlow.DefinitionManager.SaveProcedureDefinitionData(procedure);
UltraWebGrid UWGridCopyCase = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(1).FindControl("UltraWebGrid3"));
UWGridCopyCase.DataSource = new DataView(ds.Tables["WorkFlowTaskActor"], String.Format("TaskCode='{0}' and TaskActorID='1'", task.TaskCode), "IOrder", DataViewRowState.CurrentRows);
UWGridCopyCase.DataBind();
for (int i = 0; i < UWGridCopyCase.Rows.Count; i++)
{
if ((string)UWGridCopyCase.Rows[i].Cells[6].Value == "1")
{
UWGridCopyCase.Rows[i].Cells[4].Value = true;
}
else
{
UWGridCopyCase.Rows[i].Cells[4].Value = false;
}
UWGridCopyCase.Rows[i].Cells[7].Value = "<a href='javascript:deleteActor(\"" + (string)UWGridCopyCase.Rows[i].Cells[0].Value + "\",\"1\")'>删除</a>";
}
Session["Procedure"] = procedure;
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
}
}
public GridHelper(UltraWebGrid grid, System.Web.UI.WebControls.CheckBox chbSelectAll)
{
this._grid = grid;
this._chbSelectAll = chbSelectAll;
this.InitGridHelper();
}
private void SetAllTimeTop()
{
ltrScript.Text = "";
TugrdUpStgList = this.ugwtKpiTab.FindControl("ugrdUpStgList") as UltraWebGrid;
TugrdStgPerDept = this.ugwtKpiTab.FindControl("ugrdStgPerDept") as UltraWebGrid;
TiBtnAddUpStg = this.ugwtKpiTab.FindControl("iBtnAddUpStg") as ImageButton;
TiBtnDelUpStg = this.ugwtKpiTab.FindControl("iBtnDelUpStg") as ImageButton;
TugrdKPIPerStg = this.ugwtKpiTab.FindControl("ugrdKPIPerStg") as UltraWebGrid;
TugrdKPIAll = this.ugwtKpiTab.FindControl("ugrdKPIAll") as UltraWebGrid;
TiBtnAddKpi = this.ugwtKpiTab.FindControl("iBtnAddKpi") as ImageButton;
TiBtnDelKpi = this.ugwtKpiTab.FindControl("iBtnDelKpi") as ImageButton;
TiBtnFindKpi = this.ugwtKpiTab.FindControl("iBtnFindKpi") as ImageButton;
TtxtFindKpiID = this.ugwtKpiTab.FindControl("txtFindKpiID") as TextBox;
TtxtFindKpiNM = this.ugwtKpiTab.FindControl("txtFindKpiNM") as TextBox;
TlblWeightTotal = this.ugwtKpiTab.FindControl("lblWeightTotal") as Label;
MicroBSC.Biz.Common.Biz.Biz_Com_Code_Info objCode = new MicroBSC.Biz.Common.Biz.Biz_Com_Code_Info();
ddlMAP_KPI_TYPE_H.DataSource = objCode.GetCodeListPerCategory("BS0017", "Y").Tables[0];
ddlMAP_KPI_TYPE_H.DataTextField = "CODE_NAME";
ddlMAP_KPI_TYPE_H.DataValueField = "ETC_CODE";
ddlMAP_KPI_TYPE_H.DataBind();
ddlMAP_KPI_TYPE_H.Items.Insert(0, new ListItem("::선택::", ""));
}
protected void initEnvironment()
{
exMsg.Text = "";
lblRowCount.Text = "0";
UltraWebGrid.Clear();
ltrScript.Text = "";
ibtnDownExcel.Visible = false;
}
protected void InitializeUWG(object sender, LayoutEventArgs e)
{
UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid;
e.Layout.Bands[0].DataKeyField = "elt_account_number,rate_type,origin_port,dest_port,kg_lb,customer_no";
e.Layout.Bands[1].DataKeyField = "elt_account_number,rate_type,origin_port,dest_port,kg_lb,customer_no,airline";
e.Layout.Bands[2].DataKeyField = "elt_account_number,rate_type,origin_port,dest_port,kg_lb,customer_no,airline,item_no";
FormatColumns(uwg);
}
protected void Page_Load(object sender, EventArgs e)
{
UltraWebGrid uwg = (UltraWebGrid)RateWebGrid.FindControl("UltraWebGrid1");
uwg.InitializeLayout += new InitializeLayoutEventHandler(this.InitializeUWG);
DropDownList lst = (DropDownList)RateWebGrid.FindControl("lstRateTypes");
lst.SelectedValue = rate_type;
}
/// *******************************************************************************************
/// <summary>
/// 角色列表特殊字段帮定，格式化
/// </summary>
/// *******************************************************************************************
private void RoleGridDataBound()
{
Procedure procedure = (Procedure)Session["Procedure"];
UltraWebGrid UWGridCase3 = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(2).FindControl("UltraWebGrid3"));
for (int i = 0; i < UWGridCase3.Rows.Count; i++)
{
if ((string)UWGridCase3.Rows[i].Cells[5].Value == "1")
{
UWGridCase3.Rows[i].Cells[2].Value = true;
}
else if ((string)UWGridCase3.Rows[i].Cells[5].Value == "2")
{
UWGridCase3.Rows[i].Cells[2].Value = true;
//UWGridCase3.Rows[i]. = ;
}
else
{
UWGridCase3.Rows[i].Cells[2].Value = false;
}
string UserCodes = "";
string StationCodes = "";
Role RoleCase = procedure.GetRole((string)UWGridCase3.Rows[i].Cells[0].Value);
System.Collections.IDictionaryEnumerator ieRoleComprise = RoleCase.GetRoleCompriseEnumerator();
while (ieRoleComprise.MoveNext())
{
RoleComprise RoleCompriseCase = (RoleComprise)ieRoleComprise.Value;
if (RoleCompriseCase.RoleType == RoleType.Porson)
{
if (UserCodes == "")
{
UserCodes = RoleCompriseCase.RoleCompriseItem;
}
else
{
UserCodes += "," + RoleCompriseCase.RoleCompriseItem;
}
}
if (RoleCompriseCase.RoleType == RoleType.Station)
{
if (StationCodes == "")
{
StationCodes = RoleCompriseCase.RoleCompriseItem;
}
else
{
StationCodes += "," + RoleCompriseCase.RoleCompriseItem;
}
}
}
UWGridCase3.Rows[i].Cells[4].Value = "<a href='#' onclick='javascript:SelectRoleComprise(\"" + (string)UWGridCase3.Rows[i].Cells[0].Value + "\",\"" + UserCodes + "\",\"" + StationCodes + "\");return false;'>角色维护</a>";
}
}
private object[,] GetInsertEmpList(UltraWebGrid ugrd, int addedCount)
{
object[,] objEmp = new object[(addedCount == 0 ? ugrd.Rows.Count : addedCount), 2];
for (int i = (addedCount == 0 ? 0 : ugrd.Rows.Count - addedCount); i < ugrd.Rows.Count; i++)
{
objEmp[(addedCount == 0 ? i : i - (ugrd.Rows.Count - addedCount)), 0] = DataTypeUtility.GetToInt32(ugrd.Rows[i].Cells.FromKey("EMP_REF_ID").Value);
objEmp[(addedCount == 0 ? i : i - (ugrd.Rows.Count - addedCount)), 1] = DataTypeUtility.GetToInt32(ugrd.Rows[i].Cells.FromKey("SORT_ORDER").Value);
}
return(objEmp);
}
private void SetSortOrder(UltraWebGrid ugrd)
{
for (int i = 0; i < ugrd.Rows.Count; i++)
{
if (DataTypeUtility.GetToInt32(ugrd.Rows[i].Cells.FromKey("SORT_ORDER").Value) != i + 1)
{
ugrd.Rows[i].Cells.FromKey("SORT_ORDER").Value = i + 1;
}
}
}
private void InitializeGrid(UltraWebGrid grid)
{
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in grid.DisplayLayout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
}
// 단일 헤더 합침
ch = grid.DisplayLayout.Bands[0].Columns.FromKey("PRJ_CODE").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = grid.DisplayLayout.Bands[0].Columns.FromKey("PRJ_NAME").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = grid.DisplayLayout.Bands[0].Columns.FromKey("PROCEED_RATE").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = grid.DisplayLayout.Bands[0].Columns.FromKey("OWNER_EMP_NAME").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = grid.DisplayLayout.Bands[0].Columns.FromKey("TASK_OWNER_NAME").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = grid.DisplayLayout.Bands[0].Columns.FromKey("EFFECTIVENESS").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "계획기간";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 8;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
grid.DisplayLayout.Bands[0].HeaderLayout.Add(ch);
grid.DisplayLayout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "비 용";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 10;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
grid.DisplayLayout.Bands[0].HeaderLayout.Add(ch);
grid.DisplayLayout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
}
protected void Page_Load(object sender, EventArgs e)
{
TugrdQuestionItem = this.ugrdKpiStatusTab.FindControl("ugrdQuestionItem") as UltraWebGrid;
ltrScript.Text = "";
if (!Page.IsPostBack)
{
this.SetFormData();
this.SetButton();
}
}
private void DoFocusLine(UltraWebGrid ugrd, int emp_ref_id)
{
foreach (UltraGridRow gr in ugrd.Rows)
{
if (DataTypeUtility.GetToInt32(gr.Cells.FromKey("EMP_REF_ID")) == emp_ref_id)
{
gr.Selected = true;
gr.Activate();
return;
}
}
}
/// *******************************************************************************************
/// <summary>
/// 加载路由数据
/// </summary>
/// *******************************************************************************************
private void RouterGridDataBound()
{
Procedure procedure = (Procedure)Session["Procedure"];
DataSet procedureDS = Rms.WorkFlow.DefinitionManager.SaveProcedureDefinitionData(procedure);
BLL.WorkFlowRule.FillRouterTaskName(procedureDS);
UltraWebGrid UWGridCase2 = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(1).FindControl("UltraWebGrid2"));
UWGridCase2.DataSource = new DataView(procedureDS.Tables["WorkFlowRouter"], "", "SortID", DataViewRowState.CurrentRows);
UWGridCase2.DataBind();
for (int i = 0; i < UWGridCase2.Rows.Count; i++)
{
UWGridCase2.Rows[i].Cells[6].Value = "<a href='javascript:deleteRouter(" + (string)UWGridCase2.Rows[i].Cells[0].Value + ")'>删除</a>";
foreach (DataRow drw in procedureDS.Tables["WorkFlowCondition"].Select("RouterCode='" + UWGridCase2.Rows[i].Cells[0].Value + "'"))
{
UWGridCase2.Rows[i].Cells[5].Value = drw["Description"].ToString();
}
}
ValueList contactTypeFromTask = UWGridCase2.Columns[2].ValueList;
ValueList contactTypeToTask = UWGridCase2.Columns[3].ValueList;
System.Collections.IDictionaryEnumerator ie = procedure.GetTaskEnumerator();
DataTable dt = new DataTable();
dt.Columns.Add("TaskCode");
dt.Columns.Add("TaskName");
dt.Columns.Add("TaskID");
while (ie.MoveNext())
{
Task task = (Task)ie.Value;
DataRow drNew = dt.NewRow();
drNew["TaskCode"] = task.TaskCode;
drNew["TaskName"] = task.TaskName;
drNew["TaskID"] = task.TaskID;
dt.Rows.Add(drNew);
// contactTypeFromTask.ValueListItems.Add(task.TaskCode,task.TaskName);
// contactTypeToTask.ValueListItems.Add(task.TaskCode,task.TaskName);
}
foreach (DataRow dr in dt.Select("", "TaskID", System.Data.DataViewRowState.CurrentRows))
{
contactTypeFromTask.ValueListItems.Add(dr["TaskCode"].ToString(), dr["TaskName"].ToString());
contactTypeToTask.ValueListItems.Add(dr["TaskCode"].ToString(), dr["TaskName"].ToString());
}
}
/// <summary>
/// 체크박스가 있는 그리드에서 체크되어 있는 값을 반영된 DataTable에 넣어주어서
/// 반환한다.
/// </summary>
/// <param name="ultraWebGrid"></param>
/// <param name="checkBoxID"></param>
/// <param name="cellKey_checkBox"></param>
/// <param name="cellKey_value"></param>
/// <param name="blankDataTable"></param>
/// <returns></returns>
public static DataTable GetDataTableByCheckValue(UltraWebGrid ultraWebGrid
, string checkBoxID
, string cellKey_checkBox
, string[] cellKey_values
, DataTable blankDataTable)
{
return(GetDataTableByCheckValue(ultraWebGrid
, checkBoxID
, cellKey_checkBox
, cellKey_values
, blankDataTable
, false));
}
private void DoDeleteEmp(UltraWebGrid ugrdDel, int delCount)
{
//for (int i = ugrdDel.Rows.Count - 1; i < delCount; i++)
//{
// ugrdDel.Rows[ugrdDel.Rows.Count - 1].Delete();
//}
int j = ugrdDel.Rows.Count;
for (int i = ugrdDel.Rows.Count - 1; i > j - delCount - 1; i--)
{
ugrdDel.Rows[i].Delete();
}
}
private int GetSortOrder(UltraWebGrid gr)
{
int rtnValue = 0;
for (int i = 0; i < gr.Rows.Count - 1; i++)
{
if (DataTypeUtility.GetToInt32(gr.Rows[i].Cells.FromKey("SORT_ORDER").Value) > rtnValue)
{
rtnValue = DataTypeUtility.GetToInt32(gr.Rows[i].Cells.FromKey("SORT_ORDER").Value);
}
}
return(rtnValue + 1);
}
/// *******************************************************************************************
/// <summary>
/// 加载数据帮定列表
/// </summary>
/// *******************************************************************************************
private void LoadDataGrid()
{
Procedure procedure = (Procedure)Session["Procedure"];
UltraWebGrid UWGridCase3 = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(2).FindControl("UltraWebGrid3"));
UltraWebGrid UWGridCase4 = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(3).FindControl("UltraWebGrid4"));
DataGrid dgList1 = ((DataGrid)this.UltraWebTab1.Tabs.GetTab(1).FindControl("dgList"));
DataSet procedureDS = Rms.WorkFlow.DefinitionManager.SaveProcedureDefinitionData(procedure);
//任务帮定
TaskGridDataBound();
//路由帮定
RouterGridDataBound();
//角色帮定
UWGridCase3.DataSource = new DataView(procedureDS.Tables["WorkFlowRole"], "", "Remak", DataViewRowState.CurrentRows);
UWGridCase3.DataBind();
for (int i = 0; i < UWGridCase3.Rows.Count; i++)
{
UWGridCase3.Rows[i].Cells[6].Value = "<a href='javascript:deleteRole(\"" + (string)UWGridCase3.Rows[i].Cells[0].Value + "\")'>删除</a>";
}
RoleGridDataBound();
if (Request["Debug"] + "" == "1")
{
//属性帮定
UWGridCase4.DataSource = new DataView(procedureDS.Tables["WorkFlowProcedureProperty"], "", "Remak", DataViewRowState.CurrentRows);
UWGridCase4.DataBind();
dgList1.DataSource = new DataView(procedureDS.Tables["WorkFlowProcedureProperty"], "", "", DataViewRowState.CurrentRows);
dgList1.DataBind();
for (int i = 0; i < UWGridCase4.Rows.Count; i++)
{
UWGridCase4.Rows[i].Cells[4].Value = "<a href='javascript:deleteProperty(\"" + (string)UWGridCase4.Rows[i].Cells[0].Value + "\")'>删除</a>";
}
this.RoleTypeBound(UWGridCase4.Columns[2].ValueList);
this.UltraWebTab1.Tabs[3].Visible = true;
}
else
{
this.UltraWebTab1.Tabs[3].Visible = false;
}
procedureDS.Dispose();
}
private int GetEmpCount(UltraWebGrid gr)
{
int rtnValue = 0;
TemplatedColumn col_Check;
foreach (UltraGridRow insertGR in gr.Rows)
{
col_Check = (TemplatedColumn)insertGR.Cells.FromKey("selchk").Column;
if (((CheckBox)((CellItem)col_Check.CellItems[insertGR.BandIndex]).FindControl("cBox")).Checked)
{
rtnValue++;
}
}
return(rtnValue);
}
public static bool EnableSort(ref UltraWebGrid dg, int sortColIndex)
{
// Call this method and then rely on index to process sort!
if (dg.Page != null)
{
if (dg.Columns.FromKey("s_a") != null)
{
dg.Columns.Remove(dg.Columns.FromKey("s_a"));
}
UltraGridColumn sortCol = new UltraGridColumn("s_a", "", ColumnType.NotSet, null);
dg.Columns.Insert(sortColIndex, sortCol);
dg.Columns.FromKey("s_a").Width = Unit.Pixel(35);
return(true);
}
return(false);
}
protected void Page_Load(object sender, EventArgs e)
{
TugrdBias = this.ugrdKpiStatusTab.FindControl("ugrdBias") as UltraWebGrid;
TchartBias = this.ugrdKpiStatusTab.FindControl("chartBias") as Chart;
TddlEstGroup = this.ugrdKpiStatusTab.FindControl("ddlEstGroup") as DropDownList;
if (!IsPostBack)
{
this.SetEstGroup();
this.SetInitForm();
this.SetEstStatusGrid();
//this.SetPointsForGraph();
}
else
{
}
}
private void CheckBind(UltraWebGrid grid)
{
int EsttermRefID;
int kpiRefID;
int prjRefID;
foreach (UltraGridRow row in grid.Rows)
{
EsttermRefID = DataTypeUtility.GetToInt32(row.Cells.FromKey("ESTTERM_REF_ID").Value);
kpiRefID = DataTypeUtility.GetToInt32(row.Cells.FromKey("KPI_REF_ID").Value);
Biz_Bsc_Kpi_Prj objKpiPrj = new Biz_Bsc_Kpi_Prj();
foreach (UltraGridColumn col in grid.Columns)
{
try
{
prjRefID = DataTypeUtility.GetToInt32(col.Header.Column.Key);
}
catch
{
prjRefID = 0;
}
if (prjRefID != 0)
{
DataTable dt = objKpiPrj.GetOneList(EsttermRefID
, kpiRefID
, prjRefID).Tables[0];
if (dt.Rows.Count == 0 || dt.Rows.Count > 1)
{
continue;
}
else
{
if (DataTypeUtility.GetToInt32(dt.Rows[0]["KPI_REF_ID"]) == kpiRefID &&
DataTypeUtility.GetToInt32(dt.Rows[0]["PRJ_REF_ID"]) == prjRefID)
{
row.Cells.FromKey(col.Header.Column.Key).Value = "<img src='../images/checkbox.gif' border='0' width='15px' height='15px' valign='middle'>";
// row.Cells.FromKey(col.Header.Column.Key).Value = "V";
}
}
}
}
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid;
ColumnsCollection disputeTotal = uwg.Bands[0].Columns;
ColumnsCollection disputeItem = uwg.Bands[1].Columns;
disputeTotal.FromKey("elt_account_number").Hidden = true;
disputeTotal.FromKey("org_account_number").Hidden = true;
disputeItem.FromKey("elt_account_number").Hidden = true;
disputeItem.FromKey("vendor_number").Hidden = true;
disputeItem.FromKey("memo").Hidden = true;
disputeTotal.FromKey("dba_name").Header.Caption = "Vendor";
disputeTotal.FromKey("class_code").Header.Caption = "Class";
disputeTotal.FromKey("business_phone").Header.Caption = "Phone";
disputeItem.FromKey("print_id").Header.Caption = "Tran No";
disputeItem.FromKey("bill_number").Header.Caption = "Bill No";
disputeItem.FromKey("bill_date").Header.Caption = "Tran Date";
disputeItem.FromKey("pmt_method").Header.Caption = "Payment";
disputeItem.FromKey("memo").Header.Caption = "Memo";
disputeItem.FromKey("file_no").Header.Caption = "File No";
disputeItem.FromKey("amt_due").Header.Caption = "Due Amount";
disputeItem.FromKey("amt_paid").Header.Caption = "Paid Amount";
disputeItem.FromKey("amt_dispute").Header.Caption = "Disputed Amount";
disputeTotal.FromKey("dba_name").Width = Unit.Pixel(267);
disputeTotal.FromKey("class_code").Width = Unit.Pixel(80);
disputeTotal.FromKey("business_phone").Width = Unit.Pixel(100);
disputeTotal.FromKey("Bill Amount").Width = Unit.Pixel(100);
disputeTotal.FromKey("Paid Amount").Width = Unit.Pixel(100);
disputeTotal.FromKey("Balance").Width = Unit.Pixel(100);
disputeTotal.FromKey("Dispute Amount").Width = Unit.Pixel(100);
disputeItem.FromKey("bill_number").Width = Unit.Pixel(100);
disputeItem.FromKey("print_id").Width = Unit.Pixel(100);
disputeItem.FromKey("bill_date").Width = Unit.Pixel(80);
disputeItem.FromKey("file_no").Width = Unit.Pixel(165);
disputeItem.FromKey("pmt_method").Width = Unit.Pixel(70);
disputeItem.FromKey("amt_due").Width = Unit.Pixel(100);
disputeItem.FromKey("amt_paid").Width = Unit.Pixel(100);
disputeItem.FromKey("amt_dispute").Width = Unit.Pixel(100);
disputeItem.FromKey("bill_date").Format = "MM/dd/yyyy";
}
public bool IsInExport = false; // Added by Icyer 2006/12/26 @ YHI 标识是否导出操作，如果是导出则不用计算总数
public WebQueryHelper(
HtmlInputButton queryButton,
HtmlInputButton exportButton,
UltraWebGrid grid,
PagerSizeSelector selector,
PagerToolBar toolBar,
ControlLibrary.Web.Language.LanguageComponent languageComponent)
{
//variable
this.cmdQuery = queryButton;
this.cmdGridExport = exportButton;
this.gridWebGrid = grid;
this.pagerSizeSelector = selector;
this.pagerToolBar = toolBar;
this.languageComponent1 = languageComponent;
//export
this.excelExporter = new BenQGuru.eMES.Web.Helper.ExcelExporter();
this.excelExporter.Page = this.gridWebGrid.Page;
this.excelExporter.FormatExportRecordHandle = new FormatExportRecordDelegate(this.FormatExportRecord);
this.excelExporter.LoadExportDataHandle = new LoadExportDataDelegate(this.LoadDataSource);
this.excelExporter.LanguageComponent = this.languageComponent1;
this.excelExporter.GetColumnHeaderTextHandle = new GetColumnHeaderTextDelegate(GetColumnHeaderText);
//register event
if (this.cmdQuery != null)
{
this.cmdQuery.ServerClick += new EventHandler(cmdQuery_ServerClick);
}
if (this.cmdGridExport != null)
{
this.cmdGridExport.ServerClick += new EventHandler(cmdGridExport_ServerClick);
}
if (this.gridWebGrid != null)
{
this.gridWebGrid.ClickCellButton += new ClickCellButtonEventHandler(gridWebGrid_ClickCellButton);
}
if (this.pagerToolBar != null)
{
this.pagerToolBar.OnPagerToolBarClick += new EventHandler(this.PagerToolBar_OnPagerToolBarClick);
}
if (this.pagerSizeSelector != null)
{
this.pagerSizeSelector.OnPagerSizeChanged += new BenQGuru.eMES.Web.Helper.PagerSizeSelector.PagerSizeChangedHandle(pagerSizeSelector_OnPagerSizeChanged);
}
}
private void GridDoLayout(UltraWebGrid grid)
{
Biz_Prj_Info objPrjInfo = new Biz_Prj_Info();
_iprjType = WebUtility.GetByValueDropDownList(ddlPrjType);
_iprjCode = txtPrjCode.Text.Trim();
_iprjName = txtPrjName.Text.Trim();
DataTable dt = objPrjInfo.GetTotalFootInfo(_iprjCode
, _iprjName
, _iprjType).Tables[0];
UltraGridRow row = new UltraGridRow();
grid.Rows.Add(row);
UltraGridRow row2 = new UltraGridRow();
grid.Rows.Add(row2);
UltraGridRow row3 = new UltraGridRow();
grid.Rows.Add(row3);
row.Cells.FromKey("KPI_NAME").Value = "<B>소요예산 : </B>";
row2.Cells.FromKey("KPI_NAME").Value = "<B>집행현황 : </B>";
row3.Cells.FromKey("KPI_NAME").Value = "<B>진행율(%): </B>";
foreach (UltraGridColumn col in grid.Columns)
{
foreach (DataRow dr in dt.Rows)
{
if (col.Header.Column.Key == dr["PRJ_REF_ID"].ToString())
{
double dTotalBudget = DataTypeUtility.GetToDouble(dr["TOTAL_BUDGET"]);
row.Cells.FromKey(col.Header.Column.Key).Value = dTotalBudget.ToString("###,##0.#0");
double dExecAmount = DataTypeUtility.GetToDouble(dr["EXEC_AMOUNT"]);
row2.Cells.FromKey(col.Header.Column.Key).Value = dExecAmount.ToString("###,##0.#0");
double dTotalRate = DataTypeUtility.GetToDouble(dr["RATE"]);
row3.Cells.FromKey(col.Header.Column.Key).Value = dTotalRate.ToString("##0.#0");
}
}
}
}
protected void FormatColumns(UltraWebGrid uwg)
{
ColumnsCollection routeCols = uwg.Bands[0].Columns;
ColumnsCollection airlineCols = uwg.Bands[1].Columns;
ColumnsCollection weightCols = uwg.Bands[2].Columns;
routeCols.FromKey("agent_no").Hidden = true;
airlineCols.FromKey("agent_no").Hidden = true;
weightCols.FromKey("agent_no").Hidden = true;
routeCols.FromKey("dba_name").Header.Caption = "Agent";
UltraGridColumn AgentCol = uwg.Bands[0].Columns.FromKey("dba_name");
AgentCol.EditorControlID = "TextAgent";
AgentCol.Type = ColumnType.Custom;
AgentCol.DataType = "System.String";
AgentCol.Width = Unit.Pixel(300);
}
/// <summary>
/// 체크된Row를 삭제합니다.
/// </summary>
/// <param name="ultraWebGrid"></param>
/// <param name="checkBoxID"></param>
/// <param name="cellKey_checkBox"></param>
public static void SetRemoveRow(UltraWebGrid ultraWebGrid
, string checkBoxID
, string cellKey_checkBox)
{
int cntRow = (ultraWebGrid.Rows.Count - 1);
UltraGridRow row;
for (int i = cntRow; i >= 0; i--)
{
row = ultraWebGrid.Rows[i];
TemplatedColumn col_cBox = (TemplatedColumn)row.Band.Columns.FromKey(cellKey_checkBox);
CheckBox cBox = (CheckBox)((CellItem)col_cBox.CellItems[row.BandIndex]).FindControl(checkBoxID);
if (cBox.Checked)
{
ultraWebGrid.Rows.RemoveAt(i);
}
}
}
protected void cmdGridExport_ServerClick(object sender, System.EventArgs e)
{
UltraWebGrid Grid2 = null;
Grid2 = this.gridHelper.Grid;
for (int i = Grid2.Rows.Count - 1; i >= 0; i--)
{
UltraGridRow row = Grid2.Rows[i];
if (bool.Parse(row.Cells[0].ToString()) &&
row.Cells.FromKey("ImportResult").Value.ToString() == "导入成功")
{
Grid2.Rows.Remove(Grid2.Rows[i]);
}
}
Grid2.Columns.Remove(Grid2.Columns[0]);
//UltraWebGridExcelExporter1.Export(Grid2);
}
/// *******************************************************************************************
/// <summary>
/// 添加角色
/// </summary>
/// *******************************************************************************************
private void SaveRoleData()
{
try
{
Procedure procedure = (Procedure)Session["Procedure"];
UltraWebGrid UWGridCase = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(2).FindControl("UltraWebGrid3"));
for (int i = 0; i < UWGridCase.Rows.Count; i++)
{
bool isNew = (UWGridCase.Rows[i].Cells[0].Text == null);
Role RoleCase = null;
if (isNew)
{
RoleCase = Rms.WorkFlow.DefinitionManager.NewRole();
RoleCase.ProcedureCode = procedure.ProcedureCode;
procedure.AddNewRole(RoleCase);
}
else
{
RoleCase = procedure.GetRole(UWGridCase.Rows[i].Cells[0].Text);
}
RoleCase.RoleName = (string)UWGridCase.Rows[i].Cells[1].Value;
if ((bool)UWGridCase.Rows[i].Cells[2].Value)
{
//RoleCase.ProcedureCode = "";???因为要求在父表中存在子键值所以当前不能使用该模式
RoleCase.RoleType = "1";
}
else
{
RoleCase.RoleType = "0";
}
RoleCase.Remak = (string)UWGridCase.Rows[i].Cells[3].Value;
}
Session["Procedure"] = procedure;
}
catch (Exception ex)
{
throw ex;
}
}
public void UltraWebGrid(UltraWebGrid tmpUltraWebGrid, string condition, string[] captionNames, string[] tableColumns)
{
//tmpUltraWebGrid.Clear(); //清空
tmpUltraWebGrid.Bands[0].Columns.Clear(); //清空數據列
UltraGridBand band = new UltraGridBand();
band = tmpUltraWebGrid.Bands[0];
//Head行
UltraGridColumn tmpHeadColumn = new UltraGridColumn();
UltraGridCell tmpCell = new UltraGridCell();
band.Columns.Add(tmpHeadColumn);
//數據行
UltraGridColumn tmpColumn = new UltraGridColumn();
// tmpColumn.Band.
band.Columns.Add(tmpColumn); //動態增加列
}
/// <summary>
/// 从UltraGrid中获取数值，并返回dataset.
/// </summary>
/// <param name="grid"></param>
/// <returns>UltraGrid中的数据</returns>
public static DataSet_detail GetGridDataSet(UltraWebGrid grid)
{
if (grid.Rows.Count < 1) return null;
DataSet_detail ds = new DataSet_detail();
DataSet_detail.TProjectTypeDetailRow dsRow;
foreach (UltraGridRow row in grid.Bands[0].Grid.Rows)
{
if (row.DataChanged != DataChanged.Modified) continue;
int ShopID = Int32.Parse(row.Cells.FromKey("ShopID").Value.ToString());
int StatTypeID = Int32.Parse(row.Cells.FromKey("StatTypeID").Value.ToString());
int ProjectTypeClassID = Int32.Parse(row.Cells.FromKey("ProjectTypeClassID").Value.ToString());
int ProjectTypeID = Int32.Parse(row.Cells.FromKey("ProjectTypeID").Value.ToString());
int StatYear = Int32.Parse(row.Cells.FromKey("StatYear").Value.ToString());
for (int i = 1; i <= 12; i++)
{
if (false == row.Cells[i + 2].DataChanged) continue;//从第三列开始是一月、二月、三月……
dsRow = ds.TProjectTypeDetail.NewTProjectTypeDetailRow();
dsRow["ShopID"] = ShopID;
dsRow["StatTypeID"] = StatTypeID;
dsRow["ProjectTypeClassID"] = ProjectTypeClassID;
dsRow["ProjectTypeID"] = ProjectTypeID;
dsRow["ProjectTypeDate"] = DateTime.Parse(StatYear.ToString() + "-" + i.ToString());
dsRow["ProjectTypeQty"] = Decimal.Parse(row.Cells[i + 2].Value.ToString());
ds.Tables[0].Rows.Add(dsRow);
}
}
int records = ds.Tables[0].Rows.Count;
return ds;
}
/// <summary>
/// 删除所有行
/// </summary>
/// <param name="grid"></param>
public static void ResetRowsAndColumns(UltraWebGrid grid)
{
grid.ResetColumns();
grid.ResetRows();
}
/// <summary>
/// 设置单元格字体颜色
/// </summary>
/// <param name="rowIdx"></param>
/// <param name="colIdx"></param>
/// <param name="color"></param>
public static void SetCellBackColor(UltraWebGrid grid, int rowIdx, int colIdx, Color color)
{
grid.Rows[rowIdx].Cells[colIdx].Style.BackColor = color;
}
/// <summary>
/// 设置整行字体颜色
/// </summary>
/// <param name="rowIdx"></param>
/// <param name="color"></param>
public static void SetRowForeColor(UltraWebGrid grid, int rowIdx, Color color)
{
foreach (UltraGridCell cell in grid.Rows[rowIdx].Cells)
{
cell.Style.ForeColor = color;
}
}
/// <summary>
/// 在列中将相同值的单元格合并
/// </summary>
/// <param name="grid"></param>
/// <param name="col"></param>
public static void MergeEqualValueCell(UltraWebGrid grid, int col)
{
grid.DisplayLayout.Bands[0].Columns[col].MergeCells = true;
}
/// <summary>
/// 加載數據
/// </summary>
private Sheet LoadData(Sheet tmpSheet, int startRow)
{
UltraWebGrid uwgExport = new UltraWebGrid();
if (this.PanelData.Visible == true)
{
uwgExport = this.UltraWebGridOTMMonthTotal;
}
if (this.PanelImport.Visible == true)
{
uwgExport = this.UltraWebGridImport;
}
int nR = uwgExport.Rows.Count;
//判斷數據控件中是否有數據
if (nR > 0)
{
int nC = uwgExport.Columns.Count;
//逐行加載數據
for (int i = 0; i < nR; i++)
{
Row row1 = tmpSheet.CreateRow(0);
Row row = tmpSheet.CreateRow(startRow + i);
//每行的每列加載數據
for (int j = 1; j < 24; j++)
{
// if (uwgExport.Columns[j].hi)
if (uwgExport.Rows[i].Cells[j].Value != null)
{
row.CreateCell(j - 1).SetCellValue(uwgExport.Rows[i].Cells[j].Value.ToString());
}
else
{
row.CreateCell(j - 1).SetCellValue("");
}
}
DateTime YearMonth = Convert.ToDateTime(this.txtYearMonth.Text + "/01");
int DaysInMonth = DateTime.DaysInMonth(YearMonth.Year, YearMonth.Month);
for (int tmp = 1; tmp < (DaysInMonth + 1); tmp++)
{
row.CreateCell(22 + tmp).SetCellValue(uwgExport.Rows[i].Cells.FromKey("Day" + tmp.ToString()).Value.ToString());
}
}
}
return tmpSheet;
}
public static void SetColWidth(UltraWebGrid grid, int col,int width)
{
grid.DisplayLayout.Bands[0].Columns[col].Width = width;
//grid.DisplayLayout.Bands[0].Columns[col].Header.Style.Width = width;
}
/// <summary>
/// 是否使用Groupby
/// </summary>
/// <param name="grid"></param>
/// <param name="isGroup"></param>
public static void SetGridGroupByHidden(UltraWebGrid grid, bool isGroup)
{
grid.DisplayLayout.GroupByBox.Hidden = isGroup;
}
/// <summary>
/// 设置是否可以排序
/// </summary>
/// <param name="startCol"></param>
/// <param name="endCol"></param>
public static void SetColumnSort(UltraWebGrid grid,SortIndicator sort)
{
for (int i = 0; i < grid.Bands[0].Columns.Count; i++)
{
grid.Bands[0].Columns[i].SortIndicator = sort;//禁用排序
}
}
public static void SetGridColUpdating(UltraWebGrid grid, AllowUpdate allowupdate)
{
grid.Bands[0].AllowUpdate = allowupdate;
}
/// <summary>
/// 数据绑定
/// </summary>
/// <param name="grid"></param>
/// <param name="datasource"></param>
public static void SetGridData(UltraWebGrid grid, object datasource)
{
grid.DataSource = datasource;//数据源设定
grid.DataBind();//绑定
}
public static void SetGridColSizing(UltraWebGrid grid, AllowSizing sizing)
{
grid.Bands[0].AllowColSizing = sizing;
}
public static void SetGridColMoving(UltraWebGrid grid, AllowColumnMoving colMoving)
{
grid.Bands[0].AllowColumnMoving = colMoving;
}
/// <summary>
/// 设置单元格焦点
/// </summary>
/// <param name="row"></param>
/// <param name="col"></param>
public static void SetFocusCell(UltraWebGrid grid, int row, int col)
{
grid.Rows[row].Cells[col].Activate();
}
/// <summary>
/// 隐藏列
/// </summary>
/// <param name="startColIdx"></param>
/// <param name="endColIdx"></param>
/// <param name="isHidden"></param>
public static void SetColHidden(UltraWebGrid grid, int startColIdx, int endColIdx, bool isHidden)
{
for (int i = startColIdx; i < endColIdx; i++ )
{
grid.DisplayLayout.Bands[0].Columns[i].Hidden = isHidden;
}
}
/// <summary>
/// 设置grid的常规属性
/// </summary>
/// <param name="grid"></param>
/// <param name="ds"></param>
public static void SetGridStyle(UltraWebGrid grid)
{
if (grid.Rows.Count < 1) return;
//grid.DisplayLayout.ColHeadersVisibleDefault = ShowMarginInfo.No;
//grid.DisplayLayout.FixedHeaderIndicatorDefault = FixedHeaderIndicator.Button;
//style
SetGridGroupByHidden(grid, true);
SetColumnSort(grid, SortIndicator.Disabled);
SetGridColSizing(grid, AllowSizing.Free);
SetGridColMoving(grid, AllowColumnMoving.None);
grid.DisplayLayout.Bands[0].HeaderStyle.BackColor = Color.FromArgb(220, 233, 246);
grid.DisplayLayout.Bands[0].HeaderStyle.Height = 26;
//15列以后隐藏
SetColHidden(grid, 15, grid.Bands[0].Columns.Count, true);
SetColHidden(grid, 0, 1, true);
MergeEqualValueCell(grid, 0);
MergeEqualValueCell(grid, 1);
MergeEqualValueCell(grid, 2);
SetReadOnlyColumn(grid, 0);
SetReadOnlyColumn(grid, 1);
SetReadOnlyColumn(grid, 2);
for (int colIdx = 0; colIdx < grid.Bands[0].Columns.Count; colIdx++)
{
if (colIdx < 3)
{
SetColWidth(grid, colIdx, COLWIDTH_HEADER);//Row Header Column Width.
grid.Bands[0].Columns[colIdx].CellStyle.Wrap = true;
}
else if (colIdx >= 3 && colIdx <= 14)
{
SetColWidth(grid, colIdx, COLWIDTH_MONTH);//Month Value Column Width.
}
else
{
SetColWidth(grid, colIdx, 0);//Hidden Column Width.
}
}
SetColumnHeaderAlign(grid, 3, grid.Bands[0].Columns.Count, HorizontalAlign.Center);
SetColumnContentAlign(grid, 3, grid.Bands[0].Columns.Count, HorizontalAlign.Center);
//隔行背景淡黄色(月份)
/*
for (int i = 0; i < grid.Bands[0].Grid.Rows.Count; i++)
{
for (int j = 0; j < grid.Bands[0].Grid.Columns.Count; j++)
{
if ((i % 2) != 0 && (j > 2 && j < 15))
{
grid.Bands[0].Grid.Rows[i].Cells[j].Style.BackColor = Color.FromArgb(242, 242, 244);
}
}
}
*/
}
protected void apAuditData(UltraWebGrid ultraWebGrid, string condition, List<string> list_remark, List<string> list_id, string OTAid, string DisSignRmark, string DisApproveEmp, int intDisApprove, string ApRemark, string BillNo, string BillTypeNo)
{
list_remark = new List<string>();
list_id = new List<string>();
TemplatedColumn tcolTMA = (TemplatedColumn)UltraWebGridKQU.Bands[0].Columns[0];
for (int i = 0; i < UltraWebGridKQU.Rows.Count; i++)
{
OTAid = ultraWebGrid.DisplayLayout.Rows[i].Cells.FromKey("ID").Text;//序號
DisSignRmark = ultraWebGrid.DisplayLayout.Rows[i].Cells.FromKey("DISSIGNRMARK").Text;//拒簽欄位
CellItem GridItem = (CellItem)tcolTMA.CellItems[i];
CheckBox chkIsHaveRight = (CheckBox)(GridItem.FindControl("CheckBoxCell"));
if (chkIsHaveRight.Checked)
{
if (!string.IsNullOrEmpty(DisSignRmark))
{
list_remark.Add(DisSignRmark);
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "show", "alert('" + Message.wfm_disapprove_remark + "')", true);
return;
}
list_id.Add(OTAid);
condition += " id = '" + OTAid + "' or";
DisApproveEmp += ultraWebGrid.DisplayLayout.Rows[i].Cells.FromKey("WorkNo").Text +
"/" + ultraWebGrid.DisplayLayout.Rows[i].Cells.FromKey("LocalName").Text + "、";
intDisApprove += 1;//拒簽
}
}
if (intDisApprove > 0)
{
condition = condition.Substring(0, condition.Length - 2);
condition = " and (" + condition + ")";
DisApproveEmp = "|" + DisApproveEmp.Substring(0, DisApproveEmp.Length - 1);
}
else
{
condition = "";
DisApproveEmp = "";
}
ApRemark = ApRemark + DisApproveEmp;
if (intDisApprove == UltraWebGridKQE.Rows.Count)
{
bll.SaveDisAuditData(BillNo, CurrentUserInfo.Personcode, BillTypeNo, ApRemark, list_remark, list_id,logmodel);
}
else
{
bll.SaveAuditData(BillNo, CurrentUserInfo.Personcode, BillTypeNo, ApRemark, condition, list_remark, list_id,logmodel);
}
}
/// <summary>
/// 设置列头对齐方式
/// </summary>
/// <param name="grid"></param>
/// <param name="startCol"></param>
/// <param name="endCol"></param>
/// <param name="ha"></param>
public static void SetColumnHeaderAlign(UltraWebGrid grid, int startCol, int endCol,HorizontalAlign ha)
{
for (int i = startCol; i < endCol; i++)
{
grid.Bands[0].Columns[i].Header.Style.HorizontalAlign = ha;
}
}
private void BindDaysType1(string deptid, string daytype, UltraWebGrid grid)
{
DataTable dt = bll.GetDaysType_1(deptid, daytype);
grid.DataSource = dt;
grid.DataBind();
}
/// <summary>
/// 设置整列为只读
/// </summary>
/// <param name="startCol"></param>
/// <param name="endCol"></param>
public static void SetReadOnlyColumn(UltraWebGrid grid, int col)
{
grid.Bands[0].Columns[col].AllowUpdate = AllowUpdate.No;//不允许修改
}
/// <summary>
/// 设置整列字体颜色
/// </summary>
/// <param name="startCol"></param>
/// <param name="endCol"></param>
/// <param name="color"></param>
public static void SetColumnForeColor(UltraWebGrid grid, int startCol, int endCol, Color color)
{
for (int i = startCol; i < endCol; i++)
{
grid.DisplayLayout.Bands[0].Columns[i].CellStyle.ForeColor = color;
}
}
/// <summary>
/// 设置列宽
/// </summary>
/// <param name="startColIdx"></param>
/// <param name="endColIdx"></param>
/// <param name="width"></param>
public static void SetColWidth(UltraWebGrid grid, int startColIdx, int endColIdx, int width )
{
for ( int i = startColIdx; i < endColIdx; i++ )
{
grid.DisplayLayout.Bands[0].Columns[i].Width = width;
//grid.DisplayLayout.Bands[0].Columns[i].Header.Style.Width = width;
}
}
