private static bool FindBillDoc(NICSQLTools.Data.dsData.QryBillDocDataTable tbl, string BillDoc)
{
if (tbl.FindByBilling_Document(BillDoc) != null)
return true;
else
return false;
}
public ImportCustomerSSInfoUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
tbLog.Text = RequiredField;
_elementRule = RuleElement;
}
public static void LoadDefaultNodes(DevExpress.XtraTreeList.TreeList Tree, NICSQLTools.Views.Main.MainTilesFrm MainFrm)
{
Tree.Nodes.Clear();
//NICSQLTools.Forms.Main.MainTilesFrm MainFrm = (NICSQLTools.Forms.Main.MainTilesFrm)Parent.Parent.Parent;
Tree.BeginUnboundLoad();
// Create a root node .
TreeListNode RootNode = Tree.AppendNode(new object[] { "Main", false, false, false, false, "Main" }, 0); ;
//TreeListNode RootEditorNode = Tree.AppendNode(new object[] { "Editors", false, false, false, false }, RootNode);
//TreeListNode RootQueriesNode = Tree.AppendNode(new object[] { "Queries", false, false, false, false }, RootNode);
//TreeListNode RootRulesNode = Tree.AppendNode(new object[] { "Rules", false, false, false, false }, RootNode);
//TreeListNode RootReportsNode = Tree.AppendNode(new object[] { "Reports", false, false, false, false }, RootNode);
//TreeListNode RootDashBoardNode = Tree.AppendNode(new object[] { "DashBoard", false, false, false, false }, RootNode);
ExtractTilesFromTileContainer(MainFrm.tileContainerMain, RootNode);
////RootEditorNode.Tag = "root"; RootQueriesNode.Tag = "root"; RootRulesNode.Tag = "root"; RootReportsNode.Tag = "root"; RootDashBoardNode.Tag = "root";
//foreach (DevExpress.XtraBars.Docking2010.Views.WindowsUI.Tile tile in MainFrm.tileContainerEditors.Items)
// Tree.AppendNode(new object[] { tile.Document.Caption, false, false, false, false, tile.Document.ControlName }, RootEditorNode);
//foreach (DevExpress.XtraBars.Docking2010.Views.WindowsUI.Tile tile in MainFrm.tileContainerQueries.Items)
// Tree.AppendNode(new object[] { tile.Document.Caption, false, false, false, false, tile.Document.ControlName }, RootQueriesNode);
//foreach (DevExpress.XtraBars.Docking2010.Views.WindowsUI.Tile tile in MainFrm.tileContainerRules.Items)
// Tree.AppendNode(new object[] { tile.Document.Caption, false, false, false, false, tile.Document.ControlName }, RootRulesNode);
//foreach (DevExpress.XtraBars.Docking2010.Views.WindowsUI.Tile tile in MainFrm.tileContainerReports.Items)
// Tree.AppendNode(new object[] { tile.Document.Caption, false, false, false, false, tile.Document.ControlName }, RootReportsNode);
//foreach (DevExpress.XtraBars.Docking2010.Views.WindowsUI.Tile tile in MainFrm.tileContainerDashboard.Items)
// Tree.AppendNode(new object[] { tile.Document.Caption, false, false, false, false, tile.Document.ControlName }, RootDashBoardNode);
Tree.EndUnboundLoad();
}
public TSrv_TruckServiceEditorUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
_elementRule = RuleElement;
Classes.Managers.DataManager.SetAllCommandTimeouts(tSrv_TruckServiceTableAdapter, Classes.Managers.DataManager.ConnectionTimeout);
Classes.Managers.DataManager.SetAllCommandTimeouts(vRouteDetailsTableAdapter, Classes.Managers.DataManager.ConnectionTimeout);
}
public ImportUpdateProductDetailsUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
tbLogPP.Text = RequiredFieldPP;
//DataManager.SetAllCommandTimeouts(customerInfoTableAdapter, DataManager.ConnectionTimeout);
_elementRule = RuleElement;
}
public MSrvTicketVisitAddDlg(NICSQLTools.Data.dsData.AppRuleDetailRow ruleElement, int ticketId)
{
InitializeComponent();
LoadDefaultData();
_elementRule = ruleElement;
lueTicket.EditValue = ticketId;
lueTicket.RefreshEditValue();
_closeAfterSave = true;
}
public ImportStock_MaterialUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
tbLog.Text = RequiredField;
DataManager.SetAllCommandTimeouts(stock_MaterialTableAdapter, DataManager.ConnectionTimeout);
tbMonth.EditValue = DataManager.defaultInstance.ServerDateTime.Month;
tbYear.EditValue = DataManager.defaultInstance.ServerDateTime.Year;
_elementRule = RuleElement;
}
public QryPivotUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
_elementRule = RuleElement;
layoutControlItemLoadLayout.Control.Enabled = false;
layoutControlItemSave.Control.Enabled = false;
layoutControlItemSaveAs.Control.Enabled = false;
layoutControlItemLoad.Control.Enabled = false;
layoutControlItemDelete.Control.Enabled = false;
}
public ImportDaysUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
tbLog.Text = RequiredField;
DataManager.SetAllCommandTimeouts(_0_4__Product_DetailsTableAdapter, DataManager.ConnectionTimeout);
DataManager.SetAllCommandTimeouts(_0_3__Route_DetailsTableAdapter, DataManager.ConnectionTimeout);
DataManager.SetAllCommandTimeouts(_0_6_Customer_HNTableAdapter, DataManager.ConnectionTimeout);
DataManager.SetAllCommandTimeouts(qryBillDocTableAdapter, DataManager.ConnectionTimeout);
_elementRule = RuleElement;
}
public CostControlEditorUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
_elementRule = RuleElement;
tbLogDF.Text = RequiredFieldDF;
tbLogActual.Text = RequiredFieldActual;
tbPeriodDF.EditValue = (DataManager.defaultInstance.ServerDateTime.Month - 1) / 3 + 1;
tbYearDF.EditValue = DataManager.defaultInstance.ServerDateTime.Year;
ActivateRules();
}
public MSrv_TicketVisitEditDlg(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement, NICSQLTools.Data.Linq.vMSrv_TicketVisit Visit)
{
InitializeComponent();
_elementRule = RuleElement;
LSMSTechnicianId.QueryableSource = from q in dsLinq.vMSrv_Technician_ByUsers where q.UserId == Classes.Managers.UserManager.defaultInstance.User.UserId select q;
LSMSPartId.QueryableSource = from q in dsLinq.MSrv_Parts select q;
LSMSDmg.QueryableSource = from q in dsLinq.MSrv_Dmg_Reasons select q;
_visit = Visit;
lueTicket.EditValue = Visit.TicketId; lueTicket.Enabled = false;
layoutControlGroupTicket.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
mSrv_TypeTableAdapter.FillByMSrv_TypeConditionId(dsMSrc.MSrv_Type, (int)Classes.MSrvType.TypeCondition.Open_Ticket);
adp.FillByID(dsMSrc.MSrv_TicketVisit, _visit.TicketVisitId);//Load Visit
mSrv_TicketVisitPartTableAdapter.FillByTicketVisitId(dsMSrc.MSrv_TicketVisitPart, _visit.TicketVisitId);// Load Parts
adpTicketVisitType.FillByTicketVisitId(dsMSrc.MSrv_TicketVisitType, _visit.TicketVisitId);// Load Types
}
public RDM_ReceiptEditDlg(NICSQLTools.Data.Linq.vRDM_Receipt_ByUser row)
{
InitializeComponent();
_row = row;
tbReceiptNo.EditValue = _row.ReceiptNo;
deRDM_Date.EditValue = _row.RDM_Date;
lueRouteNumber.EditValue = _row.RouteNumber;
lueRDM_Promo_Type_Id.EditValue = _row.RDM_Promo_Type_Id;
lueBaseProductId.EditValue = _row.BaseProductId;
tbQun.EditValue = _row.Qun;
if (_row.RDM_Description != null)
tbOpenComment.EditValue = _row.RDM_Description;
LSMSRoute.QueryableSource = from q in dsLinq.vRDM_Route_ByUsers where q.UserId == Classes.Managers.UserManager.defaultInstance.User.UserId select q;
LSMSRDM_Promo_Type.QueryableSource = from q in dsLinq.MSrv_Types where q.MSrv_TypeConditionId == (int)Classes.MSrvType.TypeCondition.Open_Ticket select q;
LSMSBaseProductId.QueryableSource = from q in dsLinq.PRD_BaseProducts select q;
}
private Control CreateDSElement(NICSQLTools.Data.dsDataSource.AppDatasourceParamRow ParamRow, string ParamType)
{
object ctr = null;
if (!ParamRow.IsLookupIDNull())
{
ctr = CreateLookupedit(ParamRow.LookupID);
}
else
{
switch (ParamType.ToLower())
{
case "nvarchar":
TextEdit txt1 = new TextEdit();
txt1.Name = String.Format("ctr{0}{1}{2}", ParamRow.ParamName, ParamRow.AppDatasourceParamID, ParamRow.DatasourceID);
ctr = txt1;
break;
case "int":
case "smallint":
case "bigint":
TextEdit txt2 = new TextEdit();
txt2.Name = String.Format("ctr{0}{1}{2}", ParamRow.ParamName, ParamRow.AppDatasourceParamID, ParamRow.DatasourceID);
txt2.Properties.DisplayFormat.FormatString = "n0";
txt2.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
txt2.Properties.EditFormat.FormatString = "n0";
txt2.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
txt2.Properties.Mask.EditMask = "n0";
txt2.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
ctr = txt2;
break;
case "float":
TextEdit txt3 = new TextEdit();
txt3.Name = String.Format("ctr{0}{1}{2}", ParamRow.ParamName, ParamRow.AppDatasourceParamID, ParamRow.DatasourceID);
txt3.Properties.DisplayFormat.FormatString = "f2";
txt3.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
txt3.Properties.EditFormat.FormatString = "f2";
txt3.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
txt3.Properties.Mask.EditMask = "f2";
txt3.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
ctr = txt3;
break;
case "datetime":
DateEdit de1 = new DateEdit();
de1.EditValue = null;
de1.Name = String.Format("ctr{0}{1}{2}", ParamRow.ParamName, ParamRow.AppDatasourceParamID, ParamRow.DatasourceID);
de1.Properties.DisplayFormat.FormatString = "yyyy-MM-dd";
de1.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
de1.Properties.EditFormat.FormatString = "yyyy-MM-dd";
de1.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
de1.Properties.Mask.EditMask = "yyyy-MM-dd";
de1.RightToLeft = System.Windows.Forms.RightToLeft.Yes;
ctr = de1;
break;
default:
break;
}
}
((TextEdit)ctr).Properties.NullValuePrompt = ParamRow.ParamDisplayName;
return (Control)ctr;
}
public AppDatasourceEditorUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
_elementRule = RuleElement;
Frm = new rtfTextEditorFrm(string.Empty);
}
public DatasourceOpenDlg(NICSQLTools.Uti.Types.AppDatasourceTypeIdEnum Type)
{
InitializeComponent();
DatasourceType = Type;
}
public MSrvTicketVisitAddDlg(NICSQLTools.Data.dsData.AppRuleDetailRow ruleElement)
{
InitializeComponent();
_elementRule = ruleElement;
}
public RuleDetailsUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
_elementRule = RuleElement;
}
public MSrv_PartEditorUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
_elementRule = RuleElement;
_parts = (int)adpPart.NewId();
}
public RDM_ReceiptEditorUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
_elementRule = RuleElement;
}
public MSrv_TechnicianEditorUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
_elementRule = RuleElement;
}
public TSrv_RouteTypeEditorUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
_elementRule = RuleElement;
}
private Control CreateDSElement(NICSQLTools.Data.dsDataSource.AppDatasourceParamRow ParamRow, string ParamType)
{
object ctr = null;
switch (ParamRow.ParamName)
{
case "@SalesDistrict2":
ctr = CreateLookupeditForSalesDistrict2();
break;
case "@Materials":
ctr = CreateLookupeditForMaterial();
break;
case "@Base_Product":
ctr = CreateLookupeditForBaseProduct();
break;
case "@Base_Group":
ctr = CreateLookupeditForBaseGroup();
break;
default:// if param have not datasource
switch (ParamType.ToLower())
{
case "nvarchar":
TextEdit txt1 = new TextEdit();
txt1.Name = String.Format("ctr{0}{1}{2}", ParamRow.ParamName, ParamRow.AppDatasourceParamID, ParamRow.DatasourceID);
ctr = txt1;
break;
case "int":
case "smallint":
case "bigint":
TextEdit txt2 = new TextEdit();
txt2.Name = String.Format("ctr{0}{1}{2}", ParamRow.ParamName, ParamRow.AppDatasourceParamID, ParamRow.DatasourceID);
txt2.Properties.DisplayFormat.FormatString = "n0";
txt2.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
txt2.Properties.EditFormat.FormatString = "n0";
txt2.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
txt2.Properties.Mask.EditMask = "n0";
txt2.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
ctr = txt2;
break;
case "float":
TextEdit txt3 = new TextEdit();
txt3.Name = String.Format("ctr{0}{1}{2}", ParamRow.ParamName, ParamRow.AppDatasourceParamID, ParamRow.DatasourceID);
txt3.Properties.DisplayFormat.FormatString = "f2";
txt3.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
txt3.Properties.EditFormat.FormatString = "f2";
txt3.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
txt3.Properties.Mask.EditMask = "f2";
txt3.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
ctr = txt3;
break;
case "datetime":
DateEdit de1 = new DateEdit();
de1.EditValue = null;
de1.Name = String.Format("ctr{0}{1}{2}", ParamRow.ParamName, ParamRow.AppDatasourceParamID, ParamRow.DatasourceID);
de1.Properties.DisplayFormat.FormatString = "d/M/yyyy";
de1.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
de1.Properties.EditFormat.FormatString = "d/M/yyyy";
de1.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
de1.Properties.Mask.EditMask = "d/M/yyyy";
de1.RightToLeft = System.Windows.Forms.RightToLeft.Yes;
ctr = de1;
break;
default:
break;
}
break;
}
((TextEdit)ctr).Properties.NullValuePrompt = ParamRow.ParamDisplayName;
return (Control)ctr;
}
private void LoadCustomerCodes(ref NICSQLTools.Data.dsData ds)
{
SqlConnection con = new SqlConnection(Properties.Settings.Default.IC_DBConnectionString);
SqlCommand cmd = new SqlCommand("SELECT Customer_T FROM [0-6 Customer HN]", con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
NICSQLTools.Data.dsData._0_6_Customer_HNRow row = ds._0_6_Customer_HN.New_0_6_Customer_HNRow();
row.Customer_T = dr.GetValue(0).ToString();
ds._0_6_Customer_HN.Add_0_6_Customer_HNRow(row);
}
dr.Close();
cmd.Dispose();
con.Close(); con.Dispose();
}
public AppDatasourceParamUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
_elementRule = RuleElement;
}
private void LoadProductCodes(ref NICSQLTools.Data.dsData ds)
{
SqlConnection con = new SqlConnection(Properties.Settings.Default.IC_DBConnectionString);
SqlCommand cmd = new SqlCommand("SELECT [Material Number], Quin FROM [0-4 Product Details]", con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
NICSQLTools.Data.dsData._0_4__Product_DetailsRow row = ds._0_4__Product_Details.New_0_4__Product_DetailsRow();
row.Material_Number = dr.GetDouble(0);
row.Quin = dr.GetDouble(1);
ds._0_4__Product_Details.Add_0_4__Product_DetailsRow(row);
}
dr.Close();
cmd.Dispose();
con.Close(); con.Dispose();
}
public ImportEst_Actual_R3UC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
tbLog.Text = RequiredField;
_elementRule = RuleElement;
}
private void LoadRouteCodes(ref NICSQLTools.Data.dsData ds)
{
SqlConnection con = new SqlConnection(Properties.Settings.Default.IC_DBConnectionString);
SqlCommand cmd = new SqlCommand("SELECT [Route Number] FROM [0-3 Route Details]", con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
NICSQLTools.Data.dsData._0_3__Route_DetailsRow row = ds._0_3__Route_Details.New_0_3__Route_DetailsRow();
row.Route_Number = dr.GetValue(0).ToString();
ds._0_3__Route_Details.Add_0_3__Route_DetailsRow(row);
}
dr.Close();
cmd.Dispose();
con.Close(); con.Dispose();
}
public TaskFactorEditorUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
_elementRule = RuleElement;
}
public DashboardDesignerUC(NICSQLTools.Data.dsData.AppRuleDetailRow RuleElement)
{
InitializeComponent();
_elementRule = RuleElement;
}
