private void SetValue_D() { if (FSelectedBlockFieldItem_D == null) return; FSelectedBlockFieldItem_D.Description = tbCaption_D.Text; FSelectedBlockFieldItem_D.CheckNull = cbCheckNull_D.Text; FSelectedBlockFieldItem_D.DefaultValue = tbDefaultValue_D.Text; FSelectedBlockFieldItem_D.ControlType = cbControlType_D.Text; FSelectedBlockFieldItem_D.ComboRemoteName = tbComboRemoteName_D.Text; FSelectedBlockFieldItem_D.ComboEntityName = tbComboEntityName_D.Text; FSelectedBlockFieldItem_D.ComboTextField = cbComboDisplayField_D.Text; FSelectedBlockFieldItem_D.ComboValueField = cbComboValueField_D.Text; if (!String.IsNullOrEmpty(tbComboRemoteName_D.Text) && tbComboRemoteName_D.Text.Contains(".")) { if (radioButtonEntity.Checked) { String[] combo_DRemoteNames = tbComboRemoteName_D.Text.Split(new char[] { '.' }, StringSplitOptions.RemoveEmptyEntries); List<COLDEFInfo> colDefObjects = WzdUtils.GetColumnDefination(combo_DRemoteNames[0], combo_DRemoteNames[1], this.tbComboEntityName_D.Text, cbEEPAlias.Text); if (colDefObjects != null) { COLDEFInfo colDefObject = colDefObjects.Find(c => c.FIELD_NAME == cbComboDisplayField_D.Text); if (colDefObject != null) FSelectedBlockFieldItem_D.ComboTextFieldCaption = colDefObject.CAPTION; colDefObject = colDefObjects.Find(c => c.FIELD_NAME == cbComboValueField_D.Text); if (colDefObject != null) FSelectedBlockFieldItem_D.ComboValueFieldCaption = colDefObject.CAPTION; } if (tbOtherFields_D.Text != null) { String[] otherFields = tbOtherFields_D.Text.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries); FSelectedBlockFieldItem_D.ComboOtherFields = new List<OtherField>(); foreach (String item in otherFields) { if (item != FSelectedBlockFieldItem_D.ComboTextField && item != FSelectedBlockFieldItem_D.ComboValueField) { OtherField of = new OtherField(); of.FieldName = item; if (colDefObjects != null) { COLDEFInfo colDefObject = colDefObjects.Find(c => c.FIELD_NAME == item); if (colDefObject != null) of.FieldCaption = colDefObject.CAPTION; } FSelectedBlockFieldItem_D.ComboOtherFields.Add(of); } } } SYS_REFVAL aSYS_REFVAL = new SYS_REFVAL(); aSYS_REFVAL.REFVAL_NO = "SL." + FSelectedBlockFieldItem_D.ComboEntityName; aSYS_REFVAL.TABLE_NAME = FSelectedBlockFieldItem_D.ComboEntityName; aSYS_REFVAL.SELECT_ALIAS = FSelectedBlockFieldItem_D.ComboRemoteName; aSYS_REFVAL.DISPLAY_MEMBER = FSelectedBlockFieldItem_D.ComboTextField; aSYS_REFVAL.VALUE_MEMBER = FSelectedBlockFieldItem_D.ComboValueField; if (FSelectedBlockFieldItem_D.ComboOtherFields != null) { foreach (OtherField of in FSelectedBlockFieldItem_D.ComboOtherFields) { aSYS_REFVAL.SELECT_COMMAND += of.FieldName + ";"; } } List<object> lParams = new List<object>(); lParams.Add(aSYS_REFVAL); WzdUtils.SaveDataToTable(lParams, "SYS_REFVAL"); } else if (radioButtonInfoCommand.Checked) { DataSet dsCOLDEF = GetDataFromCOLDEF(tbComboEntityName_D.Text); if (dsCOLDEF.Tables.Count > 0 && dsCOLDEF.Tables[0].Rows.Count > 0) { DataRow[] drsDisplay = dsCOLDEF.Tables[0].Select(String.Format("FIELD_NAME='{0}'", cbComboDisplayField_D.Text)); if (drsDisplay.Count() > 0) FSelectedBlockFieldItem_D.ComboTextFieldCaption = drsDisplay[0]["CAPTION"].ToString(); DataRow[] drsValue = dsCOLDEF.Tables[0].Select(String.Format("FIELD_NAME='{0}'", cbComboDisplayField_D.Text)); if (drsValue != null) FSelectedBlockFieldItem_D.ComboValueFieldCaption = drsValue[0]["CAPTION"].ToString(); } if (tbOtherFields_D.Text != null) { String[] otherFields = tbOtherFields_D.Text.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries); FSelectedBlockFieldItem_D.ComboOtherFields = new List<OtherField>(); foreach (String item in otherFields) { if (item != FSelectedBlockFieldItem_D.ComboTextField && item != FSelectedBlockFieldItem_D.ComboValueField) { OtherField of = new OtherField(); of.FieldName = item; if (dsCOLDEF.Tables.Count > 0 && dsCOLDEF.Tables[0].Rows.Count > 0) { DataRow[] drs = dsCOLDEF.Tables[0].Select(String.Format("FIELD_NAME='{0}'", item)); if (drs.Count() > 0) of.FieldCaption = drs[0]["CAPTION"].ToString(); } FSelectedBlockFieldItem_D.ComboOtherFields.Add(of); } } } else { } String selectCommand = String.Empty; if (FSelectedBlockFieldItem_D.ComboOtherFields != null) { foreach (OtherField of in FSelectedBlockFieldItem_D.ComboOtherFields) { selectCommand += of.FieldName + ";"; } } SetDataToSYS_REFVAL(FSelectedBlockFieldItem_D.ComboEntityName, FSelectedBlockFieldItem_D.ComboTextField, FSelectedBlockFieldItem_D.ComboValueField, FSelectedBlockFieldItem_D.ComboRemoteName, selectCommand); } } FSelectedBlockFieldItem_D.QueryMode = cbQueryMode_D.Text; FSelectedBlockFieldItem_D.EditMask = tbEditMask_D.Text; //FSelectedListViewItem.SubItems[1].Text = FSelectedBlockFieldItem.Description; //FSelectedListViewItem.SubItems[2].Text = FSelectedBlockFieldItem.CheckNull; //FSelectedListViewItem.SubItems[3].Text = FSelectedBlockFieldItem.DefaultValue; //FSelectedListViewItem.SubItems[4].Text = FSelectedBlockFieldItem.RefValNo; //FSelectedListViewItem.SubItems[5].Text = FSelectedBlockFieldItem.QueryMode; //FSelectedListViewItem.SubItems[6].Text = FSelectedBlockFieldItem.EditMask; }
private void SetValue_D() { if (FSelectedBlockFieldItem_D == null) return; FSelectedBlockFieldItem_D.Description = tbCaption_D.Text; FSelectedBlockFieldItem_D.CheckNull = cbCheckNull_D.Text; FSelectedBlockFieldItem_D.DefaultValue = tbDefaultValue_D.Text; FSelectedBlockFieldItem_D.ControlType = cbControlType_D.Text; FSelectedBlockFieldItem_D.ComboRemoteName = tbComboRemoteName_D.Text; FSelectedBlockFieldItem_D.ComboEntityName = tbComboEntityName_D.Text; FSelectedBlockFieldItem_D.ComboEntitySetName = tbComboEntitySetName_D.Text; FSelectedBlockFieldItem_D.ComboTextField = cbComboDisplayField_D.Text; FSelectedBlockFieldItem_D.ComboValueField = cbComboValueField_D.Text; FSelectedBlockFieldItem_D.QueryMode = cbQueryMode_D.Text; FSelectedBlockFieldItem_D.EditMask = tbEditMask_D.Text; if (FSelectedBlockFieldItem_D.ControlType == "ComboBox") { String[] comboAssembly = FSelectedBlockFieldItem_D.ComboRemoteName.Split('.'); List<COLDEFInfo> colDefObjects = null; colDefObjects = WzdUtils.GetColumnDefination(comboAssembly[0], comboAssembly[1], FSelectedBlockFieldItem_D.ComboEntitySetName, cbEEPAlias.Text); COLDEFInfo colDefObject = null; if (colDefObjects != null) { colDefObject = colDefObjects.Find(c => c.FIELD_NAME == FSelectedBlockFieldItem_D.ComboTextField); if (colDefObject != null) FSelectedBlockFieldItem_D.ComboTextFieldCaption = colDefObject.CAPTION; colDefObject = colDefObjects.Find(c => c.FIELD_NAME == FSelectedBlockFieldItem_D.ComboValueField); if (colDefObject != null) FSelectedBlockFieldItem_D.ComboValueFieldCaption = colDefObject.CAPTION; } SYS_REFVAL aSYS_REFVAL = new SYS_REFVAL(); aSYS_REFVAL.REFVAL_NO = "Auto." + FSelectedBlockFieldItem_D.ComboEntityName; aSYS_REFVAL.TABLE_NAME = FSelectedBlockFieldItem_D.ComboEntityName; aSYS_REFVAL.SELECT_ALIAS = FSelectedBlockFieldItem_D.ComboRemoteName; aSYS_REFVAL.DISPLAY_MEMBER = FSelectedBlockFieldItem_D.ComboTextField; aSYS_REFVAL.VALUE_MEMBER = FSelectedBlockFieldItem_D.ComboValueField; //foreach (OtherField of in FSelectedBlockFieldItem_D.ComboOtherFields) //{ // aSYS_REFVAL.SELECT_COMMAND += of.FieldName + ";"; //} List<object> lParams = new List<object>(); lParams.Add(aSYS_REFVAL); WzdUtils.SaveDataToTable(lParams, "SYS_REFVAL"); } //FSelectedListViewItem.SubItems[1].Text = FSelectedBlockFieldItem.Description; //FSelectedListViewItem.SubItems[2].Text = FSelectedBlockFieldItem.CheckNull; //FSelectedListViewItem.SubItems[3].Text = FSelectedBlockFieldItem.DefaultValue; //FSelectedListViewItem.SubItems[4].Text = FSelectedBlockFieldItem.RefValNo; //FSelectedListViewItem.SubItems[5].Text = FSelectedBlockFieldItem.QueryMode; //FSelectedListViewItem.SubItems[6].Text = FSelectedBlockFieldItem.EditMask; }