/// <summary>
/// 减锁格口
/// </summary>
/// <param name="moNo"></param>
/// <param name="pbCrtNo"></param>
/// <returns></returns>
public bool freeMouthArkState(string moNo, string pbCrtNo)
{
try
{
int result = sqliteU.updateData("update EBOX_MOUTH_ARK set TF_BUZSTATUS = 1,TF_UPDATEDATE = datetime('now','localtime') where MO_NO = " + moNo + " and TF_DELETEFLAG = 0");
EboxMouthArk eboxMouthArk = sqliteU.getEboxMouthArk("where MO_NO = " + moNo);
LogHelper.Log("格口状态(格口原始状态为:2)：MoNo = " + eboxMouthArk.MONO + ",TfBuz = " + eboxMouthArk.TFBUZSTATUS + ",Id = " + eboxMouthArk.ID);
if (result == 1)
{
LogHelper.Log("格口减锁成功！");
return(true);
}
else
{
LogHelper.Log("更新格口状态失败,格口减锁失败！");
return(false);
}
}
catch (Exception ex)
{
LogHelper.Log("更新格口状态失败", ex);
return(false);
}
}
/// <summary>
/// 锁格口
/// </summary>
/// <param name="moNo"></param>
/// <param name="pbId"></param>
/// <returns></returns>
public bool lockMouthArkState(string moNo, int pbId)
{
try
{
var ark = sqliteU.getEboxMouthArk("where TF_DELETEFLAG = 0 and MO_NO = " + moNo + " and MO_PBID = " + pbId);
if (null != ark)
{
sqliteU.updateData("update EBOX_MOUTH_ARK set TF_BUZSTATUS = 2 " + ",TF_UPDATEDATE = datetime('now','localtime') where TF_DELETEFLAG = 0 and MO_NO = " + moNo + " and MO_PBID = " + pbId);
LogHelper.Log("格口锁成功！");
EboxMouthArk eboxMouthArk = sqliteU.getEboxMouthArk("where MO_NO = " + moNo);
LogHelper.Log("格口状态：MoNo = " + eboxMouthArk.MONO + ",TfBuz = " + eboxMouthArk.TFBUZSTATUS + ",Id = " + eboxMouthArk.ID);
return(true);
}
return(false);
}
catch (Exception ex)
{
LogHelper.Log("更新格口状态失败", ex);
return(false);
}
}
public bool modifyMouthArkInfo(int id, int typeId, string no, int state)
{
//var sql1 = @"update ebox_mouth_ark set TF_BUZSTATUS={0},MO_NO={1},MO_TYPEID={2} where ID={3} and TF_DELETEFLAG=0";
//db.ExecuteCommand(sql1, state, no, typeId, id);
var ark = sqliteU.getEboxMouthArk("where TF_DELETEFLAG =0 and ID = " + id);
if (null != ark)
{
int result = sqliteU.updateData("update EBOX_MOUTH_ARK set TF_BUZSTATUS =" + state + ",TF_UPDATEDATE = datetime('now','localtime') where TF_DELETEFLAG = 0 and ID = " + id);
if (result == 1)
{
LogHelper.Log("格口更新成功！");
EboxMouthArk eboxMouthArk = sqliteU.getEboxMouthArk("where ID = " + id);
LogHelper.Log("格口状态：MoNo = " + eboxMouthArk.MONO + ",TfBuz = " + eboxMouthArk.TFBUZSTATUS + ",Id = " + eboxMouthArk.ID);
return(true);
}
else
{
LogHelper.Log("格口更新失败！");
return(false);
}
}
return(false);
}
