110,571
社区成员
发帖
与我相关
我的任务
分享
private void dgPrint_CellEnter(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 3)
{
string jz;
if (cmbJzCode.SelectedIndex != -1)
{
jz = cmbJzCode.Text;
int rowIndex = e.RowIndex;
conn.Open();
string sql = "select ZBDFr,ZBDSt,ZBDLen from table_Jz where code='" + jz + "'";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
da.Fill(dt);
conn.Close();
string ZBDFr = dt.Rows[0][0].ToString();
string ZBDSt = dt.Rows[0][1].ToString();
string ZBDLen = dt.Rows[0][2].ToString();
if (ZBDFr == "Cell码")
{
if (dgPrint[rowIndex, 2] != null)
{
dgPrint.CurrentCell.Value = dgPrint[rowIndex, 2].Value.ToString().Trim().Substring(Convert.ToInt16(ZBDSt) - 1, Convert.ToInt16(ZBDLen));
}
else System.Windows.MessageBox.Show("Cell码为空,请先输入!", "状态提示");
}
}
else
System.Windows.MessageBox.Show("请先选择Jz信息!", "状态提示");
}
}