private void CreateLayoutItems(LayoutControl layout)
{
layout.BeginUpdate();
try
{
layout.Clear();
IList <DocumentItemBase> documentItems = GetSortedDocumentItems();
if (documentItems.Count != 0)
{
int itemsPerRow = DefaultItemsPerRow;
ItemsPerRowAttribute attr = MemberInfo.FindAttribute <ItemsPerRowAttribute>();
if (attr != null)
{
itemsPerRow = attr.Value;
}
for (int rowNumber = 0; rowNumber < Math.Ceiling((decimal)documentItems.Count / (decimal)itemsPerRow); rowNumber++)
{
LayoutControlGroup row = layout.AddGroup();
row.Name = GetId("Row", rowNumber);
row.DefaultLayoutType = DevExpress.XtraLayout.Utils.LayoutType.Horizontal;
row.GroupBordersVisible = false;
for (int cellNumber = 0; cellNumber < itemsPerRow; cellNumber++)
{
if (rowNumber * itemsPerRow + cellNumber < documentItems.Count)
{
DocumentItemBase item = documentItems[rowNumber * itemsPerRow + cellNumber];
LayoutControlItem cell = new LayoutControlItem(layout, CreateDocumentItemEditor(item));
cell.Name = GetId("Cell", item);
cell.Text = item.Caption;
if (application.Model.Options.LayoutManagerOptions.EnableCaptionColon)
{
cell.Text += ":";
}
row.Add(cell);
}
else
{
row.Add(new EmptySpaceItem());
}
}
}
}
}
finally
{
layout.EndUpdate();
layout.BestFit();
}
}
private void AddLayoutControl()
{
int x = 100, y = 80;
if (fieldCount < 6)
{
x = 200;
y = 160;
}
this.Width = fieldCount * 50 + x;
this.Height = fieldCount * 40 + y;
LayoutControl lcMain;
GridControl gcTmp = null;
lcMain = _frmDesigner.GenLayout2(ref gcTmp, true);
lcMain.Root.DefaultLayoutType = DevExpress.XtraLayout.Utils.LayoutType.Vertical;
LayoutControlItem lci3 = new LayoutControlItem();
lci3.TextVisible = false;
lcMain.AddItem(lci3);
LayoutControlItem lci1;
lci1 = new LayoutControlItem();
lci1.Control = simpleButtonAccept;
lci1.TextVisible = false;
LayoutControlItem lci2;
lci2 = new LayoutControlItem();
lci2.Control = simpleButtonCancel;
lci2.TextVisible = false;
LayoutControlGroup lcg3 = lcMain.Root.AddGroup();
lcg3.TextVisible = false;
lcg3.GroupBordersVisible = false;
lcg3.DefaultLayoutType = DevExpress.XtraLayout.Utils.LayoutType.Horizontal;
lcg3.Add(lci1); lcg3.Add(lci2);
lcg3.Size = new Size(0, 20);
lci1.Size = new Size((lcg3.Size.Width / 2), 0);
//if (fieldCount > 6)
// lcMain = _frmDesigner.GenLayout2(ref gcTmp, false);
//else
// lcMain = _frmDesigner.GenLayout1(ref gcTmp, false);
this.Controls.Add(lcMain);
}
public void PutDashboardInLayoutGroup(LayoutControlGroup editor)
{
var os = ObjectSpace as XPObjectSpace;
var session = os?.Session;
var template = session.Query <DoSoDashboard>().FirstOrDefault(x => x.Name.ToLower() == "default");
if (template == null)
{
return;
}
var dashboard = template.CreateDashBoard();
var parameters = dashboard.Parameters.Where(x => x.Name.ToLower() == "currentobject");
editor.Items.Clear();
viewver = new DashboardViewer {
Dock = DockStyle.Fill
};
//var dss = new List<DataSource>();
////dss.AddRange(dashboard.DataSources);
//dashboard.DataSources.Clear();
editor.Add(new LayoutControlItem()
{
Control = viewver, TextVisible = false
});
viewver.Dashboard = dashboard;
//Task.Run(() => AddDataSource2Dashboard(dss, viewver));
}
public void CreateLayoutEditor(DynamicObjectHelper dynamicObject)
{
if (dynamicObject.classDesc == null)
{
return;
}
this.dynamicObject = dynamicObject;
bindingSource.DataSource = dynamicObject.objclass;
int group_idx = 1;
while (true)
{
List <TableColumnDesc> list = dynamicObject.ColumnList.FindAll(obj => obj.Group_idx == group_idx);
if (list.Count > 0)
{
string group_text = String.Empty;
TableColumnDisplay display = dynamicObject.ColumnLanguageDisplayList.Find(obj => obj.Id == list[0].Id);
if (display != null)
{
group_text = display.Column_display_name;
}
LayoutControlGroup grp = this.CreateLayoutGroup(group_text);
#region 子Group
(int min, int max)tuple = (list.Min(obj => obj.Sub_group_idx), list.Min(obj => obj.Sub_group_idx));
if (tuple.min > 0)
{
for (int k = tuple.min; k <= tuple.max; k++)
{
List <TableColumnDesc> sub_list = list.FindAll(obj => obj.Sub_group_idx == k);
grp.Add(this.CreateLayoutGroup(sub_list, dynamicObject.ColumnLanguageDisplayList, dynamicObject.ColumnReferenceList, dynamicObject.ColumnRegularList));
}
}
#endregion
#region 单个Group
else
{
grp = this.CreateLayoutGroup(list, dynamicObject.ColumnLanguageDisplayList, dynamicObject.ColumnReferenceList, dynamicObject.ColumnRegularList);
}
#endregion
this.layoutEdit.AddGroup(grp);
}
else
{
break;
}
group_idx++;
}
List <ClassRelated> sub_class = GlobeData.classRelatedList.FindAll(obj => obj.Main_class_id == dynamicObject.classDesc.Id);
foreach (ClassRelated sub in sub_class)
{
ClassDesc subclass = GlobeData.classDescList.Find(obj => obj.Id == sub.Sub_class_id);
LayoutControlGroup grp1 = this.CreateLayoutGroup(subclass.Class_name);
LayoutControlItem item = this.CreateGridListViewItem(subclass);
grp1.AddItem(item);
layoutEdit.AddGroup(grp1);
}
}
private static void addEmptyPlaceHolder(LayoutControlGroup dummyGroup)
{
dummyGroup.Add(new EmptySpaceItem());
dummyGroup.TextVisible = false;
dummyGroup.GroupBordersVisible = false;
}
public void Load_QC(string sDate)
{
sSelectedDate = sDate;
iSamplePercent = ((frmMain)ParantForm).txtQCSamplePecent.Value;
if (GV.sAccessTo == "TR")
{
sDateColumn = "TR_DATECALLED";
}
else
{
sDateColumn = "WR_DATE_OF_PROCESS";
}
if (((frmMain)ParantForm).switchQCProcessTable.Value)
{
sProcessTable = "Company";
}
else
{
sProcessTable = "Contact";
}
if (((frmMain)ParantForm).switchQCProcessType.Value)
{
sProcessType = "Reprocessed";
}
else
{
sProcessType = "Fresh";
}
lblProcessDate.Text = " Process Date :" + sDate;
lblProcessTable.Text = " Process Table :" + sProcessTable;
lblSamplePercent.Text = " Sample Percent :" + iSamplePercent;
lblProcessType.Text = " Process Type :" + sProcessType;
splitQC.Panel2Collapsed = true;
if (GV.sUserType == "QC" || GV.sUserType == "Admin")
{
gControl.DataSource = null;
string sQuery = string.Empty;
string sValidContactStatus = string.Empty;
if (GV.sAccessTo == "TR")
{
sValidContactStatus = GV.sTRContactstatusTobeValidated;
}
else
{
sValidContactStatus = GV.sWRContactstatusTobeValidated;
}
string sProcessed = string.Empty;
if (sProcessType == "Reprocessed")
{
sProcessed = " WHERE (SendBack > 0 OR Reprocessed >0) ";
}
if (sProcessTable == "Contact")
{
//sQuery = "SELECT T.AgentName,Processed, ROUND(((Pass + Fail)/Processed)*100,2,1) Sampled,ROUND((Pass/Processed)*100,2,1) Pass,ROUND((Fail/Processed)*100,2,1) Fail, SendBack,Reprocessed FROM (";
//sQuery += " SELECT " + GV.sAccessTo + "_AGENT_NAME AgentName,COUNT(*) Processed,";
//sQuery += " COUNT((SELECT 1 FROM " + GV.sQCTable + " QC WHERE QC.RecordID=CM.CONTACT_ID_P AND TABLENAME='Contact' AND QC.ResearchType='" + GV.sAccessTo + "' AND QC.QC_Sample_Status = 1)) Pass,";
//sQuery += " COUNT((SELECT 1 FROM " + GV.sQCTable + " QC WHERE QC.RecordID=CM.CONTACT_ID_P AND TABLENAME='Contact' AND QC.ResearchType='" + GV.sAccessTo + "' AND QC.QC_Sample_Status = 0)) Fail,";
//sQuery += " COUNT((SELECT 1 FROM " + GV.sQCTable + " QC WHERE QC.RecordID=CM.CONTACT_ID_P AND TABLENAME='Contact' AND QC.ResearchType='" + GV.sAccessTo + "' AND QC.QC_STATUS='SendBack')) SendBack,";
//sQuery += " COUNT((SELECT 1 FROM " + GV.sQCTable + " QC WHERE QC.RecordID=CM.CONTACT_ID_P AND TABLENAME='Contact' AND QC.ResearchType='" + GV.sAccessTo + "' AND QC.QC_STATUS='Reprocessed')) Reprocessed";
//sQuery += " FROM " + GV.sContactTable + " CM WHERE cm." + GV.sAccessTo + "_CONTACT_STATUS IN (" + sValidContactStatus + ")";
//sQuery += " AND CAST(CM." + GV.sAccessTo + "_UPDATED_DATE AS DATE) = '" + sDate + "' GROUP BY " + GV.sAccessTo + "_AGENT_NAME)T " + sProcessed + " Order by T.Processed Desc;";
sQuery = "select T.AgentName,Processed, ROUND(((Pass + Fail) / Processed) * 100, 2, 1) Sampled,ROUND((Pass / Processed) * 100, 2, 1) Pass,ROUND((Fail / Processed) * 100, 2, 1) Fail, SendBack, Reprocessed from (";
sQuery += " select cm." + GV.sAccessTo + "_AGENT_NAME agentname, COUNT(*) Processed,";
sQuery += " count(case when QC.QC_Sample_Status = 1 then cm.CONTACT_ID_P end) Pass,";
sQuery += " count(case when QC.QC_Sample_Status = 0 then cm.CONTACT_ID_P end) Fail,";
sQuery += " count(case when QC.QC_STATUS = 'SENDBACK' then cm.CONTACT_ID_P end) SendBack,";
sQuery += " count(case when QC.QC_STATUS = 'Reprocessed' then cm.CONTACT_ID_P end) Reprocessed";
sQuery += " from " + GV.sContactTable + " CM left join (select * from " + GV.sQCTable + " where TableName = 'Contact' AND ResearchType = '" + GV.sAccessTo + "') QC";
sQuery += " on QC.RecordID = CM.CONTACT_ID_P WHERE cm." + GV.sAccessTo + "_CONTACT_STATUS IN (" + sValidContactStatus + ")";
sQuery += " AND CAST(CM." + GV.sAccessTo + "_UPDATED_DATE AS DATE) = '" + sDate + "' GROUP BY cm." + GV.sAccessTo + "_AGENT_NAME )t Order by T.Processed Desc;";
}
else
{
//sQuery = "SELECT T.AgentName,Processed, ROUND(((Pass + Fail)/Processed)*100,2,1) Sampled,ROUND((Pass/Processed)*100,2,1) Pass,ROUND((Fail/Processed)*100,2,1) Fail, SendBack,Reprocessed FROM (";
//sQuery += " SELECT " + GV.sAccessTo + "_AGENTNAME AgentName,COUNT(*) Processed,";
//sQuery += " COUNT((SELECT 1 FROM " + GV.sQCTable + " QC WHERE QC.RecordID=CM.MASTER_ID AND TABLENAME='Company' AND QC.ResearchType='" + GV.sAccessTo + "' AND QC.QC_Sample_Status = 1)) Pass,";
//sQuery += " COUNT((SELECT 1 FROM " + GV.sQCTable + " QC WHERE QC.RecordID=CM.MASTER_ID AND TABLENAME='Company' AND QC.ResearchType='" + GV.sAccessTo + "' AND QC.QC_Sample_Status = 0)) Fail,";
//sQuery += " COUNT((SELECT 1 FROM " + GV.sQCTable + " QC WHERE QC.RecordID=CM.MASTER_ID AND TABLENAME='Company' AND QC.ResearchType='" + GV.sAccessTo + "' AND QC.QC_STATUS='SendBack')) SendBack,";
//sQuery += " COUNT((SELECT 1 FROM " + GV.sQCTable + " QC WHERE QC.RecordID=CM.MASTER_ID AND TABLENAME='Company' AND QC.ResearchType='" + GV.sAccessTo + "' AND QC.QC_STATUS='Reprocessed')) Reprocessed";
//sQuery += " FROM " + GV.sCompanyTable + " CM WHERE ";
//sQuery += " CAST(CM." + sDateColumn + " AS DATE) = '" + sDate + "' GROUP BY " + GV.sAccessTo + "_AGENTNAME)T " + sProcessed + " Order by T.Processed Desc;";
sQuery = "select T.AgentName,Processed, ROUND(((Pass + Fail) / Processed) * 100, 2, 1) Sampled,ROUND((Pass / Processed) * 100, 2, 1) Pass,ROUND((Fail / Processed) * 100, 2, 1) Fail, SendBack, Reprocessed from (";
sQuery += " select cm." + GV.sAccessTo + "_AGENT_NAME agentname, COUNT(*) Processed,";
sQuery += " count(case when QC.QC_Sample_Status = 1 then cm.CONTACT_ID_P end) Pass,";
sQuery += " count(case when QC.QC_Sample_Status = 0 then cm.CONTACT_ID_P end) Fail,";
sQuery += " count(case when QC.QC_STATUS = 'SENDBACK' then cm.CONTACT_ID_P end) SendBack,";
sQuery += " count(case when QC.QC_STATUS = 'Reprocessed' then cm.CONTACT_ID_P end) Reprocessed";
sQuery += " from " + GV.sContactTable + " CM left join (select * from " + GV.sQCTable + " where TableName = 'Contact' AND ResearchType = '" + GV.sAccessTo + "') QC";
sQuery += " on QC.RecordID = CM.CONTACT_ID_P WHERE ";
sQuery += " CAST(CM." + sDateColumn + " AS DATE) = '" + sDate + "' GROUP BY cm." + GV.sAccessTo + "_AGENT_NAME )t Order by T.Processed Desc;";
}
dtQCTable = GV.MSSQL1.BAL_ExecuteQuery(sQuery);
if (dtQCTable.Rows.Count > 0)
{
DataColumn dcEmpImage = new DataColumn("EmpImage", typeof(System.Byte[]));
dtQCTable.Columns.Add("Random");
dtQCTable.Columns.Add("GetSample");
dtQCTable.Columns.Add("QCProcessed");
dtQCTable.Columns.Add(dcEmpImage);
sQuery = "SELECT UserName , EmployeeImage FROM RM..EmployeeImage A INNER JOIN CH1020BD02.Timesheet.dbo.Users B ON A.EmployeeID = B.EmployeeNo WHERE B.Active = 'Y' AND B.UserName IN (" + GM.ColumnToQString("AgentName", dtQCTable, "String") + ");";
DataTable dtEmpImage = GV.MSSQL1.BAL_ExecuteQuery(sQuery);
Byte[] bDummyImg = GM.imgToByte(Properties.Resources.Misc_User_icon__1_);
foreach (DataRow drImage in dtEmpImage.Rows)
{
string sEmpName = drImage["UserName"].ToString().ToUpper();
foreach (DataRow drQCTable in dtQCTable.Rows)
{
if (drQCTable["AgentName"].ToString().ToUpper() == sEmpName)
{
drQCTable["EmpImage"] = drImage["EmployeeImage"];
break;
}
if (drQCTable["EmpImage"] == DBNull.Value)
{
drQCTable["EmpImage"] = bDummyImg;
}
}
}
//System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmQC));
lView = new LayoutView(gControl);
gControl.LookAndFeel.SkinName = "Office 2010 Blue";
gControl.LookAndFeel.UseDefaultLookAndFeel = false;
lView.OptionsSelection.MultiSelect = false;
gControl.MainView = lView;
DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit btnItemRandom = new DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit();
btnItemRandom.Name = "btnRandom";
btnItemRandom.Buttons[0].Caption = "Random";
btnItemRandom.Buttons[0].IsLeft = false;
btnItemRandom.Buttons[0].Width = 30;
btnItemRandom.Buttons[0].Kind = ButtonPredefines.Glyph;
btnItemRandom.Buttons[0].Image = Properties.Resources.new_icon;
btnItemRandom.TextEditStyle = TextEditStyles.HideTextEditor;
// btnItemRandom.AutoHeight = true;
btnItemRandom.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
btnItemRandom.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.btnRandom_ButtonClick);
DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit btnItemGetSample = new DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit();
btnItemGetSample.Name = "btnGetSample";
btnItemGetSample.Buttons[0].Caption = "Sampled";
btnItemGetSample.Buttons[0].IsLeft = false;
btnItemGetSample.Buttons[0].Width = 30;
btnItemGetSample.Buttons[0].Kind = ButtonPredefines.Glyph;
btnItemGetSample.Buttons[0].Image = Properties.Resources.contacts_3_icon;
btnItemGetSample.TextEditStyle = TextEditStyles.HideTextEditor;
//btnItemGetSample.AutoHeight = true;
btnItemGetSample.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
btnItemGetSample.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.btnGetSample_ButtonClick);
DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit btnItemQCProcessed = new DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit();
btnItemQCProcessed.Name = "btnQCProcessed";
btnItemQCProcessed.Buttons[0].Caption = "QC Processed";
btnItemQCProcessed.Buttons[0].IsLeft = false;
btnItemQCProcessed.Buttons[0].Width = 30;
btnItemQCProcessed.Buttons[0].Kind = ButtonPredefines.Glyph;
btnItemQCProcessed.Buttons[0].Image = Properties.Resources.folder_icon__1_;
btnItemQCProcessed.TextEditStyle = TextEditStyles.HideTextEditor;
//btnItemQCProcessed.AutoHeight = true;
btnItemQCProcessed.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
btnItemQCProcessed.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.btnShowProcessed_ButtonClick);
lView.OptionsBehavior.AutoPopulateColumns = false;
splitQC.Panel1.Controls.Add(gControl);
splitQC.Panel1.Controls.Add(panelQCInfo);
gControl.Dock = DockStyle.Fill;
panelQCInfo.Dock = DockStyle.Top;
LayoutViewColumn colAgentName = lView.Columns.AddField("AgentName");
LayoutViewColumn colProcessCount = lView.Columns.AddField("Processed");
LayoutViewColumn colSampled = lView.Columns.AddField("Sampled");
LayoutViewColumn colPass;
LayoutViewColumn colFail;
if (sProcessType == "Fresh")
{
colPass = lView.Columns.AddField("Pass");
colFail = lView.Columns.AddField("Fail");
}
else
{
colPass = lView.Columns.AddField("SendBack");
colFail = lView.Columns.AddField("Reprocessed");
}
LayoutViewColumn colbtnRandom = lView.Columns.AddField("Random");
LayoutViewColumn colbtnGetSample = lView.Columns.AddField("GetSample");
LayoutViewColumn colbtnQCProcessed = lView.Columns.AddField("QCProcessed");
LayoutViewColumn colPhoto = lView.Columns.AddField("EmpImage");
//colbtnRandom.ShowButtonMode = DevExpress.XtraGrid.Views.Base.ShowButtonModeEnum.ShowAlways;
LayoutViewField fieldAgentName = colAgentName.LayoutViewField;
LayoutViewField fieldProcessCount = colProcessCount.LayoutViewField;
LayoutViewField fieldSampled = colSampled.LayoutViewField;
LayoutViewField fieldPass = colPass.LayoutViewField;
LayoutViewField fieldFail = colFail.LayoutViewField;
LayoutViewField fieldbtnRandom = colbtnRandom.LayoutViewField;
LayoutViewField fieldbtnGetSample = colbtnGetSample.LayoutViewField;
LayoutViewField fieldbtnQCProcessed = colbtnQCProcessed.LayoutViewField;
LayoutViewField fieldEmpPhoto = colPhoto.LayoutViewField;
fieldEmpPhoto.SizeConstraintsType = SizeConstraintsType.Custom;
//fieldEmpPhoto.MaxSize = new System.Drawing.Size(20, 20);
fieldEmpPhoto.MinSize = new System.Drawing.Size(100, 100);
fieldEmpPhoto.TextSize = new System.Drawing.Size(0, 0);
fieldEmpPhoto.TextToControlDistance = 0;
fieldEmpPhoto.TextVisible = false;
fieldAgentName.MinSize = new System.Drawing.Size(100, 100);
fieldAgentName.TextSize = new System.Drawing.Size(0, 0);
fieldAgentName.TextToControlDistance = 0;
fieldAgentName.TextVisible = false;
colAgentName.AppearanceCell.Font = new System.Drawing.Font(colAgentName.AppearanceCell.Font.FontFamily, 12, FontStyle.Bold);
colPhoto.Visible = true;
//RepositoryItemPictureEdit riPictureEdit = grid.RepositoryItems.Add("PictureEdit") as RepositoryItemPictureEdit;
RepositoryItemPictureEdit riPictureEdit = new RepositoryItemPictureEdit();
riPictureEdit.SizeMode = PictureSizeMode.Zoom;
colPhoto.ColumnEdit = riPictureEdit;
lView.OptionsView.ShowHeaderPanel = false;
lView.OptionsView.ViewMode = LayoutViewMode.MultiColumn;
colAgentName.OptionsColumn.AllowFocus = false;
colProcessCount.OptionsColumn.AllowFocus = false;
colSampled.OptionsColumn.AllowFocus = false;
colPass.OptionsColumn.AllowFocus = false;
colFail.OptionsColumn.AllowFocus = false;
colPhoto.OptionsColumn.AllowFocus = false;
colAgentName.OptionsColumn.AllowEdit = false;
colProcessCount.OptionsColumn.AllowEdit = false;
colSampled.OptionsColumn.AllowEdit = false;
colPass.OptionsColumn.AllowEdit = false;
colFail.OptionsColumn.AllowEdit = false;
colPhoto.OptionsColumn.AllowEdit = false;
colAgentName.OptionsFilter.AllowFilter = false;
colProcessCount.OptionsFilter.AllowFilter = false;
colSampled.OptionsFilter.AllowFilter = false;
colPass.OptionsFilter.AllowFilter = false;
colFail.OptionsFilter.AllowFilter = false;
colbtnRandom.OptionsFilter.AllowFilter = false;
colbtnGetSample.OptionsFilter.AllowFilter = false;
colbtnQCProcessed.OptionsFilter.AllowFilter = false;
colPhoto.OptionsFilter.AllowFilter = false;
colAgentName.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
colProcessCount.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
colSampled.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
colPass.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
colFail.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
colbtnRandom.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
colbtnGetSample.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
colbtnQCProcessed.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
colPhoto.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
colAgentName.OptionsColumn.ReadOnly = true;
colProcessCount.OptionsColumn.ReadOnly = true;
colSampled.OptionsColumn.ReadOnly = true;
colPass.OptionsColumn.ReadOnly = true;
colFail.OptionsColumn.ReadOnly = true;
colbtnRandom.OptionsColumn.ReadOnly = true;
colbtnGetSample.OptionsColumn.ReadOnly = true;
colbtnQCProcessed.OptionsColumn.ReadOnly = true;
colPhoto.OptionsColumn.ReadOnly = true;
colbtnRandom.ColumnEdit = btnItemRandom;
colbtnGetSample.ColumnEdit = btnItemGetSample;
colbtnQCProcessed.ColumnEdit = btnItemQCProcessed;
DevExpress.XtraGrid.StyleFormatCondition styleFormatCondition1 = new DevExpress.XtraGrid.StyleFormatCondition();
styleFormatCondition1.Appearance.BackColor = Color.RosyBrown;
styleFormatCondition1.Appearance.Options.UseBackColor = true;
styleFormatCondition1.ApplyToRow = false;
styleFormatCondition1.Column = colProcessCount;
styleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Expression;
styleFormatCondition1.Expression = "[Processed] > 20";
lView.FormatConditions.AddRange(new DevExpress.XtraGrid.StyleFormatCondition[] { styleFormatCondition1 });
fieldAgentName.Move(new LayoutItemDragController(fieldAgentName, fieldEmpPhoto, InsertLocation.After, LayoutType.Horizontal));
LayoutControlGroup groupAgentInfo = lView.TemplateCard.AddGroup("Agent Info", fieldAgentName, InsertType.Bottom);
//groupAddress.Add(colPhoto.LayoutViewField);
//groupAddress.Add(colAgentName.LayoutViewField);
groupAgentInfo.Add(colProcessCount.LayoutViewField);
groupAgentInfo.Add(colSampled.LayoutViewField);
groupAgentInfo.Add(colPass.LayoutViewField);
groupAgentInfo.Add(colFail.LayoutViewField);
groupAgentInfo.Add(colbtnRandom.LayoutViewField);
groupAgentInfo.Add(colbtnGetSample.LayoutViewField);
groupAgentInfo.Add(colbtnQCProcessed.LayoutViewField);
//LayoutControlGroup groupRecords = lView.TemplateCard.AddGroup("Record", groupAgentInfo, InsertType.Bottom);
//groupRecords.Add(colbtnRandom.LayoutViewField);
//groupRecords.Add(colbtnGetSample.LayoutViewField);
//groupRecords.Add(colbtnQCProcessed.LayoutViewField);
colAgentName.Caption = "Agent Name";
colProcessCount.Caption = "Total Processed";
colSampled.Caption = "Sampled %";
if (sProcessType == "Fresh")
{
colPass.Caption = "Pass %";
colFail.Caption = "Fail %";
}
else
{
colPass.Caption = "Send Back";
colFail.Caption = "Reprocessed";
}
colbtnRandom.Caption = "Get a Random Record";
colbtnGetSample.Caption = "Get " + iSamplePercent + "% sample";
colbtnQCProcessed.Caption = "Show Sampled Records";
//lView.Items[9].TextVisible = false;
lView.CardMinSize = new Size(60, 250);
gControl.DataSource = dtQCTable;
}
else
{
gControl.DataSource = null;
}
dgvQCList.BackgroundColor = GV.pnlGlobalColor.Style.BackColor2.Color;
}
}
public UISearchGroup(ucModule parentModule, LayoutControlGroup parentLayoutGroup)
{
ParentModule = parentModule;
ModuleInfo = parentModule.ModuleInfo;
ParentLayoutGroup = parentLayoutGroup;
SearchLayout = (LayoutControl)parentLayoutGroup.Owner;
Groups = new List <UISearchGroup>();
Conditions = new List <UISearchCondition>();
LayoutGroup = new LayoutControlGroup();
SearchLayout.BeginUpdate();
parentLayoutGroup.BeginUpdate();
m_EditUse = new CheckEdit();
// GetFields: ModID = ModuleTypeID, Group = SQL_EXPRESSION
var fieldSqlLogic =
FieldUtils.GetModuleFields(
ModuleInfo.ModuleType,
CODES.DEFMODFLD.FLDGROUP.SQL_EXPRESSION
)[0];
//
m_SQLLogic = (ImageComboBoxEdit)parentModule.CreateControl(fieldSqlLogic);
parentModule.SetControlListSource(m_SQLLogic);
parentModule.SetControlDefaultValue(m_SQLLogic);
m_AddGroup = new SimpleButton();
m_AddCondition = new SimpleButton();
m_DeleteGroup = new SimpleButton();
SearchLayout.Controls.AddRange(new Control[] { m_EditUse, m_SQLLogic, m_AddGroup, m_AddCondition, m_DeleteGroup });
(m_EditUseLayoutItem = LayoutGroup.AddItem("Use Condition", m_EditUse)).BeginInit();
(m_MainSeparator = (SimpleSeparator)LayoutGroup.AddItem(new SimpleSeparator(), m_EditUseLayoutItem, InsertType.Bottom)).BeginInit();
(m_SQLLogicLayoutItem = LayoutGroup.AddItem("Group Type", m_SQLLogic, m_EditUseLayoutItem, InsertType.Right)).BeginInit();
(m_SQLLogicEmptySpace = (EmptySpaceItem)LayoutGroup.AddItem(new EmptySpaceItem(LayoutGroup), m_SQLLogicLayoutItem, InsertType.Right)).BeginInit();
(m_DeleteGroupLayoutItem = LayoutGroup.AddItem("Delete Group", m_DeleteGroup, m_SQLLogicEmptySpace, InsertType.Right)).BeginInit();
(m_AddGroupLayoutItem = LayoutGroup.AddItem("Add Group", m_AddGroup, m_DeleteGroupLayoutItem, InsertType.Right)).BeginInit();
(m_AddConditionLayoutItem = LayoutGroup.AddItem("Add Condition", m_AddCondition, m_AddGroupLayoutItem, InsertType.Right)).BeginInit();
// m_chkEditUse
m_EditUse.Text = "";
m_EditUse.Checked = true;
m_EditUse.EditValueChanged += CheckEditUse_CheckedChanged;
// m_btnDeleteGroup
parentModule.Language.FormatButton(m_DeleteGroup, "btnDeleteGroupCondition");
m_DeleteGroup.Click += DeleteGroupCondition_Click;
// m_btnAddGroup
parentModule.Language.FormatButton(m_AddGroup, "btnAddGroupCondition");
m_AddGroup.Click += AddGroupCondition_Click;
// m_btnAddCondition
parentModule.Language.FormatButton(m_AddCondition, "btnAddCondition");
m_AddCondition.Click += AddConditionButton_Click;
// LayoutGroup
LayoutGroup.Padding = new DevExpress.XtraLayout.Utils.Padding(9, 2, 2, 2);
LayoutGroup.TextLocation = DevExpress.Utils.Locations.Left;
LayoutGroup.Text = " ";
// m_layout_chkEditUse
m_EditUseLayoutItem.TextVisible = false;
m_EditUseLayoutItem.SizeConstraintsType = SizeConstraintsType.Custom;
m_EditUseLayoutItem.ControlAlignment = ContentAlignment.MiddleCenter;
m_EditUseLayoutItem.FillControlToClientArea = false;
m_EditUseLayoutItem.MinSize =
m_EditUseLayoutItem.MaxSize = new Size(20, 24);
// m_layout_cboSQLLogic
m_SQLLogicLayoutItem.TextVisible = false;
m_SQLLogicLayoutItem.SizeConstraintsType = SizeConstraintsType.Custom;
m_SQLLogicLayoutItem.ControlAlignment = ContentAlignment.MiddleCenter;
m_EditUseLayoutItem.FillControlToClientArea = false;
m_SQLLogicLayoutItem.MinSize =
m_SQLLogicLayoutItem.MaxSize = new Size(240, 24);
// m_layout_btnDeleteGroup
m_DeleteGroupLayoutItem.TextVisible = false;
m_DeleteGroupLayoutItem.SizeConstraintsType = SizeConstraintsType.Custom;
m_DeleteGroupLayoutItem.ControlAlignment = ContentAlignment.MiddleCenter;
m_EditUseLayoutItem.FillControlToClientArea = false;
m_DeleteGroupLayoutItem.MinSize =
m_DeleteGroupLayoutItem.MaxSize = new Size(140, 24);
// m_layout_cboSQLLogic
m_AddGroupLayoutItem.TextVisible = false;
m_AddGroupLayoutItem.SizeConstraintsType = SizeConstraintsType.Custom;
m_AddGroupLayoutItem.ControlAlignment = ContentAlignment.MiddleCenter;
m_EditUseLayoutItem.FillControlToClientArea = false;
m_AddGroupLayoutItem.MinSize =
m_AddGroupLayoutItem.MaxSize = new Size(140, 24);
// m_layout_cboSQLLogic
m_AddConditionLayoutItem.TextVisible = false;
m_AddConditionLayoutItem.SizeConstraintsType = SizeConstraintsType.Custom;
m_AddConditionLayoutItem.ControlAlignment = ContentAlignment.MiddleCenter;
m_EditUseLayoutItem.FillControlToClientArea = false;
m_AddConditionLayoutItem.MinSize =
m_AddConditionLayoutItem.MaxSize = new Size(110, 24);
m_MainSeparator.FillControlToClientArea = false;
m_MainSeparator.SizeConstraintsType = SizeConstraintsType.Default;
m_EditUseLayoutItem.EndInit();
m_SQLLogicLayoutItem.EndInit();
m_SQLLogicEmptySpace.EndInit();
m_DeleteGroupLayoutItem.EndInit();
m_AddGroupLayoutItem.EndInit();
m_AddConditionLayoutItem.EndInit();
m_MainSeparator.EndInit();
parentLayoutGroup.Add(LayoutGroup);
if (ConditionModule.ConditionLayoutGroup == parentLayoutGroup)
{
parentLayoutGroup.AddItem(new EmptySpaceItem(), LayoutGroup, InsertType.Bottom);
m_DeleteGroupLayoutItem.Visibility = LayoutVisibility.Never;
}
parentLayoutGroup.EndUpdate();
SearchLayout.EndUpdate();
}
