private void btnAdd_Click(object sender, EventArgs e)
{
List<string> lstSrcColumn = new List<string>();
List<string> lstDesColumn = new List<string>();
InfoTransactionTransFieldsAddDialog ittfad = new InfoTransactionTransFieldsAddDialog();
if (strSrcTable != string.Empty && _conn != null)
{
if (uctran != null && uctran.SelectCmd != null)
{
ittfad.cmbSrcField.Items.AddRange(uctran.SelectCmd.GetFields());
}
}
if (strDesTable != string.Empty && _conn != null)
{
try
{
lstDesColumn = AddColumn(strDesTable);
}
catch(Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
foreach (string strColumn in lstDesColumn)
{
ittfad.cmbDesField.Items.Add(strColumn);
}
}
ittfad.cbxUpdateMode.Items.Add("Dec");
ittfad.cbxUpdateMode.Items.Add("Disable");
ittfad.cbxUpdateMode.Items.Add("Inc");
ittfad.cbxUpdateMode.Items.Add("Replace");
ittfad.cbxUpdateMode.Items.Add("WriteBack");
ittfad.cbxUpdateMode.SelectedIndex = 3;
if (ittfad.ShowDialog() == DialogResult.OK)
{
TransField tf = new TransField();
tf.DesField = ittfad.cmbDesField.Text;
tf.SrcField = ittfad.cmbSrcField.Text;
tf.SrcGetValue = ittfad.txtSrcGetValue.Text;
switch (ittfad.cbxUpdateMode.SelectedIndex)
{
case 0:
tf.UpdateMode = UpdateMode.Dec;
break;
case 1:
tf.UpdateMode = UpdateMode.Disable;
break;
case 2:
tf.UpdateMode = UpdateMode.Inc;
break;
case 3:
tf.UpdateMode = UpdateMode.Replace;
break;
case 4:
tf.UpdateMode = UpdateMode.WriteBack;
break;
}
this.transPrivateCopy.TransFields.Add(tf);
this.lbDesField.Items.Add(tf.DesField);
this.lbScrField.Items.Add(tf.SrcField);
switch (tf.UpdateMode)
{
case UpdateMode.Dec:
this.lbRelation.Items.Add(tf.DesField + " - " + tf.SrcField);
break;
case UpdateMode.Disable:
this.lbRelation.Items.Add(tf.DesField + " X " + tf.SrcField);
break;
case UpdateMode.Inc:
this.lbRelation.Items.Add(tf.DesField + " + " + tf.SrcField);
break;
case UpdateMode.Replace:
this.lbRelation.Items.Add(tf.DesField + " = " + tf.SrcField);
break;
case UpdateMode.WriteBack:
this.lbRelation.Items.Add(tf.DesField + " <- " + tf.SrcField);
break;
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
int selindex = this.lbRelation.SelectedIndex;
List<string> lstSrcColumn = new List<string>();
List<string> lstDesColumn = new List<string>();
if (selindex != -1)
{
InfoTransactionTransFieldsAddDialog ittfad = new InfoTransactionTransFieldsAddDialog();
if (strSrcTable != string.Empty && _conn != null)
{
if (uctran != null && uctran.SelectCmd != null)
{
ittfad.cmbSrcField.Items.AddRange(uctran.SelectCmd.GetFields());
}
}
if (strDesTable != string.Empty && _conn != null)
{
try
{
lstDesColumn = AddColumn(strDesTable);
}
catch
{
MessageBox.Show(string.Format("Transtable :{0} \ndoesn't exist", strDesTable));
return;
}
foreach (string strColumn in lstDesColumn)
{
ittfad.cmbDesField.Items.Add(strColumn);
}
}
ittfad.cbxUpdateMode.Items.Add("Dec");
ittfad.cbxUpdateMode.Items.Add("Disable");
ittfad.cbxUpdateMode.Items.Add("Inc");
ittfad.cbxUpdateMode.Items.Add("Replace");
ittfad.cbxUpdateMode.Items.Add("WriteBack");
ittfad.cmbDesField.Text = this.lbDesField.Items[selindex].ToString();
ittfad.cmbSrcField.Text = this.lbScrField.Items[selindex].ToString();
ittfad.txtSrcGetValue.Text = this.txtSrcGetValue.Text;
switch (((TransField)this.transPrivateCopy.TransFields[selindex]).UpdateMode)
{
case UpdateMode.Dec:
ittfad.cbxUpdateMode.SelectedIndex = 0;
break;
case UpdateMode.Disable:
ittfad.cbxUpdateMode.SelectedIndex = 1;
break;
case UpdateMode.Inc:
ittfad.cbxUpdateMode.SelectedIndex = 2;
break;
case UpdateMode.Replace:
ittfad.cbxUpdateMode.SelectedIndex = 3;
break;
case UpdateMode.WriteBack:
ittfad.cbxUpdateMode.SelectedIndex = 4;
break;
}
if (ittfad.ShowDialog() == DialogResult.OK)
{
TransField tf = new TransField();
tf.DesField = ittfad.cmbDesField.Text;
tf.SrcField = ittfad.cmbSrcField.Text;
tf.SrcGetValue = ittfad.txtSrcGetValue.Text;
switch (ittfad.cbxUpdateMode.SelectedIndex)
{
case 0:
tf.UpdateMode = UpdateMode.Dec;
break;
case 1:
tf.UpdateMode = UpdateMode.Disable;
break;
case 2:
tf.UpdateMode = UpdateMode.Inc;
break;
case 3:
tf.UpdateMode = UpdateMode.Replace;
break;
case 4:
tf.UpdateMode = UpdateMode.WriteBack;
break;
}
this.transPrivateCopy.TransFields[selindex] = tf;
this.lbDesField.Items[selindex] = tf.DesField;
this.lbScrField.Items[selindex] = tf.SrcField;
switch (tf.UpdateMode)
{
case UpdateMode.Dec:
this.lbRelation.Items[selindex] = tf.DesField + " - " + tf.SrcField;
break;
case UpdateMode.Disable:
this.lbRelation.Items[selindex] = tf.DesField + " X " + tf.SrcField;
break;
case UpdateMode.Inc:
this.lbRelation.Items[selindex] = tf.DesField + " + " + tf.SrcField;
break;
case UpdateMode.Replace:
this.lbRelation.Items[selindex] = tf.DesField + " = " + tf.SrcField;
break;
case UpdateMode.WriteBack:
this.lbRelation.Items[selindex] = tf.DesField + " <- " + tf.SrcField;
break;
}
}
}
}