private void toolDeleteCTextBox_Click(object sender, EventArgs e)
{
if (MessageBox.Show("确定要删除吗？", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
if (ControlId != 0) //旧的控件
{
CommClass cc = new CommClass();
DataOperate dataOper = new DataOperate();
try
{
if (cc.IsExistConstraint("tb_BillTemplate", ControlId.ToString())) //对应的子表tb_BillText已生成外键数据，先删除外键记录
{
if (MessageBox.Show("该输入框已生成快递单数据，若继续执行将删除与之相关的数据，是否继续执行？", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.No)
{
return; //停止执行
}
}
if (dataOper.ExecDataBySql("Delete From tb_BillTemplate Where ControlId = '" + ControlId + "'") == 0) //从模板表中删除该控件对应的记录
{
MessageBox.Show("删除失败！", "软件提示");
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
return;
}
}
this.Dispose();
MessageBox.Show("删除成功！", "软件提示");
}
}
public ActionResult Import(string id)
{
try
{
HttpFileCollectionBase files = Request.Files;
DataTable dt = CommClass.CreateTB("UserName:System.String,UserID:System.String,UserPwd:System.String,UserPermission:System.String,UserState:System.Int32,Remark:System.String");
string str = NPOIExcel.ImportExcelFile(files, dt, 1, 0);
List <M_User> lstUser = new JavaScriptSerializer().Deserialize <List <M_User> >(str);
bool iSucc = SQLDBHelperClient.CreateUser().Add(lstUser);
if (iSucc)
{
ViewBag.Succ = "1";
ViewBag.Msg = "数据添加成功!";
return(View());
}
else
{
ViewBag.Succ = "0";
ViewBag.Msg = "数据添加失败!";
return(View());
}
}
catch (Exception ex)
{
ViewBag.Succ = "0";
ViewBag.Msg = "数据添加失败!";
return(View());
}
}
public UsersEF Login(string UserName, string Password)
{
UsersEF vResult = new UsersEF();
UsersEF vUserEF = new UsersEF();
vUserEF.UserName = UserName;
vUserEF.Password = Password;
vUserEF.IsUse = true;
DataTable vTable = m_BasicDBClass.SelectRecords(vUserEF);
if (vTable.Rows.Count > 0)
{
CommClass.ConvertDataRowToStruct(ref vUserEF, vTable.Rows[0]);
if (vUserEF.LateLoginTime == null || (DateTime.Now - vUserEF.LateLoginTime).Value.TotalSeconds >= 60 || vUserEF.Online == false)
{
vUserEF.LateLoginTime = DateTime.Now;
vUserEF.Token = DateTime.Now.ToString("mmssyyyyMMddHH");
if (m_BasicDBClass.UpdateRecord(vUserEF))
{
UserOperateLog vUserOperateLog = new UserOperateLog();
vUserOperateLog.WriteLog(vUserEF.ID.Value, vUserEF.UserName, "用户登录");
updateOnlineState(vUserEF.ID.Value, true);
vResult = vUserEF;
}
}
else
{
vResult.ID = -1;
}
}
vTable.Clear();
vTable.Dispose();
return(vResult);
}
private void InitializeStatusBar()
{
dv = new BoardComm();
cc = dv;
ControllerObj.GetCommObject(ref cc);
dv = (BoardComm)cc;
dv.CommEvents += new CommEventHandler(CommCallback);
}
public void SaveSwitchTable(DataTable SwitchTable)
{
foreach (DataRow vTempRow in SwitchTable.Rows)
{
PowerSwithConfigEFModel vModel = new PowerSwithConfigEFModel();
CommClass.ConvertDataRowToStruct(ref vModel, vTempRow);
switch (vTempRow.RowState)
{
case DataRowState.Added:
m_BasicDBClass.InsertRecord(vModel);
break;
case DataRowState.Deleted:
m_BasicDBClass.DeleteRecordByPrimaryKey <PowerSwithConfigEFModel>(vModel.ID);
break;
case DataRowState.Modified:
m_BasicDBClass.UpdateRecord(vModel);
break;
}
}
}
public HomeController(ILogger <HomeController> logger)
{
_logger = logger;
_crudeCommLayer = new CommClass();
}
private void toolSetProperty_Click(object sender, EventArgs e)
{
CommClass cc = new CommClass();
cc.ShowDialogForm(typeof(FormSetProperty), this, FormParent);
}
public bool Update(int ID, int GanTingID, string GanTingMC, string GanTingLX,
string Led1IP, int LED1Gao, int LED1Kuan, string Led2IP, int Led2Gao, int Led2Kuan,
string DianYuanID1, string DianYuanID2,
DataTable SwitchInfoTable1, DataTable SwitchInfoTable2,
ref string OutInfo)
{
bool vResult = false;
WatchHouseConfigEFModel vSelectRecord = m_BasicDBClass.SelectRecordByPrimaryKeyEx <WatchHouseConfigEFModel>(ID);
string vOldDianYuanID1 = vSelectRecord.DianYuan1ID;
string vOldDianYuanID2 = vSelectRecord.DianYuan2ID;
WatchHouseConfigEFModel vWatchHouseConfigEFModel = new WatchHouseConfigEFModel()
{
GangTingID = GanTingID,
GangTingMC = GanTingMC,
GangTingLX = GanTingLX,
GuanGaoPing1IP = Led1IP,
GuanGao1Gao = LED1Gao,
GuanGao1Kuang = LED1Kuan,
GuanGaoPing2IP = Led2IP,
GuanGao2Gao = Led2Gao,
GuanGao2Kuang = Led2Kuan,
DianYuan1ID = DianYuanID1,
DianYuan2ID = DianYuanID2,
ID = ID,
OrderID = convertWatchHouseLXToOrderID(GanTingLX)
};
m_BasicDBClass.TransactionBegin();
if (vResult = m_BasicDBClass.UpdateRecord(vWatchHouseConfigEFModel))
{
if (DianYuanID1 != vOldDianYuanID1)
{
m_BasicDBClass.DeleteRecordCustom <PowerSwithConfigEFModel>(string.Format("DianYuanID='{0}'", vOldDianYuanID1));
if (SwitchInfoTable1 != null)
{
foreach (DataRow vTempSwitch in SwitchInfoTable1.Rows)
{
PowerSwithConfigEFModel vModel = new PowerSwithConfigEFModel();
vModel.DianYuanID = DianYuanID1;
CommClass.ConvertDataRowToStruct(ref vModel, vTempSwitch);
vResult = m_BasicDBClass.InsertRecord(vModel) > 0 ? true : false;
if (!vResult)
{
m_BasicDBClass.TransactionRollback();
break;
}
}
}
}
else if (SwitchInfoTable1 != null)
{
foreach (DataRow vTempSwitch in SwitchInfoTable1.Rows)
{
PowerSwithConfigEFModel vModel = new PowerSwithConfigEFModel();
vModel.DianYuanID = DianYuanID1;
switch (vTempSwitch.RowState)
{
case DataRowState.Added:
CommClass.ConvertDataRowToStruct(ref vModel, vTempSwitch);
vResult = m_BasicDBClass.InsertRecord(vModel) > 0 ? true : false;
break;
case DataRowState.Deleted:
vTempSwitch.RejectChanges();
int vID = (int)vTempSwitch["ID"];
vResult = m_BasicDBClass.DeleteRecordByPrimaryKey <PowerSwithConfigEFModel>(vID);
vTempSwitch.Delete();
break;
case DataRowState.Modified:
CommClass.ConvertDataRowToStruct(ref vModel, vTempSwitch);
vResult = m_BasicDBClass.UpdateRecord(vModel);
break;
}
if (!vResult)
{
m_BasicDBClass.TransactionRollback();
break;
}
}
}
if (DianYuanID2 != vOldDianYuanID2)
{
m_BasicDBClass.DeleteRecordCustom <PowerSwithConfigEFModel>(string.Format("DianYuanID='{0}'", vOldDianYuanID2));
foreach (DataRow vTempSwitch in SwitchInfoTable2.Rows)
{
PowerSwithConfigEFModel vModel = new PowerSwithConfigEFModel();
vModel.DianYuanID = DianYuanID1;
CommClass.ConvertDataRowToStruct(ref vModel, vTempSwitch);
vResult = m_BasicDBClass.InsertRecord(vModel) > 0 ? true : false;
if (!vResult)
{
m_BasicDBClass.TransactionRollback();
break;
}
}
}
else if (SwitchInfoTable2 != null)
{
foreach (DataRow vTempSwitch in SwitchInfoTable2.Rows)
{
PowerSwithConfigEFModel vModel = new PowerSwithConfigEFModel();
vModel.DianYuanID = DianYuanID1;
CommClass.ConvertDataRowToStruct(ref vModel, vTempSwitch);
switch (vTempSwitch.RowState)
{
case DataRowState.Added:
vResult = m_BasicDBClass.InsertRecord(vModel) > 0 ? true : false;
break;
case DataRowState.Deleted:
vResult = m_BasicDBClass.DeleteRecordByPrimaryKey <PowerSwithConfigEFModel>(vModel.ID);
break;
case DataRowState.Modified:
vResult = m_BasicDBClass.UpdateRecord(vModel);
break;
}
if (!vResult)
{
m_BasicDBClass.TransactionRollback();
break;
}
}
}
if (vResult)
{
m_BasicDBClass.TransactionCommit();
if (SwitchInfoTable1 != null)
{
SwitchInfoTable1.AcceptChanges();
}
if (SwitchInfoTable2 != null)
{
SwitchInfoTable2.AcceptChanges();
}
}
else
{
OutInfo = "修改岗亭数据失败";
}
}
return(vResult);
}
public bool Add(int GanTingID, string GanTingMC, string GanTingLX,
string Led1IP, int LED1Gao, int LED1Kuan, string Led2IP, int LED2Gao, int LED2Kuan,
string DianYuanID1, string DianYuanID2, DataTable SwitchInfoTable1, DataTable SwitchInfoTable2,
ref string OutInfo)
{
bool vResult = false;
if (!findGanTing(GanTingID, DianYuanID1))
{
m_BasicDBClass.TransactionBegin();
WatchHouseConfigEFModel vWatchHouseConfigEFModel = new WatchHouseConfigEFModel()
{
GangTingID = GanTingID,
GangTingMC = GanTingMC,
GangTingLX = GanTingLX,
GuanGaoPing1IP = Led1IP,
GuanGao1Gao = LED1Gao,
GuanGao1Kuang = LED1Kuan,
GuanGaoPing2IP = Led2IP,
GuanGao2Gao = LED2Gao,
GuanGao2Kuang = LED2Kuan,
DianYuan1ID = DianYuanID1,
DianYuan2ID = DianYuanID2,
ShouFeiZhangID = 1,
OrderID = convertWatchHouseLXToOrderID(GanTingLX)
};
vResult = m_BasicDBClass.InsertRecord(vWatchHouseConfigEFModel) > 0;
//开关1
if (vResult && SwitchInfoTable1 != null)
{
foreach (DataRow vTempSwitch in SwitchInfoTable1.Rows)
{
PowerSwithConfigEFModel vModel = new PowerSwithConfigEFModel();
vModel.DianYuanID = DianYuanID1;
CommClass.ConvertDataRowToStruct(ref vModel, vTempSwitch);
switch (vTempSwitch.RowState)
{
case DataRowState.Added:
vResult = m_BasicDBClass.InsertRecord(vModel) > 0 ? true : false;
break;
case DataRowState.Deleted:
vResult = m_BasicDBClass.DeleteRecordByPrimaryKey <PowerSwithConfigEFModel>(vModel.ID);
break;
case DataRowState.Modified:
vResult = m_BasicDBClass.UpdateRecord(vModel);
break;
}
if (!vResult)
{
break;
}
}
}
//开关2
if (vResult && SwitchInfoTable2 != null)
{
foreach (DataRow vTempSwitch in SwitchInfoTable2.Rows)
{
PowerSwithConfigEFModel vModel = new PowerSwithConfigEFModel();
vModel.DianYuanID = DianYuanID1;
CommClass.ConvertDataRowToStruct(ref vModel, vTempSwitch);
switch (vTempSwitch.RowState)
{
case DataRowState.Added:
vResult = m_BasicDBClass.InsertRecord(vModel) > 0 ? true : false;
break;
case DataRowState.Deleted:
vResult = m_BasicDBClass.DeleteRecordByPrimaryKey <PowerSwithConfigEFModel>(vModel.ID);
break;
case DataRowState.Modified:
vResult = m_BasicDBClass.UpdateRecord(vModel);
break;
}
if (!vResult)
{
break;
}
}
}
if (vResult)
{
m_BasicDBClass.TransactionCommit();
if (SwitchInfoTable1 != null)
{
SwitchInfoTable1.AcceptChanges();
}
}
else
{
m_BasicDBClass.TransactionRollback();
OutInfo = "增加岗亭数据失败";
}
}
else
{
OutInfo = "存在相同编号的岗亭或者电源";
}
return(vResult);
}
