Exemple #1
0
 public static void FromTextControls(AutoCompleteTextBox[] textBoxes,string[] textFieldNames,EMDataRow row)
 {
     for (int i=0;i<textBoxes.Length;i++)
     {
         // Don't apply an empty string over a null field
         if (row.IsNull(textFieldNames[i]) && textBoxes[i].Text.Length == 0)
             continue;
         row[textFieldNames[i]] = textBoxes[i].Text;
     }
 }
Exemple #2
0
 public static void FromDateControls(AutoCompleteTextBox[] dateBoxes,string[]dateFieldNames,EMDataRow row)
 {
     for (int i=0;i<dateBoxes.Length;i++)
     {
         if (dateBoxes[i].Text == "")
         {
             row[dateFieldNames[i]] = DBNull.Value;
         }
         else
         {
             row[dateFieldNames[i]] = dateBoxes[i].Text;
         }
     }
 }
Exemple #3
0
 public static void UpdateTextControls(AutoCompleteTextBox[] textBoxes,string[] textFieldNames,EMDataRow row,
     bool isEmptyTable)
 {
     for (int i=0;i<textBoxes.Length;i++)
     {
         textBoxes[i].Enabled = !isEmptyTable;
         if (row.IsNull(textFieldNames[i]))
         {
             textBoxes[i].Text = "";
         }
         else
         {
             textBoxes[i].Text = (string)row[textFieldNames[i]];
         }
     }
 }
Exemple #4
0
 public static void UpdateDateControls(AutoCompleteTextBox[] dateBoxes,Button[] dateButtons,
     string[] dateFieldNames,EMDataRow row,bool isEmptyTable)
 {
     for (int i=0;i<dateBoxes.Length;i++)
     {
         dateBoxes[i].Enabled = !isEmptyTable;
         dateButtons[i].Enabled = !isEmptyTable;
         if (row.IsNull(dateFieldNames[i]))
         {
             dateBoxes[i].Text = "";
         }
         else
         {
             DateTime date = (DateTime)row[dateFieldNames[i]];
             dateBoxes[i].Text = HelperFunctions.ToDateText(date);
         }
     }
 }
Exemple #5
0
        public static void OnDateLeave(object sender,AutoCompleteTextBox[] dateBoxes,string[] dateFields,
            EMDataRow row)
        {
            AutoCompleteTextBox dateBox = null;
            string dateField="";
            for (int i=0;i<dateBoxes.Length;i++)
            {
                if (sender == dateBoxes[i])
                {
                    dateBox = dateBoxes[i];
                    dateField = dateFields[i];
                    break;
                }
            }
            Debug.Assert(dateBox != null);
            try
            {
                if (dateBox.Text == "")
                    row[dateField] = DBNull.Value;
                else
                    row[dateField] = dateBox.Text;
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            if (row.IsNull(dateField))
            {
                dateBox.Text = "";
            }
            else
            {
                dateBox.Text = HelperFunctions.ToDateText(
                    (DateTime)row[dateField]);
            }
        }
Exemple #6
0
 public static DialogResult OnDateBtn(object sender,Button[] dateButtons,AutoCompleteTextBox[] dateBoxes,
     string[] dateFieldNames,EMDataRow row,out DateTime dateTime)
 {
     // first find the control
     int i=0;
     for (i=0;i<dateButtons.Length;i++)
     {
         if (sender == dateButtons[i])
         {
             break;
         }
     }
     Debug.Assert(i!= dateButtons.Length);
     string fieldName = dateFieldNames[i];
     AutoCompleteTextBox box = dateBoxes[i];
     if (row.IsNull(fieldName))
         dateTime = System.DateTime.Today;
     else
         dateTime = (DateTime)row[fieldName];
     if (DialogResult.OK == DateTimeSelector.RequestTime(ref dateTime))
     {
         box.Text = HelperFunctions.ToDateText(dateTime);
         return DialogResult.OK;
     }
     return DialogResult.Cancel;
 }
 public static void TransferFinish(string columnName,
     DataRow sourceRow,EMDataRow targetRow)
 {
     object finishID;
     if (sourceRow.IsNull(columnName))
         finishID = DBNull.Value;
     else
     {
         string finishType = (string)sourceRow[columnName];
         finishID = HelperFunctions.GetFinishKey(columnName,finishType);
     }
     string keyName = columnName + "ID";
     targetRow[keyName] = finishID;
 }