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;
}
