private void SetInfoTransactionPrivateCopy()
{
transPrivateCopy = new InfoTransaction();
// transPrivateCopy.Timing = transaction.Timing;
foreach (Transaction trans in transaction.Transactions)
{
Transaction t = new Transaction();
t.AutoNumber = trans.AutoNumber;
t.Name = trans.Name;
foreach (TransField field in trans.TransFields)
{
TransField tf = new TransField();
tf.DesField = field.DesField;
tf.DesValue = field.DesValue;
tf.FieldType = field.FieldType;
tf.SrcField = field.SrcField;
tf.SrcGetValue = field.SrcGetValue;
tf.SrcValue = field.SrcValue;
tf.UpdateMode = field.UpdateMode;
t.TransFields.Add(tf);
}
foreach (TransKeyField keyField in trans.TransKeyFields)
{
TransKeyField tkf = new TransKeyField();
tkf.DesField = keyField.DesField;
tkf.FieldType = keyField.FieldType;
tkf.SrcField = keyField.SrcField;
tkf.SrcGetValue = keyField.SrcGetValue;
tkf.SrcValue = keyField.SrcValue;
tkf.WhereMode = keyField.WhereMode;
t.TransKeyFields.Add(tkf);
}
t.TransMode = trans.TransMode;
t.TransStep = trans.TransStep;
t.TransTableName = trans.TransTableName;
t.WhenDelete = trans.WhenDelete;
t.WhenInsert = trans.WhenInsert;
t.WhenUpdate = trans.WhenUpdate;
transPrivateCopy.Transactions.Add(t);
}
transPrivateCopy.UpdateComp = transaction.UpdateComp;
}
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;
}
}
}
}
private void SetTransactionPrivateCopy()
{
transPrivateCopy = new Transaction();
foreach (TransField field in transaction.TransFields)
{
TransField tf = new TransField();
tf.DesField = field.DesField;
tf.DesValue = field.DesValue;
tf.FieldType = field.FieldType;
tf.SrcField = field.SrcField;
tf.SrcGetValue = field.SrcGetValue;
tf.SrcValue = field.SrcValue;
tf.UpdateMode = field.UpdateMode;
transPrivateCopy.TransFields.Add(tf);
}
}
private void SetTransactionPrivateCopy()
{
transPrivateCopy = new Transaction();
transPrivateCopy.AutoNumber = transaction.AutoNumber;
transPrivateCopy.Name = transaction.Name;
foreach (TransField field in transaction.TransFields)
{
TransField tf = new TransField();
tf.DesField = field.DesField;
tf.DesValue = field.DesValue;
tf.FieldType = field.FieldType;
tf.SrcField = field.SrcField;
tf.SrcGetValue = field.SrcGetValue;
tf.SrcValue = field.SrcValue;
tf.UpdateMode = field.UpdateMode;
transPrivateCopy.TransFields.Add(tf);
}
foreach (TransKeyField keyField in transaction.TransKeyFields)
{
TransKeyField tkf = new TransKeyField();
tkf.DesField = keyField.DesField;
tkf.FieldType = keyField.FieldType;
tkf.SrcField = keyField.SrcField;
tkf.SrcGetValue = keyField.SrcGetValue;
tkf.SrcValue = keyField.SrcValue;
tkf.WhereMode = keyField.WhereMode;
transPrivateCopy.TransKeyFields.Add(tkf);
}
transPrivateCopy.TransMode = transaction.TransMode;
transPrivateCopy.TransStep = transaction.TransStep;
transPrivateCopy.TransTableName = transaction.TransTableName;
//new add by ccm
transPrivateCopy.WhenInsert = transaction.WhenInsert;
transPrivateCopy.WhenUpdate = transaction.WhenUpdate;
transPrivateCopy.WhenDelete = transaction.WhenDelete;
}