private void InitDataGridView()
{
DataTable dt = UserRoleDAO.GetDatasByUserId(this.userId);
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dataGridView, dt);
}
private void InitDataGridViewChildTemp(string strReceiptId)
{
DataTable dt = MatSplitChildDAO.GetDatasByReceiptId(strReceiptId);
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dgvMatChild, dt);
}
private void InitDataGridViewChild()
{
DataTable dt = MatSplitChildDAO.GetDatas();
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dgvMatChild, dt);
}
private void InitDataGridView()
{
DataTable dt = ReceiptModalDAO.GetDatas();
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dataGridViewRecMod, dt);
this.dataGridViewRecMod.ClearSelection();
this.dataGridViewRecMod.Rows[this.curRowIndex].Selected = true;
}
/// <summary>
/// 初始化显示数据表
/// </summary>
public void initDataGridView()
{
DataTable dt = UsersDAO.GetDatasOfUsers();
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dataGridViewUsers, dt);
this.dataGridViewUsers.RowHeadersWidth = 45;
this.dataGridViewUsers.ClearSelection();
this.dataGridViewUsers.Rows[this.curRowIndex].Selected = true;
}
public void initDataGridView()
{
DataTable dt = (new SqlDBConnect()).Get_Dt(this.Basesql +" "+this.whereTJ);
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dataGridView1, dt);
this.dataGridView1.ClearSelection();
if(this.curRowIndex>0)
this.dataGridView1.Rows[this.curRowIndex].Selected = true;
this.dataGridView1.Columns["物料编号"].Width = 105;
this.dataGridView1.Columns["物料名称"].Width = 250;
this.dataGridView1.Columns["型号规格"].Width = 80;
this.dataGridView1.Columns["计量单位"].Width = 80;
this.toolStripStatusLabel1.Text = " 记录数："
+ (this.dataGridView1.Rows.Count).ToString().Trim();
}
/// <summary>
/// 初始化DataGridView
/// </summary>
/// <param name="dataGridView">dgv</param>
/// <param name="dt">数据集</param>
public void InitDataGridView(DataGridView dataGridView, DataTable dt)
{
InitFuncs IniF = new InitFuncs();
IniF.InitDataGridView(dataGridView, dt);
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnOK_Click(object sender, EventArgs e)
{
//以中文字段名显示
//Return_Sql = "select * from " + tableName + " where "; //英文字段名
//for (int i = 0; i < lb_sql.Items.Count; i++)
//{
// Return_Sql += " " + lb_sql.Items[i].ToString().Trim();
//}
Return_Sql = "";
if (lb_sql.Items.Count > 0)
{
if (this.strSql.Contains(" where "))
Return_Sql += this.strSql + " and ";
else
Return_Sql += this.strSql + " where ";
for (int i = 0; i < lb_sql.Items.Count; i++)
{
Return_Sql += " " + lb_sql.Items[i].ToString().Trim();
}
}
else
Return_Sql = this.strSql;
try
{
SqlDBConnect db = new SqlDBConnect();
DataTable dt = new DataTable();
dt = db.Get_Dt(Return_Sql);
if (dt == null || dt.Rows.Count <= 0)
{
MessageBox.Show("没有符合条件的记录存在！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dataGridView, dt);
this.Height = 450;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString() + "\n" + Return_Sql, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void init_muladd()
{
string sql_ = "select sysid as 系统编号,AddType as 地址种类,Addr as 客户地址,Memo as 备注 "
+ " from T_CustomerAdd "
+ " where custid='" + s_CustID.Text.Trim() + "'";
DataTable dt = (new SqlDBConnect()).Get_Dt(sql_);
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dataGridView_CustomerAdd, dt);
this.dataGridView_CustomerAdd.Columns[0].Visible = false;
}
private void init_lxr()
{
string sql_ = "select sysid as 系统编号,Cname as 联系人,ctype as 类别,sex as 性别,Email,Tel1 as 联系电话1,Tel2 as 联系电话2, tel as 手机 "
+ " from T_CustContacts "
+ " where custid='" + s_CustID.Text.Trim() + "'";
DataTable dt = (new SqlDBConnect()).Get_Dt(sql_);
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dataGridView_contacts, dt);
this.dataGridView_contacts.Columns[0].Visible = false;
}
private void init_fp()
{
string sql_ = "select sysid as 系统编号,IType as 发票种类,Ititle as 发票抬头,Idet as 发票内容,Memo as 备注 "
+ " from T_CustomerInvoice "
+ " where custid='" + s_CustID.Text.Trim() + "'";
DataTable dt = (new SqlDBConnect()).Get_Dt(sql_);
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dataGridView_Invoice, dt);
this.dataGridView_Invoice.Columns[0].Visible = false;
}
/// <summary>
/// 初始化绑定DataGridView
/// </summary>
private void InitDataGridView()
{
DataTable dt = MenuCfgChildDAO.GetDatas();
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dataGridViewMenuChid, dt);
this.dataGridViewMenuChid.ClearSelection();
this.dataGridViewMenuChid.Rows[this.curRowIndex].Selected = true;
this.dataGridViewMenuChid.Columns[0].Visible = false;
}
/// <summary>
/// 初始化DataGridView
/// </summary>
private void InitDataGridView(int seleRowIndex)
{
DataTable dt = RolesDAO.GetDatas();
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dataGridViewRoles, dt);
foreach (DataGridViewRow row in this.dataGridViewRoles.Rows)
{
if (row.Index == seleRowIndex)
row.Selected = true;
else
row.Selected = false;
}
}
private void InitDataGridViewMain()
{
DataTable dt = MatSplitMainDAO.GetDatas();
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dgvMatMain, dt);
this.dgvMatMain.ClearSelection();
this.dgvMatMain.Rows[this.CurRowIndex].Selected = true;
}
