protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
{
if ((keyData == Keys.Enter) && (dataGridView2.Columns[dataGridView2.CurrentCell.ColumnIndex].HeaderText == "物料编号"))
{
//先结束编辑状态,否则获取不了当前输入的值
this.dataGridView2.EndEdit();
string LikeNameorID = "";
int currentRowIndex = dataGridView2.SelectedCells[0].RowIndex;
//获取当前单元格的值
LikeNameorID = dataGridView2.CurrentCell.Value.ToString();
string sql = "select Matid 物料编号,MatName 物料名称 from T_MatInf " +
"where Matid like '%" + LikeNameorID + "%' or MatName like '%" + LikeNameorID + "%'";
DataTable dt = (new SqlDBConnect()).Get_Dt(sql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = -1;
if (fr.ShowDialog() == DialogResult.OK)
{
dataGridView2.Rows[currentRowIndex].Cells["配套编号"].Value = this.dataGridView1.SelectedRows[0].Cells["sysid"].Value.ToString();
dataGridView2.Rows[currentRowIndex].Cells["物料编号"].Value = fr.dr_.Cells["物料编号"].Value.ToString();
dataGridView2.Rows[currentRowIndex].Cells["物料名称"].Value = fr.dr_.Cells["物料名称"].Value.ToString();
}
}
//继续原来base.ProcessCmdKey中的处理
return(base.ProcessCmdKey(ref msg, keyData));
}
private void button3_Click(object sender, EventArgs e)
{
string swhere = ReturnWhere_Get_machines();
string strSql = "select distinct T_StoreHouse.shname as 所属公司,"
+ "T_Invoice.ITname as 发票类型,"
+ "Ititle as 发票抬头,"
+ "matid as 发票内容,"
+ "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 in "
+ "(select MachineId from t_bargains "
+ swhere + ")";
DataTable dt = (new SqlDBConnect()).Get_Dt(strSql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = -1;
if (fr.ShowDialog() == DialogResult.OK)
{
this.t_kpcorp.Text = fr.dr_.Cells["所属公司"].Value.ToString();
this.t_Itype.Text = fr.dr_.Cells["发票类型"].Value.ToString();
this.t_Itype_SelectedIndexChanged(null, null);
this.t_kpcorp_SelectedIndexChanged(null, null);
this.s_Ititle.Text = fr.dr_.Cells["发票抬头"].Value.ToString();
this.s_Icontent.Text = fr.dr_.Cells["发票内容"].Value.ToString();
this.s_Memo.Text = fr.dr_.Cells["备注"].Value.ToString();
}
}
/// <summary>
/// 相应回车事件
/// </summary>
/// <param name="msg"></param>
/// <param name="keyData"></param>
/// <returns></returns>
protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
{
if (tabControl1.SelectedIndex == 0)
{
if ((keyData == Keys.Enter) && (dgv_consume.Columns[dgv_consume.CurrentCell.ColumnIndex].HeaderText == "物料编码"))
{
//先结束边界,否则获取不了当前输入的值
dgv_consume.EndEdit();
string LikeNameorID = "";
int currentRowIndex = dgv_consume.SelectedCells[0].RowIndex;
//获取当前单元格的值
LikeNameorID = dgv_consume.CurrentCell.Value.ToString();
string sql = "select Matid 物料编号,MatName 物料名称 from T_MatInf " +
"where Matid like '" + LikeNameorID + "%' or MatName like '" + LikeNameorID + "%'";
DataTable dt = (new SqlDBConnect()).Get_Dt(sql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = -1;
if (fr.ShowDialog() == DialogResult.OK)
{
dgv_consume.Rows[currentRowIndex].Cells["机型编号"].Value = this.CurModelSysid;
dgv_consume.Rows[currentRowIndex].Cells["机型名"].Value = this.CurModel;
dgv_consume.Rows[currentRowIndex].Cells["物料编码"].Value = fr.dr_.Cells["物料编号"].Value.ToString();
dgv_consume.Rows[currentRowIndex].Cells["物料名称"].Value = fr.dr_.Cells["物料名称"].Value.ToString();
dgv_consume.Rows[currentRowIndex].Cells["类型"].Value = "耗材";
}
}
}
else
{
if ((keyData == Keys.Enter) && (dgv_part.Columns[dgv_part.CurrentCell.ColumnIndex].HeaderText == "物料编码"))
{
//先结束编辑状态,否则获取不了当前输入的值
dgv_part.EndEdit();
string LikeNameorID = "";
int currentRowIndex = dgv_part.SelectedCells[0].RowIndex;
//获取当前单元格的值
LikeNameorID = dgv_part.CurrentCell.Value.ToString();
string sql = "select Matid 物料编号,MatName 物料名称 from T_MatInf " +
"where Matid like '%" + LikeNameorID + "%' or MatName like '%" + LikeNameorID + "%'";
DataTable dt = (new SqlDBConnect()).Get_Dt(sql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = -1;
if (fr.ShowDialog() == DialogResult.OK)
{
dgv_part.Rows[currentRowIndex].Cells["机型编号"].Value = this.CurModelSysid;
dgv_part.Rows[currentRowIndex].Cells["机型名"].Value = this.CurModel;
dgv_part.Rows[currentRowIndex].Cells["物料编码"].Value = fr.dr_.Cells["物料编号"].Value.ToString();
dgv_part.Rows[currentRowIndex].Cells["物料名称"].Value = fr.dr_.Cells["物料名称"].Value.ToString();
dgv_part.Rows[currentRowIndex].Cells["类型"].Value = "选购件";
}
}
}
//继续原来base.ProcessCmdKey中的处理
return(base.ProcessCmdKey(ref msg, keyData));
}
private void textBox2_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
bool isexist = false;
TextBox textBox = sender as TextBox;
string textBoxName = textBox.Text.Trim();
if (textBoxName == "")
{
return;
}
string where = "where ErrorName like '%{0}%'" +
"or ErrorCode like '%{1}%'" +
"or ErrorPlace like '%{2}%'" +
"or ErrorApperance like '%{3}%'" +
"or Memo like '%{4}%'";
where = string.Format(where, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName);
string BaseSql = "select sysid,ErrorName as 故障定义,"
+ " ErrorCode as 故障代码,"
+ " ErrorPlace as 故障部位,"
+ " ErrorApperance as 故障现象 "
+ " from T_Errors ";
//显示列表
DataTable dt = (new SqlDBConnect()).Get_Dt(BaseSql + where);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = 0;
if (fr.ShowDialog() == DialogResult.OK)
{
if (fr.dr_.Cells["sysid"].Value == null)
{
return;
}
if (fr.dr_.Cells["sysid"].Value.ToString().Trim() == "")
{
return;
}
string sysid_ = fr.dr_.Cells["sysid"].Value.ToString().Trim();
//
string sql_ = "select ErrOrDocid from T_ModelErrDocs "
+ " where modelsysid=" + select_model_sysid
+ " and typeid=0 and ErrOrDocid=" + sysid_;
isexist = (new DBUtil()).yn_exist_data(sql_);
if (isexist == false)
{
sql_ = "insert into T_ModelErrDocs(modelsysid,typeid,ErrOrDocid)"
+ " values({0},{1},{2})";
sql_ = string.Format(sql_, select_model_sysid, 0, sysid_);
(new SqlDBConnect()).ExecuteNonQuery(sql_);
show_rela_err_doc(select_model_sysid);
}
}
}
}
private void s_Mtype_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
TextBox textBox = sender as TextBox;
string textBoxName = textBox.Text.Trim();
if (textBoxName == "")
{
return;
}
string BasicSql = "select SysID, ModelName as 机型名,"
+ "ProdCtgrID as 分类,"
+ "ModelType as 机器类别,"
+ "ModelName1 as 机型别名1,ModelName2 as 机型别名2,"
+ "ModelGrade as 机器等级,"
+ "Modelbrand as 品牌,"
+ "Ndxs as 难度系数 "
+ "from T_Model";
string swhere = " where ModelName like '%{0}%'" +
"or ModelName1 like '%{1}%'" +
"or ModelName2 like '%{2}%'" +
"or ProdCtgrID like '%{3}%'" +
"or ModelType like '%{4}%'" +
"or Modelbrand like '%{5}%'" +
"or ModelGrade like '%{6}%'";
swhere = string.Format(swhere, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName);
//显示列表
DataTable dt = (new SqlDBConnect()).Get_Dt(BasicSql + swhere);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = 0;
if (fr.ShowDialog() == DialogResult.OK)
{
if (fr.dr_.Cells["sysid"].Value == null)
{
return;
}
if (fr.dr_.Cells["sysid"].Value.ToString().Trim() == "")
{
return;
}
this.s_Mtype.Text = fr.dr_.Cells["机型名"].Value.ToString().Trim();
}
}
}
private void textBox1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
TextBox textBox = sender as TextBox;
string textBoxName = textBox.Text.Trim();
if (textBoxName == "")
{
return;
}
string strSql = "select T_bargains.sysid as 合同系统编号,"
+ "T_bargains.bargid as 合同编号,"
+ "T_bargains.custcode as 客户编码,"
+ "T_customerInf.CustName as 客户名称,"
+ "T_bargains.mtype as 机型,"
+ "T_bargains.Manufactcode as 机号"
+ " from T_bargains "
+ "left join T_customerInf on T_bargains.custcode=T_customerInf.custid"
+ " where T_bargains.custcode like '%{0}%' "
+ "or T_customerInf.CustName like '%{1}%' "
+ "or T_customerInf.PinYinCode like '%{2}%' "
+ "or T_bargains.mtype like '%{3}%' "
+ "or T_bargains.Manufactcode like '%{4}%' "
+ "or T_bargains.bargid like '%{5}%' ";
strSql = string.Format(strSql, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName);
DataTable dt = (new SqlDBConnect()).Get_Dt(strSql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = 0;
if (fr.ShowDialog() == DialogResult.OK)
{
DataRow ndr = dtmac.NewRow();
ndr[0] = fr.dr_.Cells["合同系统编号"].Value.ToString().Trim();
ndr[1] = fr.dr_.Cells["合同编号"].Value.ToString().Trim();
ndr[2] = fr.dr_.Cells["机型"].Value.ToString();
ndr[3] = fr.dr_.Cells["机号"].Value.ToString();
//
dtmac.Rows.Add(ndr);
textBox.Text = "";
}
}
}
private void button4_Click(object sender, EventArgs e)
{
string swhere = this.ReturnWhere_Get_machines();
string strSql = "select distinct Ptech as 技术员,Psale as 业务员 "
+ " from T_CustomerMac "
+ " where T_CustomerMac.sysid in "
+ "(select MachineId from t_bargains "
+ swhere + ")";
DataTable dt = (new SqlDBConnect()).Get_Dt(strSql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = -1;
if (fr.ShowDialog() == DialogResult.OK)
{
this.s_Techuser.Text = fr.dr_.Cells["技术员"].Value.ToString();
this.s_SaleUser.Text = fr.dr_.Cells["业务员"].Value.ToString();
}
}
/// <summary>
/// 用户模糊查询
/// </summary>
private void ElsePerson(TextBox textBox)
{
string textBoxName = textBox.Text.Trim();
if (textBoxName == "")
{
return;
}
string Strsql = "select UserId 用户编码,UserName 用户名称, " +
" UserNameZJM 助记码,MobileTel 移动电话 " +
" from T_Users where UserId like '%{0}%' " +
" or UserName like '%{1}%'or UserNameZJM like '%{2}%' " +
" or MobileTel like '%{3}%'";
Strsql = string.Format(Strsql, textBoxName, textBoxName, textBoxName, textBoxName);
DataTable dt = (new SqlDBConnect()).Get_Dt(Strsql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = -1;//不隐藏
if (fr.ShowDialog() == DialogResult.OK)
{
this.Elseperson = fr.dr_.Cells["用户名称"].Value.ToString().Trim();
}
}
private void textBox3_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
bool isexist = false;
TextBox textBox = sender as TextBox;
string textBoxName = textBox.Text.Trim();
if (textBoxName == "") return;
string where = "where DocName like '%{0}%'" +
"or Doctype like '%{1}%'" +
"or Memo like '%{2}%'";
where = string.Format(where, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName);
string BaseSql = "select sysid,DocName as 资料名称,"
+ " Doctype as 类型,"
+ " Memo as 备注"
+ " from T_MatDocs ";
//显示列表
DataTable dt = (new SqlDBConnect()).Get_Dt(BaseSql + where);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = 0;
if (fr.ShowDialog() == DialogResult.OK)
{
if (fr.dr_.Cells["sysid"].Value == null) return;
if (fr.dr_.Cells["sysid"].Value.ToString().Trim() == "") return;
string sysid_ = fr.dr_.Cells["sysid"].Value.ToString().Trim();
//
string sql_ = "select ErrOrDocid from T_ModelErrDocs "
+ " where modelsysid=" + select_model_sysid
+ " and typeid=1 and ErrOrDocid=" + sysid_;
isexist = (new DBUtil()).yn_exist_data(sql_);
if (isexist == false)
{
sql_ = "insert into T_ModelErrDocs(modelsysid,typeid,ErrOrDocid)"
+ " values({0},{1},{2})";
sql_ = string.Format(sql_, select_model_sysid, 1, sysid_);
(new SqlDBConnect()).ExecuteNonQuery(sql_);
show_rela_err_doc(select_model_sysid);
}
}
}
}
private void t_CustCode_KeyDown(object sender, KeyEventArgs e)
{
//根据Custid(客户ID),CustName(客户名),PinYinCode(拼音码),
//mtype，Manufactcode(机号)来模糊查询
if (e.KeyCode == Keys.Enter)
{
//如果有抄张记录了,则不允许改
if (this.Type == "edit")
{
string sql_ = "select * from T_RecordCopy where barsysid=" + this.BargSysId ;
if ((new DBUtil()).yn_exist_data(sql_))
{
MessageBox.Show("该合同已有对应的抄张记录,不允许修改客户信息!");
return;
}
}
//
string BaseSql = "select T_CustomerMac.Sysid as sysid,"
+ "T_CustomerInf.CustID as 客户编码,"
+"T_CustomerInf.CustName as 客户名称,"
+ "T_CustomerMac.Mdepart as 机器地址,"
+ "T_CustomerMac.Mtype as 机型,"
+ "T_CustomerMac.Manufactcode as 机号"
+ " from T_CustomerMac "
+ " left Join T_CustomerInf on T_CustomerInf.CustID=T_CustomerMac.CustID";
TextBox textBox = sender as TextBox;
string textBoxName = textBox.Text.Trim();
if (textBoxName == "") return;
string swhere = " where T_CustomerInf.CustID like '%{0}%'"
+ " or CustName like '%{1}%' or PinYinCode like '%{2}%'"
+ " or (T_CustomerMac.sysid in "
+ "(select sysid from T_CustomerMac where "
+ " T_CustomerMac.Manufactcode like '%{3}%' "
+ " or T_CustomerMac.mtype like '%{4}%'))";
swhere = string.Format(swhere, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName);
//显示列表
DataTable dt = (new SqlDBConnect()).Get_Dt(BaseSql + swhere);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = 0;
if (fr.ShowDialog() == DialogResult.OK)
{
if (fr.dr_.Cells["sysid"].Value == null) return;
if (fr.dr_.Cells["sysid"].Value.ToString().Trim() == "") return;
this.s_CustCode.Text = fr.dr_.Cells["客户编码"].Value.ToString();
this.t_CustCode.Text = fr.dr_.Cells["机器地址"].Value.ToString();
this.n_MachineId.Text = fr.dr_.Cells["sysid"].Value.ToString();
this.s_mtype.Text = fr.dr_.Cells["机型"].Value.ToString();
this.s_Manufactcode.Text = fr.dr_.Cells["机号"].Value.ToString();
}
}
}
/// <summary>
/// 相应回车事件
/// </summary>
/// <param name="msg"></param>
/// <param name="keyData"></param>
/// <returns></returns>
protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
{
if (tabControl1.SelectedIndex == 0)
{
if ((keyData == Keys.Enter) && (dgv_consume.Columns[dgv_consume.CurrentCell.ColumnIndex].HeaderText == "物料编码"))
{
//先结束边界,否则获取不了当前输入的值
dgv_consume.EndEdit();
string LikeNameorID = "";
int currentRowIndex = dgv_consume.SelectedCells[0].RowIndex;
//获取当前单元格的值
LikeNameorID = dgv_consume.CurrentCell.Value.ToString();
string sql = "select Matid 物料编号,MatName 物料名称 from T_MatInf " +
"where Matid like '" + LikeNameorID + "%' or MatName like '" + LikeNameorID + "%'";
DataTable dt = (new SqlDBConnect()).Get_Dt(sql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = -1;
if (fr.ShowDialog() == DialogResult.OK)
{
dgv_consume.Rows[currentRowIndex].Cells["机型编号"].Value = this.CurModelSysid;
dgv_consume.Rows[currentRowIndex].Cells["机型名"].Value = this.CurModel;
dgv_consume.Rows[currentRowIndex].Cells["物料编码"].Value = fr.dr_.Cells["物料编号"].Value.ToString();
dgv_consume.Rows[currentRowIndex].Cells["物料名称"].Value = fr.dr_.Cells["物料名称"].Value.ToString();
dgv_consume.Rows[currentRowIndex].Cells["类型"].Value = "耗材";
}
}
}
else
{
if ((keyData == Keys.Enter) && (dgv_part.Columns[dgv_part.CurrentCell.ColumnIndex].HeaderText == "物料编码"))
{
//先结束编辑状态,否则获取不了当前输入的值
dgv_part.EndEdit();
string LikeNameorID = "";
int currentRowIndex = dgv_part.SelectedCells[0].RowIndex;
//获取当前单元格的值
LikeNameorID = dgv_part.CurrentCell.Value.ToString();
string sql = "select Matid 物料编号,MatName 物料名称 from T_MatInf " +
"where Matid like '%" + LikeNameorID + "%' or MatName like '%" + LikeNameorID + "%'";
DataTable dt = (new SqlDBConnect()).Get_Dt(sql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = -1;
if (fr.ShowDialog() == DialogResult.OK)
{
dgv_part.Rows[currentRowIndex].Cells["机型编号"].Value = this.CurModelSysid;
dgv_part.Rows[currentRowIndex].Cells["机型名"].Value = this.CurModel;
dgv_part.Rows[currentRowIndex].Cells["物料编码"].Value = fr.dr_.Cells["物料编号"].Value.ToString();
dgv_part.Rows[currentRowIndex].Cells["物料名称"].Value = fr.dr_.Cells["物料名称"].Value.ToString();
dgv_part.Rows[currentRowIndex].Cells["类型"].Value = "选购件";
}
}
}
//继续原来base.ProcessCmdKey中的处理
return base.ProcessCmdKey(ref msg, keyData);
}
private void button4_Click(object sender, EventArgs e)
{
string swhere = this.ReturnWhere_Get_machines();
string strSql = "select distinct Ptech as 技术员,Psale as 业务员 "
+ " from T_CustomerMac "
+ " where T_CustomerMac.sysid in "
+ "(select MachineId from t_bargains "
+ swhere + ")";
DataTable dt = (new SqlDBConnect()).Get_Dt(strSql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = -1;
if (fr.ShowDialog() == DialogResult.OK)
{
this.s_Techuser.Text = fr.dr_.Cells["技术员"].Value.ToString();
this.s_SaleUser.Text = fr.dr_.Cells["业务员"].Value.ToString();
}
}
private void textBox1_KeyDown(object sender, KeyEventArgs e)
{
//根据Custid(客户ID),CustName(客户名),PinYinCode(拼音码),
//mtype，Manufactcode(机号)来模糊查询
if (e.KeyCode == Keys.Enter)
{
TextBox textBox = sender as TextBox;
string textBoxName = textBox.Text.Trim();
if (textBoxName == "")
{
return;
}
string sql_ = "select T_bargains.sysid as 合同系统编号,"
+ "T_bargains.BargId as 合同编号,"
+ "T_CustomerInf.custName as 客户名称,"
+ "T_bargains.mtype as 机型,"
+ "T_bargains.Manufactcode as 机号,"
+ "T_bargains.StartDate as 起始日,"
+ "T_bargains.EndDate as 终止日,"
+ "T_CustomerInf.CustID as 客户编号 "
+ " from T_bargains "
+ " left join T_CustomerInf on T_bargains.CustCode=T_CustomerInf.CustID "
+ " where (T_bargains.Bargstatus like '有效') "
+ " and (T_CustomerInf.CustID like '%{0}%'"
+ " or CustName like '%{1}%' or PinYinCode like '%{2}%'"
+ " or (T_bargains.BargId in "
+ "(select bargid from T_bargains "
+ " where Manufactcode like '%{3}%' "
+ " or bargid like '%{4}%' "
+ " or mtype like '%{5}%')))";
sql_ = string.Format(sql_, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName);
DataTable dt = (new SqlDBConnect()).Get_Dt(sql_);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = -1;
if (fr.ShowDialog() == DialogResult.OK)
{
this.dgv_hs.DataSource = false;
this.dgv_cz.DataSource = false;
string barsysid_ = fr.dr_.Cells["合同系统编号"].Value.ToString();
string barid_ = fr.dr_.Cells["合同编号"].Value.ToString();
tb_jx.Text = fr.dr_.Cells["机型"].Value.ToString();
tb_jh.Text = fr.dr_.Cells["机号"].Value.ToString();
tb_bargid.Text = barid_;
//合同号
this.barsysid_ = barsysid_;
this.bargid_ = barid_;
//机号
this.manufactCode_ = tb_jh.Text.Trim();
//机型
this.mtype_ = tb_jx.Text.Trim();
sql_ = "select hctype from T_BargFee where barsysid=" + barsysid_;
dt = (new SqlDBConnect()).Get_Dt(sql_);
this.cb_hctype.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
this.cb_hctype.Items.Add(dt.Rows[i]["hctype"].ToString().Trim());
}
}
}
}
private void textBox1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
TextBox textBox = sender as TextBox;
string textBoxName = textBox.Text.Trim();
if (textBoxName == "") return;
string strSql = "select T_bargains.sysid as 合同系统编号,"
+"T_bargains.bargid as 合同编号,"
+"T_bargains.custcode as 客户编码,"
+ "T_customerInf.CustName as 客户名称,"
+ "T_bargains.mtype as 机型,"
+ "T_bargains.Manufactcode as 机号"
+ " from T_bargains "
+ "left join T_customerInf on T_bargains.custcode=T_customerInf.custid"
+ " where T_bargains.custcode like '%{0}%' "
+ "or T_customerInf.CustName like '%{1}%' "
+ "or T_customerInf.PinYinCode like '%{2}%' "
+ "or T_bargains.mtype like '%{3}%' "
+ "or T_bargains.Manufactcode like '%{4}%' "
+"or T_bargains.bargid like '%{5}%' ";
strSql = string.Format(strSql, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName);
DataTable dt = (new SqlDBConnect()).Get_Dt(strSql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = 0;
if (fr.ShowDialog() == DialogResult.OK)
{
DataRow ndr = dtmac.NewRow();
ndr[0] = fr.dr_.Cells["合同系统编号"].Value.ToString().Trim();
ndr[1] = fr.dr_.Cells["合同编号"].Value.ToString().Trim();
ndr[2] = fr.dr_.Cells["机型"].Value.ToString();
ndr[3] = fr.dr_.Cells["机号"].Value.ToString();
//
dtmac.Rows.Add(ndr);
textBox.Text = "";
}
}
}
private void textBox1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
TextBox textBox = sender as TextBox;
string textBoxName = textBox.Text.Trim();
if (textBoxName == "") return;
string strSql = "select T_bargains.sysid as 合同系统编号,"
+"T_bargains.bargid as 合同号,"
+ "T_bargains.custcode as 客户编码,"
+ "T_customerInf.CustName as 客户名称,"
+ "T_bargains.mtype as 机型,"
+ "T_bargains.Manufactcode as 机号,"
+ "T_bargains.StartDate as 起始日期,"
+ "T_bargains.EndDate as 终止日期 "
+ " from T_bargains "
+ "left join T_customerInf on T_bargains.custcode=T_customerInf.custid"
+ " where (T_bargains.Bargstatus='有效') and("
+" T_bargains.custcode like '%{0}%' "
+ "or T_customerInf.CustName like '%{1}%' "
+ "or T_customerInf.PinYinCode like '%{2}%' "
+ "or T_bargains.bargid like '%{3}%' "
+ "or T_bargains.mtype like '%{4}%' "
+ "or T_bargains.Manufactcode like '%{5}%')";
strSql = string.Format(strSql, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName);
DataTable dt = (new SqlDBConnect()).Get_Dt(strSql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = 0;
if (fr.ShowDialog() == DialogResult.OK)
{
string barsysid_ = fr.dr_.Cells["合同系统编号"].Value.ToString().Trim();
string mt_ = fr.dr_.Cells["机型"].Value.ToString().Trim();
string mc_=fr.dr_.Cells["机号"].Value.ToString().Trim();
//重置变量
this.dgv_fee.DataSource = null;
this.lb_tot.Text = "";
this.BarSysId = "";
this.Bdid = "";
//判断是否是捆绑中的合同编号
this.Bdid = get_bdid(barsysid_);
this.BarSysId = barsysid_;
if (this.Bdid != "")
{
this.JSLX = "捆绑";
string sql1_ = "select Manufactcode from T_BargBindMacs where Bdid='" + this.Bdid + "'";
string ms = "";
DataTable dt1 = (new SqlDBConnect()).Get_Dt(sql1_);
for (int i = 0; i < dt1.Rows.Count; i++)
{
if (ms == "")
ms = dt1.Rows[i]["Manufactcode"].ToString().Trim();
else
ms = ms + "," + dt1.Rows[i]["Manufactcode"].ToString().Trim();
}
this.tb_id.Text = this.Bdid;
this.tb_ms.Text = ms;
this.lb_lx.Text = "（多机捆绑结算）";
this.label2.Text = "结算绑定号";
produce_cz_lst(this.JSLX, this.Bdid);
}
else
{
this.JSLX = "单机";
this.lb_lx.Text = "（单机结算）";
this.tb_id.Text = this.BarSysId;
this.tb_ms.Text = mc_;
this.label2.Text = "结算合同号";
produce_cz_lst(this.JSLX, this.BarSysId);
}
//判断抄张是否完成
//显示预收费
show_prepay();
}
}
}
private void t_CustCode_KeyDown(object sender, KeyEventArgs e)
{
//根据Custid(客户ID),CustName(客户名),PinYinCode(拼音码),
//mtype，Manufactcode(机号)来模糊查询
if (e.KeyCode == Keys.Enter)
{
//如果有抄张记录了,则不允许改
if (this.Type == "edit")
{
string sql_ = "select * from T_RecordCopy where barsysid=" + this.BargSysId;
if ((new DBUtil()).yn_exist_data(sql_))
{
MessageBox.Show("该合同已有对应的抄张记录,不允许修改客户信息!");
return;
}
}
//
string BaseSql = "select T_CustomerMac.Sysid as sysid,"
+ "T_CustomerInf.CustID as 客户编码,"
+ "T_CustomerInf.CustName as 客户名称,"
+ "T_CustomerMac.Mdepart as 机器地址,"
+ "T_CustomerMac.Mtype as 机型,"
+ "T_CustomerMac.Manufactcode as 机号"
+ " from T_CustomerMac "
+ " left Join T_CustomerInf on T_CustomerInf.CustID=T_CustomerMac.CustID";
TextBox textBox = sender as TextBox;
string textBoxName = textBox.Text.Trim();
if (textBoxName == "")
{
return;
}
string swhere = " where T_CustomerInf.CustID like '%{0}%'"
+ " or CustName like '%{1}%' or PinYinCode like '%{2}%'"
+ " or (T_CustomerMac.sysid in "
+ "(select sysid from T_CustomerMac where "
+ " T_CustomerMac.Manufactcode like '%{3}%' "
+ " or T_CustomerMac.mtype like '%{4}%'))";
swhere = string.Format(swhere, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName);
//显示列表
DataTable dt = (new SqlDBConnect()).Get_Dt(BaseSql + swhere);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = 0;
if (fr.ShowDialog() == DialogResult.OK)
{
if (fr.dr_.Cells["sysid"].Value == null)
{
return;
}
if (fr.dr_.Cells["sysid"].Value.ToString().Trim() == "")
{
return;
}
this.s_CustCode.Text = fr.dr_.Cells["客户编码"].Value.ToString();
this.t_CustCode.Text = fr.dr_.Cells["机器地址"].Value.ToString();
this.n_MachineId.Text = fr.dr_.Cells["sysid"].Value.ToString();
this.s_mtype.Text = fr.dr_.Cells["机型"].Value.ToString();
this.s_Manufactcode.Text = fr.dr_.Cells["机号"].Value.ToString();
}
}
}
private void s_Models_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
TextBox textBox = sender as TextBox;
string textBoxName = textBox.Text.Trim();
if (textBoxName == "") return;
string BasicSql = "select SysID, ModelName as 机型名,"
+ "ProdCtgrID as 分类,"
+ "ModelType as 机器类别,"
+ "ModelName1 as 机型别名1,ModelName2 as 机型别名2,"
+ "ModelGrade as 机器等级,"
+ "Modelbrand as 品牌,"
+ "Ndxs as 难度系数 "
+ "from T_Model";
string swhere = " where ModelName like '%{0}%'" +
"or ModelName1 like '%{1}%'" +
"or ModelName2 like '%{2}%'" +
"or ProdCtgrID like '%{3}%'" +
"or ModelType like '%{4}%'" +
"or Modelbrand like '%{5}%'" +
"or ModelGrade like '%{6}%'";
swhere = string.Format(swhere, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName);
//显示列表
DataTable dt = (new SqlDBConnect()).Get_Dt(BasicSql + swhere);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = 0;
if (fr.ShowDialog() == DialogResult.OK)
{
if (fr.dr_.Cells["sysid"].Value == null) return;
if (fr.dr_.Cells["sysid"].Value.ToString().Trim() == "") return;
this.s_Models.Text = fr.dr_.Cells["机型名"].Value.ToString().Trim();
}
}
}
protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
{
if ((keyData == Keys.Enter) && (dataGridView2.Columns[dataGridView2.CurrentCell.ColumnIndex].HeaderText == "物料编号"))
{
//先结束编辑状态,否则获取不了当前输入的值
this.dataGridView2.EndEdit();
string LikeNameorID = "";
int currentRowIndex = dataGridView2.SelectedCells[0].RowIndex;
//获取当前单元格的值
LikeNameorID = dataGridView2.CurrentCell.Value.ToString();
string sql = "select Matid 物料编号,MatName 物料名称 from T_MatInf " +
"where Matid like '%" + LikeNameorID + "%' or MatName like '%" + LikeNameorID + "%'";
DataTable dt = (new SqlDBConnect()).Get_Dt(sql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = -1;
if (fr.ShowDialog() == DialogResult.OK)
{
dataGridView2.Rows[currentRowIndex].Cells["配套编号"].Value = this.dataGridView1.SelectedRows[0].Cells["sysid"].Value.ToString();
dataGridView2.Rows[currentRowIndex].Cells["物料编号"].Value = fr.dr_.Cells["物料编号"].Value.ToString();
dataGridView2.Rows[currentRowIndex].Cells["物料名称"].Value = fr.dr_.Cells["物料名称"].Value.ToString();
}
}
//继续原来base.ProcessCmdKey中的处理
return base.ProcessCmdKey(ref msg, keyData);
}
private void button3_Click(object sender, EventArgs e)
{
string swhere = ReturnWhere_Get_machines();
string strSql = "select distinct T_StoreHouse.shname as 所属公司,"
+ "T_Invoice.ITname as 发票类型,"
+ "Ititle as 发票抬头,"
+ "matid as 发票内容,"
+ "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 in "
+ "(select MachineId from t_bargains "
+ swhere + ")";
DataTable dt = (new SqlDBConnect()).Get_Dt(strSql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = -1;
if (fr.ShowDialog() == DialogResult.OK)
{
this.t_kpcorp.Text = fr.dr_.Cells["所属公司"].Value.ToString();
this.t_Itype.Text = fr.dr_.Cells["发票类型"].Value.ToString();
this.t_Itype_SelectedIndexChanged(null,null);
this.t_kpcorp_SelectedIndexChanged(null, null);
this.s_Ititle.Text = fr.dr_.Cells["发票抬头"].Value.ToString();
this.s_Icontent.Text = fr.dr_.Cells["发票内容"].Value.ToString();
this.s_Memo.Text = fr.dr_.Cells["备注"].Value.ToString();
}
}
/// <summary>
/// 用户模糊查询
/// </summary>
private void ElsePerson(TextBox textBox)
{
string textBoxName = textBox.Text.Trim();
if (textBoxName == "") return;
string Strsql = "select UserId 用户编码,UserName 用户名称, " +
" UserNameZJM 助记码,MobileTel 移动电话 " +
" from T_Users where UserId like '%{0}%' " +
" or UserName like '%{1}%'or UserNameZJM like '%{2}%' " +
" or MobileTel like '%{3}%'";
Strsql = string.Format(Strsql, textBoxName, textBoxName, textBoxName, textBoxName);
DataTable dt = (new SqlDBConnect()).Get_Dt(Strsql);
FilterInfo_ReturnGrid fr = new FilterInfo_ReturnGrid(dt);
fr.unVisible_Column_index_ = -1;//不隐藏
if (fr.ShowDialog() == DialogResult.OK)
{
this.Elseperson = fr.dr_.Cells["用户名称"].Value.ToString().Trim();
}
}
