private void btnImport_Click(object sender, EventArgs e)
{
List <SQLObj> listSql = new List <SQLObj>();
List <string> listField = new List <string>();
string opName = "预约单导入到接待单";
#region 获取信息Id值
string strRId = string.Empty;
foreach (DataGridViewRow dr in dgvRData.Rows)
{
object isCheck = dr.Cells["colCheck"].EditedFormattedValue;
if (isCheck != null && (bool)isCheck)
{
strRId += dr.Cells["reserv_id"].Value.ToString();
listField.Add(dr.Cells["reserv_id"].Value.ToString());
}
}
#endregion
if (listField.Count <= 0)
{
MessageBoxEx.Show("请选择需要导入的数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
return;
}
if (listField.Count > 1)
{
MessageBoxEx.Show("一次仅能导入1条数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
return;
}
uc.strBefore_orderId = strRId; //导入单据的Id值
uc.strOrdersSouse = "1";
uc.BindReserveData();
this.Close();
// strRId = strRId.Substring(0, strRId.Length - 1);
// ImportReserData(listSql, strRId);
// ImportPData(listSql, strId, strReservId);
// ImportMData(listSql, strId, strReservId);
// ImportOData(listSql, strId, strReservId);
// ImportAData(listSql, strId, strReservId);
//// UpdateMaintainNo(listSql, strReservId, strNewMaintainNo);
// if (DBHelper.BatchExeSQLMultiByTrans(opName, listSql))
// {
// MessageBoxEx.Show("导入成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
// this.Close();
// }
}
private void dgvRData_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
uc.strBefore_orderId = dgvRData.Rows[e.RowIndex].Cells["repair_id"].Value.ToString(); //导入单据的Id值
uc.strOrdersSouse = "2";
uc.BindReserveData();
this.Close();
}
}