private void InitDataGridViewChildTemp(string strReceiptId)
{
DataTable dt = MatSplitChildDAO.GetDatasByReceiptId(strReceiptId);
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dgvMatChild, dt);
}
private void InitDataGridView()
{
DataTable dt = UserRoleDAO.GetDatasByUserId(this.userId);
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dataGridView, dt);
}
private void InitDataGridViewChild()
{
DataTable dt = MatSplitChildDAO.GetDatas();
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dgvMatChild, dt);
}
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;
}
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_CustMaContacts "
+ " where CmSysId='" + Cmsysid + "'";
DataTable dt = (new SqlDBConnect()).Get_Dt(sql_);
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dataGridView_CustMaContacts, dt);
this.dataGridView_CustMaContacts.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;
}
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 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;
}
/// <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>
/// 查询
/// </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_fp()
{
string sql_ = "select T_CustomerMaInvoice.sysid as 系统编号,"
+ "T_StoreHouse.shname as 所属公司,"
+ "T_Invoice.itname as 发票种类,"
+ "T_CustomerMaInvoice.Ititle as 发票抬头,"
+ "T_CustomerMaInvoice.matid as 发票内容,"
+ "T_CustomerMaInvoice.Memo as 备注 "
+ " from T_CustomerMaInvoice "
+ " left join T_StoreHouse on T_CustomerMaInvoice.kpcorp=T_StoreHouse.shid "
+ " left join T_Invoice on T_CustomerMaInvoice.IType=T_Invoice.itcode "
+ " where T_CustomerMaInvoice.CmSysId='" + Cmsysid + "'";
DataTable dt = (new SqlDBConnect()).Get_Dt(sql_);
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitDataGridView(this.dataGridView_CustomerMaInvoice, dt);
this.dataGridView_CustomerMaInvoice.Columns[0].Visible = false;
}
//显示故障解决方法列表
private void show_Grid2(string errsysid_, int curindex_)
{
string strSql = "select T_ErrSol.Esysid,T_ErrSol.sysid,T_ErrSol.reason as 可能原因,T_ErrSol.solution as 解决方法,"
+ " T_users.Username as 提供者 "
+ " from T_ErrSol "
+ " left join T_users on T_ErrSol.gperson=T_users.userid "
+ " where T_ErrSol.Esysid=" + errsysid_;
DataTable dt = (new SqlDBConnect()).Get_Dt(strSql);
InitFuncs IniF = new InitFuncs();
IniF.InitDataGridView(dataGridView2, dt);
//设置宽度
for (int i = 0; i < dataGridView2.ColumnCount; i++)
{
if (dataGridView2.Columns[i].HeaderText == "sysid")
{
dataGridView2.Columns[i].Visible = false;
}
if (dataGridView2.Columns[i].HeaderText == "Esysid")
{
dataGridView2.Columns[i].Visible = false;
}
else if (dataGridView2.Columns[i].HeaderText == "可能原因")
{
dataGridView2.Columns[i].Width = 300;
}
else if (dataGridView2.Columns[i].HeaderText == "解决方法")
{
dataGridView2.Columns[i].Width = 300;
}
}
///
if (dataGridView2.Rows.Count > 0)
{
try
{
dataGridView2.ClearSelection();
this.dataGridView2.CurrentCell = this.dataGridView2.Rows[curindex_].Cells[1];
dataGridView2.Rows[curindex_].Selected = true;
}
catch
{ }
}
}
//显示该物料的相关故障
private void show_Grid1(int curindex_)
{
string strSql = "select sysid,errorName as 故障定义,errorCode as 故障代码,"
+ "ErrorPlace as 故障部位,errorApperance as 故障现象,memo as 故障描述 "
+ "from T_errors";
DataTable dt = (new SqlDBConnect()).Get_Dt(strSql);
InitFuncs IniF = new InitFuncs();
IniF.InitDataGridView(dataGridView1, dt);
this.dataGridView1.Columns[0].Visible = false;
//设置宽度
for (int i = 0; i < dataGridView1.ColumnCount; i++)
{
if (dataGridView1.Columns[i].HeaderText == "故障编码")
{
dataGridView1.Columns[i].Width = 80;
}
else if (dataGridView1.Columns[i].HeaderText == "故障部位")
{
dataGridView1.Columns[i].Width = 150;
}
else if (dataGridView1.Columns[i].HeaderText == "故障现象")
{
dataGridView1.Columns[i].Width = 200;
}
else if (dataGridView1.Columns[i].HeaderText == "故障描述")
{
dataGridView1.Columns[i].Width = 200;
}
}
try
{
if (dataGridView1.Rows.Count > 0)
{
dataGridView1.ClearSelection();
this.dataGridView1.CurrentCell = this.dataGridView1.Rows[curindex_].Cells[0];
dataGridView1.Rows[curindex_].Selected = true;
}
}
catch (Exception ex)
{
}
}
/// <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;
}
}
}
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);
}