?? mymodule.cs
字號:
}
#endregion
#region 向comboBox控件傳遞數據表中的數據
/// <summary>
/// 動態向comboBox控件的下拉列表添加數據.
/// </summary>
/// <param name="cobox">comboBox控件</param>
/// <param name="TableName">數據表名稱</param>
public void CoPassData(ComboBox cobox, string TableName)
{
cobox.Items.Clear();
DataClass.MyMeans MyDataClsaa = new PWMS.DataClass.MyMeans();
SqlDataReader MyDR = MyDataClsaa.getcom("select * from " + TableName);
if (MyDR.HasRows)
{
while (MyDR.Read())
{
if (MyDR[1].ToString() != "" && MyDR[1].ToString()!=null)
cobox.Items.Add(MyDR[1].ToString());
}
}
}
#endregion
#region 向comboBox控件傳遞各省市的名稱
/// <summary>
/// 動態向comboBox控件的下拉列表添加省名.
/// </summary>
/// <param name="cobox">comboBox控件</param>
/// <param name="SQLstr">SQL語句</param>
/// <param name="n">字段位數</param>
public void CityInfo(ComboBox cobox, string SQLstr, int n)
{
cobox.Items.Clear();
DataClass.MyMeans MyDataClsaa = new PWMS.DataClass.MyMeans();
SqlDataReader MyDR = MyDataClsaa.getcom(SQLstr);
if (MyDR.HasRows)
{
while (MyDR.Read())
{
if (MyDR[n].ToString() != "" && MyDR[n].ToString() != null)
cobox.Items.Add(MyDR[n].ToString());
}
}
}
#endregion
#region 將日期轉換成指定的格式
/// <summary>
/// 將日期轉換成yyyy-mm-dd格式.
/// </summary>
/// <param name="NDate">日期</param>
/// <returns>返回String對象</returns>
public string Date_Format(string NDate)
{
string sm,sd;
int y, m, d;
try
{
y = Convert.ToDateTime(NDate).Year;
m = Convert.ToDateTime(NDate).Month;
d = Convert.ToDateTime(NDate).Day;
}
catch
{
return "";
}
if (y == 1900)
return "";
if (m < 10)
sm = "0" + Convert.ToString(m);
else
sm = Convert.ToString(m);
if (d < 10)
sd = "0" + Convert.ToString(d);
else
sd = Convert.ToString(d);
return Convert.ToString(y) + "-" + sm + "-" + sd;
}
#endregion
#region 將時間轉換成指定的格式
/// <summary>
/// 將時間轉換成yyyy-mm-dd格式.
/// </summary>
/// <param name="NDate">日期</param>
/// <returns>返回String對象</returns>
public string Time_Format(string NDate)
{
string sh, sm, se;
int hh, mm, ss;
try
{
hh = Convert.ToDateTime(NDate).Hour;
mm = Convert.ToDateTime(NDate).Minute;
ss = Convert.ToDateTime(NDate).Second;
}
catch
{
return "";
}
sh = Convert.ToString(hh);
if (sh.Length < 2)
sh = "0" + sh;
sm = Convert.ToString(mm);
if (sm.Length < 2)
sm = "0" + sm;
se = Convert.ToString(ss);
if (se.Length < 2)
se = "0" + se;
return sh + sm + se;
}
#endregion
#region 設置MaskedTextBox控件的格式
/// <summary>
/// 將MaskedTextBox控件的格式設為yyyy-mm-dd格式.
/// </summary>
/// <param name="NDate">日期</param>
/// <param name="ID">數據表名稱</param>
/// <returns>返回String對象</returns>
public void MaskedTextBox_Format(MaskedTextBox MTBox)
{
MTBox.Mask = "0000-00-00";
MTBox.ValidatingType = typeof(System.DateTime);
}
#endregion
#region 用按鈕控制數據記錄移動時，改變按鈕的可用狀態
/// <summary>
/// 設置按鈕是否可用.
/// </summary>
/// <param name="B1">首記錄按鈕</param>
/// <param name="B2">上一條記錄按鈕</param>
/// <param name="B3">下一條記錄按鈕</param>
/// <param name="B4">尾記錄按鈕</param>
/// <param name="NDate">B1標識</param>
/// <param name="NDate">B2標識</param>
/// <param name="NDate">B3標識</param>
/// <param name="NDate">B4標識</param>
public void Ena_Button(Button B1, Button B2, Button B3, Button B4, int n1, int n2, int n3, int n4)
{
B1.Enabled = Convert.ToBoolean(n1);
B2.Enabled = Convert.ToBoolean(n2);
B3.Enabled = Convert.ToBoolean(n3);
B4.Enabled = Convert.ToBoolean(n4);
}
#endregion
#region 遍歷清空指定的控件
/// <summary>
/// 清空所有控件下的所有控件.
/// </summary>
/// <param name="Con">可視化控件</param>
public void Clear_Control(Control.ControlCollection Con)
{
foreach (Control C in Con){ //遍歷可視化組件中的所有控件
if (C.GetType().Name == "TextBox") //判斷是否為TextBox控件
if (((TextBox)C).Visible == true) //判斷當前控件是否為顯示狀態
((TextBox)C).Clear(); //清空當前控件
if (C.GetType().Name == "MaskedTextBox") //判斷是否為MaskedTextBox控件
if (((MaskedTextBox)C).Visible == true) //判斷當前控件是否為顯示狀態
((MaskedTextBox)C).Clear(); //清空當前控件
if (C.GetType().Name == "ComboBox") //判斷是否為ComboBox控件
if (((ComboBox)C).Visible == true) //判斷當前控件是否為顯示狀態
((ComboBox)C).Text = ""; //清空當前控件的Text屬性值
if (C.GetType().Name == "PictureBox") //判斷是否為PictureBox控件
if (((PictureBox)C).Visible == true) //判斷當前控件是否為顯示狀態
((PictureBox)C).Image = null; //清空當前控件的Image屬性
}
}
#endregion
#region 保存添加或修改的信息
/// <summary>
/// 保存添加或修改的信息.
/// </summary>
/// <param name="Sarr">數據表中的所有字段</param>
/// <param name="ID1">第一個字段值</param>
/// <param name="ID2">第二個字段值</param>
/// <param name="Contr">指定控件的數據集</param>
/// <param name="BoxName">要搜索的控件名稱</param>
/// <param name="TableName">數據表名稱</param>
/// <param name="n">控件的個數</param>
/// <param name="m">標識，用于判斷是添加還是修改</param>
public void Part_SaveClass(string Sarr, string ID1, string ID2, Control.ControlCollection Contr, string BoxName, string TableName, int n, int m)
{
string tem_Field = "", tem_Value = "";
int p = 2;
if (m == 1){ //當m為1時，表示添加數據信息
if (ID1 != "" && ID2 == ""){ //根據參數值判斷添加的字段
tem_Field = "ID";
tem_Value = "'" + ID1 + "'";
p = 1;
}
else{
tem_Field = "Sut_id,ID";
tem_Value = "'" + ID1 + "','" + ID2 + "'";
}
}
else
if (m == 2){ //當m為2時，表示修改數據信息
if (ID1 != "" && ID2 == ""){ //根據參數值判斷添加的字段
tem_Value = "ID='" + ID1 + "'";
p = 1;
}
else
tem_Value = "Sut_ID='" + ID1 + "',ID='" + ID2 + "'";
}
if (m > 0){ //生成部份添加、修改語句
string[] Parr = Sarr.Split(Convert.ToChar(','));
for (int i = p; i < n; i++)
{
string sID = BoxName + i.ToString(); //通過BoxName參數獲取要進行操作的控件名稱
foreach (Control C in Contr){ //遍歷控件集中的相關控件
if (C.GetType().Name == "TextBox" | C.GetType().Name == "MaskedTextBox" | C.GetType().Name == "ComboBox")
if (C.Name == sID){ //如果在控件集中找到相應的組件
string Ctext = C.Text;
if (C.GetType().Name == "MaskedTextBox") //如果當前是MaskedTextBox控件
Ctext = Date_Format(C.Text); //對當前控件的值進行格式化
if (m == 1){ //組合SQL語句中insert的相關語句
tem_Field = tem_Field + "," + Parr[i];
if (Ctext == "")
tem_Value = tem_Value + "," + "NULL";
else
tem_Value = tem_Value + "," + "'" + Ctext + "'";
}
if (m == 2)
{ //組合SQL語句中update的相關語句
if (Ctext=="")
tem_Value = tem_Value + "," + Parr[i] + "=NULL";
else
tem_Value = tem_Value + "," + Parr[i] + "='" + Ctext + "'";
}
}
}
}
ADDs = "";
if (m == 1) //生成SQL的添加語句
ADDs = "insert into " + TableName + " (" + tem_Field + ") values(" + tem_Value + ")";
if (m == 2) //生成SQL的修改語句
if (ID2 == "") //根據ID2參數，判斷修改語句的條件
ADDs = "update " + TableName + " set " + tem_Value + " where ID='" + ID1 + "'";
else
ADDs = "update " + TableName + " set " + tem_Value + " where ID='" + ID2 + "'";
}
}
#endregion
#region 將當前表的數據信息顯示在指定的控件上
/// <summary>
/// 將DataGridView控件的當前記錄顯示在其它控件上.
/// </summary>
/// <param name="DGrid">DataGridView控件</param>
/// <param name="GBox">GroupBox控件的數據集</param>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -