public static Double DT_HourMinConvertToHour(int tam) { if (tam == 0) { return(0); } //return T_String.IsNullTo00((tam/100)+"."+(((double)tam-((tam/100)*100))/60)); return(T_String.IsNullTo00((tam / 100) + (((double)tam - ((tam / 100) * 100)) / 60) + "")); }
public static int DT_GetDays(DateTime dt1, DateTime dt2) { int tam = 0; DateTime d1 = dt1; DateTime d2 = dt2; while (T_String.IsNullTo0(d1.ToString("yyyyMMdd")) <= T_String.IsNullTo0(d2.ToString("yyyyMMdd"))) { tam++; d1 = d1.AddDays(1); } return(tam); }
public static int DT_GetDays(DateTime dt1, DateTime dt2, string EMP_ID) { int tam = 0; DateTime d1 = dt1; DateTime d2 = dt2; while (T_String.IsNullTo0(d1.ToString("yyyyMMdd")) <= T_String.IsNullTo0(d2.ToString("yyyyMMdd"))) { string sql = "EMP_ID=N'" + EMP_ID + "' and YYY_MM=N'" + d1.ToString("yyyyMM") + "'"; if (GetDataFromSQL("DAY_" + d1.ToString("dd"), "FILC03A", sql) != "00" && d1.DayOfWeek != DayOfWeek.Sunday) { tam++; } d1 = d1.AddDays(1); } return(tam); }
public static Double GetMax0(string FieldName, string from, string where) { return(T_String.IsNullTo00(GetDataFromSQL(FieldName, from, where)) + 1); }
public static int GetMax(string FieldName, string from) { return(T_String.IsNullTo0(GetDataFromSQL(FieldName, from)) + 1); }
public static Boolean CompareDate(DateTime dt1, DateTime dt2) { return(T_String.IsNullTo0(dt1.ToString("yyyyMMdd")) >= T_String.IsNullTo0(dt2.ToString("yyyyMMdd"))); }
public static void D_GetDataFromVS(System.Windows.Forms.GroupBox fr, C1.Win.C1FlexGrid.C1FlexGrid vs) { int i = 0; if (vs.Row <= 0) { try { for (i = 0; i < fr.Controls.Count; i++) { switch (fr.Controls[i].GetType().FullName) { case "C1.Win.C1Input.C1TextBox": C1.Win.C1Input.C1TextBox c1txt = (C1.Win.C1Input.C1TextBox)fr.Controls[i]; if ((c1txt.Tag + "") != "") { c1txt.Value = null; } break; case "System.Windows.Forms.TextBox": if ((((System.Windows.Forms.TextBox)fr.Controls[i]).Tag + "") != "") { ((System.Windows.Forms.TextBox)fr.Controls[i]).Text = null; } break; case "System.Windows.Forms.DateTimePicker": System.Windows.Forms.DateTimePicker dt = (System.Windows.Forms.DateTimePicker)fr.Controls[i]; if (dt.Tag + "" != "") { dt.Text = null; } break; case "C1.Win.C1Input.C1DateEdit": C1.Win.C1Input.C1DateEdit dt1 = (C1.Win.C1Input.C1DateEdit)fr.Controls[i]; if (dt1.Tag + "" != "") { dt1.Value = null; } break; case "System.Windows.Forms.CheckBox": CheckBox chbox = (System.Windows.Forms.CheckBox)fr.Controls[i]; if ((chbox.Tag + "") != "") { chbox.Checked = false; } break; case "System.Windows.Forms.ComboBox": ComboBox cbbox = (System.Windows.Forms.ComboBox)fr.Controls[i]; if ((cbbox.Tag + "") != "") { cbbox.SelectedValue = ""; } break; } } } catch (Exception) { MessageBox.Show("Get data from VS error" + fr.Controls[i].Tag); } return; } else { string st = ""; try { for (i = 0; i < fr.Controls.Count; i++) { switch (fr.Controls[i].GetType().FullName) { case "C1.Win.C1Input.C1TextBox": C1.Win.C1Input.C1TextBox c1txt = (C1.Win.C1Input.C1TextBox)fr.Controls[i]; st = ""; if ((c1txt.Tag + "") != "") { st = D_GetDataFromVS1(vs, c1txt.Tag + ""); } if (st == "") { st = null; } c1txt.Value = st; break; case "System.Windows.Forms.TextBox": if ((((System.Windows.Forms.TextBox)fr.Controls[i]).Tag + "") != "") { ((System.Windows.Forms.TextBox)fr.Controls[i]).Text = D_GetDataFromVS1(vs, ((System.Windows.Forms.TextBox)fr.Controls[i]).Tag + ""); } break; case "System.Windows.Forms.DateTimePicker": System.Windows.Forms.DateTimePicker dt = (System.Windows.Forms.DateTimePicker)fr.Controls[i]; if (dt.Tag + "" != "") { st = ""; st = D_GetDataFromVS1(vs, dt.Tag + ""); if (st == "" || st == null) { dt.Text = null; } else { dt.Text = st; } } break; case "C1.Win.C1Input.C1DateEdit": C1.Win.C1Input.C1DateEdit dt1 = (C1.Win.C1Input.C1DateEdit)fr.Controls[i]; if (dt1.Tag + "" != "") { st = ""; st = D_GetDataFromVS1(vs, dt1.Tag + ""); if (st == "" || st == null) { dt1.Value = null; } else { dt1.Value = DateTime.Parse(st).ToString("yyyy/MM/dd"); } } break; case "System.Windows.Forms.CheckBox": CheckBox chbox = (System.Windows.Forms.CheckBox)fr.Controls[i]; if ((chbox.Tag + "") != "") { chbox.Checked = ConvertStringToBoolean(D_GetDataFromVS1(vs, chbox.Tag + "")); } break; case "System.Windows.Forms.ComboBox": ComboBox cbbox = (System.Windows.Forms.ComboBox)fr.Controls[i]; if ((cbbox.Tag + "") != "") { cbbox.SelectedValue = ""; string st1 = D_GetDataFromVS1(vs, cbbox.Tag + ""); if (st1 == "") { cbbox.SelectedValue = ""; } else { cbbox.SelectedValue = st1; } } break; } } TextBoxAndVS.D_AddNewOrEdit(fr, (T_String.IsNullTo0(vs.Rows[vs.Row].UserData + "") != 2)); } catch (Exception) { MessageBox.Show("Get data from VS error" + fr.Controls[i].Tag); } } }
public static void D_GetDataFromTextBox(System.Windows.Forms.GroupBox fr, C1.Win.C1FlexGrid.C1FlexGrid vs) { if (vs.Row <= 0) { return; } try { for (int i = 0; i < fr.Controls.Count; i++) { switch (fr.Controls[i].GetType().FullName) { case "C1.Win.C1Input.C1DateEdit": C1.Win.C1Input.C1DateEdit dt1 = (C1.Win.C1Input.C1DateEdit)fr.Controls[i]; if (dt1.Tag + "" != "") { if (dt1.Value + "" == "") { vs.SetData(vs.Row, dt1.Tag + "", null); } else { // if (dt1.CustomFormat!="" || dt1.CustomFormat!=null) // vs.SetData(vs.Row,dt1.Tag+"",Set_vs(DateTime.Parse(dt1.Value+"").ToString(dt1.CustomFormat))); // else vs.SetData(vs.Row, dt1.Tag + "", Set_vs(dt1.Value)); } } break; case "C1.Win.C1Input.C1TextBox": C1.Win.C1Input.C1TextBox c1txt = (C1.Win.C1Input.C1TextBox)fr.Controls[i]; if ((c1txt.Tag + "") != "") { vs.SetData(vs.Row, c1txt.Tag + "", Set_vs(c1txt.Value)); } break; case "System.Windows.Forms.TextBox": TextBox txt = (System.Windows.Forms.TextBox)fr.Controls[i]; if ((txt.Tag + "") != "") { vs.SetData(vs.Row, txt.Tag + "", Set_vs(txt.Text)); } break; case "System.Windows.Forms.CheckBox": CheckBox chbox = (System.Windows.Forms.CheckBox)fr.Controls[i]; if ((chbox.Tag + "") != "") { vs.SetData(vs.Row, chbox.Tag + "", Set_vs(chbox.Checked)); } break; case "System.Windows.Forms.ComboBox": ComboBox cbbox = (System.Windows.Forms.ComboBox)fr.Controls[i]; if ((cbbox.Tag + "") != "") { vs.SetData(vs.Row, cbbox.Tag + "", Set_vs(cbbox.SelectedValue)); } break; } } TextBoxAndVS.D_AddNewOrEdit(fr, (T_String.IsNullTo0(vs.Rows[vs.Row].UserData + "") != 2)); } catch (Exception) { MessageBox.Show("Get data from VS error"); } }