public bool Execute()
{
try
{
int Num = this._content.Length % 31;
if (Num == 0)
{
Pro_IndateBase_MjSec_Mod info = IndateBase();
string Result = HouseAndUser_Dal.Exec(info);
if (Result != "0")
{
MyLibrary.Log.Debug(Name + "出错：" + Result + " 原始代码:" + this.OriginalCode);
}
}
else
{
MyLibrary.Log.Debug(Name + "长度出错；" + " 原始代码：" + this.OriginalCode);
}
}
catch (Exception ex)
{
MyLibrary.Log.Error(Name + "出错：" + ex.Message + " 原始代码:" + OriginalCode);
}
return(true);
}
public static void Exec(Pro_IndateBase_MjSec_Mod info, out ushort resultNo, out string reason)
{
Database db = DataConnect.GetConnect;
DbCommand cmd = db.GetStoredProcCommand("pro_indatebase_mjsec");
db.AddInParameter(cmd, ":pi_bigtype", DbType.String, info.pi_bigtype);
db.AddInParameter(cmd, ":pi_devicetime", DbType.Date, info.pi_devicetime);
db.AddInParameter(cmd, ":pi_devicetype", DbType.String, info.pi_devicetype);
db.AddInParameter(cmd, ":pi_devicecode", DbType.String, info.pi_devicecode);
db.AddInParameter(cmd, ":pi_protocoltype", DbType.String, info.pi_protocoltype);
db.AddInParameter(cmd, ":pi_lordcardtype", DbType.String, info.pi_lordcardtype);
db.AddInParameter(cmd, ":pi_lordcardid", DbType.String, info.pi_lordcardid);
db.AddInParameter(cmd, ":pi_lordidentitycard", DbType.String, info.pi_lordidentitycard);
db.AddInParameter(cmd, ":pi_lordidentitycardid", DbType.String, info.pi_lordidentitycardid);
db.AddInParameter(cmd, ":pi_cardtype", DbType.String, info.pi_cardtype);
db.AddInParameter(cmd, ":pi_cardid", DbType.String, info.pi_cardid);
db.AddInParameter(cmd, ":pi_identitycard", DbType.String, info.pi_identitycard);
db.AddInParameter(cmd, ":pi_identitycardid", DbType.String, info.pi_identitycardid);
db.AddInParameter(cmd, ":pi_houseno", DbType.String, info.pi_houseno);
db.AddInParameter(cmd, ":pi_roomno", DbType.String, info.pi_roomno);
db.AddInParameter(cmd, ":pi_param1", DbType.String, info.pi_param1);
db.AddInParameter(cmd, ":pi_param2", DbType.String, info.pi_param2);
db.AddInParameter(cmd, ":pi_param3", DbType.String, info.pi_param3);
db.AddInParameter(cmd, ":pi_param4", DbType.String, info.pi_param4);
db.AddInParameter(cmd, ":pi_param5", DbType.String, info.pi_param5);
db.AddInParameter(cmd, ":pi_stationno", DbType.String, info.pi_stationno);
db.AddInParameter(cmd, ":pi_version", DbType.String, info.pi_version);
db.AddInParameter(cmd, ":pi_relayno", DbType.String, info.pi_relayno);
db.AddInParameter(cmd, ":pi_servicetime", DbType.Date, info.pi_servicetime);
db.AddOutParameter(cmd, ":po_resultnum", DbType.String, 256);
db.AddOutParameter(cmd, ":po_reason", DbType.String, 256);
db.ExecuteNonQuery(cmd);
resultNo = Convert.ToUInt16(db.GetParameterValue(cmd, ":po_resultnum"));
reason = db.GetParameterValue(cmd, ":po_reason").ToString();
}
private Pro_IndateBase_MjSec_Mod IndateBase()
{
Pro_IndateBase_MjSec_Mod info = new Pro_IndateBase_MjSec_Mod();
info.pi_bigtype = "104";
info.pi_devicecode = this.StationId.ToString();
info.pi_devicetime = DateTime.Now;
info.pi_param1 = this._content.Length.ToString();
info.pi_param2 = this.OriginalCode;
return(info);
}
public static string Exec(Pro_IndateBase_MjSec_Mod info)
{
ushort resultnum;
string reason;
Pro_IndateBase_MjSec_Dal.Exec(info, out resultnum, out reason);
if (resultnum == 0)
{
return("0");
}
else
{
return(reason);
}
}
