private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (dgv.CurrentRow == null || dgv.CurrentRow.Index < 0)
{
FrmTips.ShowTipsError(AppHelper.MainForm, "未选中任何行！", ContentAlignment.MiddleCenter, 1000);
return;
}
ConstantType entity = CGridHelper.GetCurrentData <ConstantType>(dgv);
ConstantApi constantApi = new ConstantApi();
var resp = constantApi.DeleteConstantType(entity.ID);
//string sql = "DELETE ConstantType WHERE ID = @ID";
//Hashtable hashtable = new Hashtable();
//hashtable.Add("ID", entity.ID);
//if (_mssqlHelper.ExcuteNonQuery(sql, hashtable) > 0)
//{
if (resp.Code == 1)
{
FrmTips.ShowTipsSuccess(AppHelper.MainForm, "删除成功！", ContentAlignment.MiddleCenter, 1000);
CGridHelper.DeleteRow(dgv);
}
else
{
FrmTips.ShowTipsError(AppHelper.MainForm, "删除失败！" + resp.Message, ContentAlignment.MiddleCenter, 1000);
}
}
catch (Exception ex)
{
FrmTips.ShowTipsError(AppHelper.MainForm, "删除异常！" + ex.Message, ContentAlignment.MiddleCenter, 3000);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (dgv.CurrentRow == null || dgv.CurrentRow.Index < 0)
{
FrmTips.ShowTipsError(AppHelper.MainForm, "未选中任何行！", ContentAlignment.MiddleCenter, 1000);
return;
}
Menus entity = CGridHelper.GetCurrentData <Menus>(dgv);
MenuApi constantApi = new MenuApi();
var resp = constantApi.DeleteMenu(entity.Id);
if (resp.Code == 1)
{
FrmTips.ShowTipsSuccess(AppHelper.MainForm, "删除成功！", ContentAlignment.MiddleCenter, 1000);
CGridHelper.DeleteRow(dgv);
}
else
{
FrmTips.ShowTipsError(AppHelper.MainForm, "删除失败！" + resp.Message, ContentAlignment.MiddleCenter, 1000);
}
}
catch (Exception ex)
{
FrmTips.ShowTipsError(AppHelper.MainForm, "删除异常！" + ex.Message, ContentAlignment.MiddleCenter, 3000);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
List <Role> list = null;
ControlHelper.ThreadRunExt(AppHelper.MainForm, () =>
{
var succ = true;
var msg = "";
try
{
ResponseModel responseModel = new ResponseModel();
RbacApi rbac = new RbacApi();
responseModel = rbac.GetRoles();
if (responseModel.Code == 1)
{
if (responseModel.DataCount > 0)
{
list = JsonConvert.DeserializeObject <List <Role> >(responseModel?.Data?.ToString());
ControlHelper.ThreadInvokerControl(AppHelper.MainForm, () =>
{
if (list != null)
{
CGridHelper.ClearGrid(dgv);
CGridHelper.FillGrid <Role>(dgv, list);
}
});
}
else
{
succ = false;
msg = "查询数据为空!";
}
}
else
{
succ = false;
msg = responseModel?.Message;
}
}
catch (Exception ex)
{
succ = false;
msg = ex.Message;
}
if (!succ)
{
ControlHelper.ThreadInvokerControl(AppHelper.MainForm, () =>
{
FrmTips.ShowTips(AppHelper.MainForm, msg, 2000, true, ContentAlignment.MiddleCenter, null, TipsSizeMode.Medium, new Size(300, 100), TipsState.Error);
});
}
}, null, AppHelper.MainForm, true, "正在查询……", 200);
}
private void btnModify_Click(object sender, EventArgs e)
{
try
{
if (dgv.CurrentRow == null || dgv.CurrentRow.Index < 0)
{
FrmTips.ShowTipsError(AppHelper.MainForm, "未选中任何行！", ContentAlignment.MiddleCenter, 1000);
return;
}
Menus entity = CGridHelper.GetCurrentData <Menus>(dgv);
MenuOptForm form = new MenuOptForm(entity);
form.ShowDialog();
}
catch (Exception ex)
{
FrmTips.ShowTipsError(AppHelper.MainForm, "修改异常！" + ex.Message, ContentAlignment.MiddleCenter, 3000);
}
}
//获取列表
public void ReadCarList()
{
// ZJJYXM HPHM ZZL jclsh jyzt jyxm sbkkh ycybh
string sql = "SELECT TOP 100 YTH_CLLSXXB.ZJJYXM,YTH_CLJCXXB.HPHM,YTH_CLJCXXB.ZZL," +
"YTH_CLLSXXB.jclsh,YTH_CLLSXXB.jyzt,YTH_CLLSXXB.jyxm,YTH_CLLSXXB.sbkkh,YTH_CLLSXXB.ycybh FROM " +
"YTH_CLJCXXB INNER JOIN YTH_CLLSXXB " +
"ON YTH_CLJCXXB.jclsh = YTH_CLLSXXB.jclsh WHERE 1=1 " +
" AND (YTH_CLLSXXB.jyzt <= 7 or YTH_CLLSXXB.zjzt = 1)" +
" AND mtcbj = 1 AND YTH_CLLSXXB.ZJJYXM IS NOT NULL AND YTH_CLLSXXB.ZJJYXM <> '' ";
if (!string.IsNullOrEmpty(txtSearchHphm.Text.Trim()))
{
sql += $" AND YTH_CLJCXXB.HPHM LIKE '%{txtSearchHphm.Text.Trim()}%'";
}
sql += " ORDER BY YTH_CLLSXXB.dlrq";
List <VehilceQueue> vehilceQueues = MssqlHelper.GetInstance().QueryList <VehilceQueue>(sql, null).ToList();
CGridHelper.FillGrid <VehilceQueue>(dgvVehicle, vehilceQueues);
}
//开始测试
private void StartTest()
{
VehilceQueue vehilceQueue = CGridHelper.GetCurrentData <VehilceQueue>(dgvVehicle);
if (vehilceQueue != null)
{
TaskQueue.ClearQueue();
TaskQueue.WaitResult = false;
string sql = $"SELECT * FROM YTH_V_CLLSXXB WHERE JCLSH = @JCLSH ";
Hashtable paraHashtable = new Hashtable();
paraHashtable.Add("JCLSH", vehilceQueue.jclsh);
YTH_V_CLLSXXB cllsxxb = MssqlHelper.GetInstance().Query <YTH_V_CLLSXXB>(sql, paraHashtable);
TaskQueue.JCLSH = vehilceQueue.jclsh;
if (cllsxxb.zjjyxm.ToLower().Contains("hw"))
{
SelectMethodForm selectForm = new SelectMethodForm();
GlobalVar.IsShowForm = true;
selectForm.ShowDialog(this);
GlobalVar.IsShowForm = false;
if (selectForm.DialogResult == DialogResult.OK)
{
string jyxm = selectForm.GetMethod();
if ("15".Equals(jyxm))
{
GlobalVar.IsShowForm = true;
AlterStandardForm alterStandardForm = new AlterStandardForm();
alterStandardForm.ShowDialog(this);
GlobalVar.IsShowForm = false;
}
if (!string.IsNullOrEmpty(jyxm))
{
TaskQueue.AddTask(CreateTxt(cllsxxb, jyxm));
}
}
}
if (cllsxxb.zjjyxm.ToLower().Contains("nj") || cllsxxb.zjjyxm.ToLower().Contains("yh") || cllsxxb.zjjyxm.ToLower().Contains("s1"))
{
TaskQueue.AddTask(CreateTxt(cllsxxb, "40", cllsxxb.zjjyxm.ToLower().Contains("nj"), cllsxxb.zjjyxm.ToLower().Contains("yh"), cllsxxb.zjjyxm.ToLower().Contains("s1")));
}
}
}
private void btnModify_Click(object sender, EventArgs e)
{
try
{
if (dgv.CurrentRow == null || dgv.CurrentRow.Index < 0)
{
FrmTips.ShowTipsError(AppHelper.MainForm, "未选中任何行！", ContentAlignment.MiddleCenter, 1000);
return;
}
ConstantType entity = CGridHelper.GetCurrentData <ConstantType>(dgv);
DicTypeOptForm form = new DicTypeOptForm(entity);
if (form.ShowDialog(this) == DialogResult.OK)
{
btnSearch_Click(null, null);
}
}
catch (Exception ex)
{
FrmTips.ShowTipsError(AppHelper.MainForm, "修改异常！" + ex.Message, ContentAlignment.MiddleCenter, 3000);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
List <ConstantDefine> list = null;
ControlHelper.ThreadRunExt(this, () =>
{
try
{
Hashtable hashtable = null;
string sql = "SELECT * FROM NetTypeDefine WHERE 1=1 ";
if (!string.IsNullOrEmpty(txtSeachPlateNo.Text.Trim()))
{
hashtable = new Hashtable();
hashtable.Add("DefineType", "%" + txtSeachPlateNo.Text.Trim() + "%");
sql += " AND DefineType like @DefineType";
}
list = _mssqlHelper.QueryList <ConstantDefine>(sql, hashtable).ToList();
ControlHelper.ThreadInvokerControl(AppHelper.MainForm, () =>
{
if (list != null)
{
CGridHelper.ClearGrid(dgv);
CGridHelper.FillGrid <ConstantDefine>(dgv, list);
}
});
}
catch (Exception ex)
{
ControlHelper.ThreadInvokerControl(AppHelper.MainForm, () =>
{
FrmTips.ShowTips(AppHelper.MainForm, ex.Message, 2000, true, ContentAlignment.MiddleCenter, null, TipsSizeMode.Medium, new Size(300, 100), TipsState.Error);
});
}
}, null, AppHelper.MainForm, true, "正在查询……", 200);
}
private void btnSearch_Click(object sender, EventArgs e)
{
List <ConstantType> list = null;
ControlHelper.ThreadRunExt(AppHelper.MainForm, () =>
{
var succ = true;
var msg = "";
try
{
ResponseModel responseModel = new ResponseModel();
ConstantApi constantApi = new ConstantApi();
responseModel = constantApi.GetConstantTypes();
//Hashtable hashtable = null;
//string sql = "SELECT * FROM ConstantType WHERE 1=1 ";
//if (!string.IsNullOrEmpty(txtSeach.Text.Trim()))
//{
// hashtable = new Hashtable();
// hashtable.Add("TypeName", "%" + txtSeach.Text.Trim() + "%");
// sql += " AND TypeName like @DefineType";
//}
//list = _mssqlHelper.QueryList<ConstantType>(sql, hashtable).ToList();
if (responseModel.Code == 1)
{
if (responseModel.DataCount > 0)
{
list = JsonConvert.DeserializeObject <List <ConstantType> >(responseModel?.Data?.ToString());
ControlHelper.ThreadInvokerControl(AppHelper.MainForm, () =>
{
if (list != null)
{
CGridHelper.ClearGrid(dgv);
CGridHelper.FillGrid <ConstantType>(dgv, list);
}
});
}
else
{
succ = false;
msg = "查询数据为空!";
}
//FrmTips.ShowTips(AppHelper.MainForm, "查询数据为空!", 2000, true, ContentAlignment.MiddleCenter, null, TipsSizeMode.Medium, new Size(300, 100), TipsState.Success);
}
else
{
succ = false;
msg = responseModel?.Message;
}
// FrmTips.ShowTips(AppHelper.MainForm,responseModel?.Message, 2000, true, ContentAlignment.MiddleCenter, null, TipsSizeMode.Medium, new Size(300, 100), TipsState.Error);
}
catch (Exception ex)
{
succ = false;
msg = ex.Message;
}
if (!succ)
{
ControlHelper.ThreadInvokerControl(AppHelper.MainForm, () =>
{
FrmTips.ShowTips(AppHelper.MainForm, msg, 2000, true, ContentAlignment.MiddleCenter, null, TipsSizeMode.Medium, new Size(300, 100), TipsState.Error);
});
}
}, null, AppHelper.MainForm, true, "正在查询……", 200);
}