/// <summary>
///
/// </summary>
/// <param name="strMsg"></param>
/// <param name="LogType">0：信息；1：告警；2错误</param>
private bool WriteRunningLogs(string strMsg, int LogType)
{
Model.DSPTCH_LOG MLog = new CLDC_Dispatcher.Model.DSPTCH_LOG();
MLog.AVR_DEVICE_ID = _EquipNo;
MLog.AVR_LOG = strMsg;
MLog.AVR_TYPE = LogType.ToString();
MLog.AVR_WRITE_TIME = DateTime.Now.ToString(_DateFormateStr);
MLog.TASK_NO = CurTaskNo;
MLog.AVR_SOURCE = "1";
BLL.DSPTCH_LOG BLog = new CLDC_Dispatcher.BLL.DSPTCH_LOG();
BLog.Add(MLog);
return(true);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CLDC_Dispatcher.Model.DSPTCH_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update DSPTCH_LOG set ");
strSql.Append(" TASK_NO = @TASK_NO , ");
strSql.Append(" AVR_DEVICE_ID = @AVR_DEVICE_ID , ");
strSql.Append(" AVR_TYPE = @AVR_TYPE , ");
strSql.Append(" AVR_LOG = @AVR_LOG , ");
strSql.Append(" AVR_WRITE_TIME = @AVR_WRITE_TIME ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@TASK_NO", SqlDbType.Char, 32),
new SqlParameter("@AVR_DEVICE_ID", SqlDbType.Char, 32),
new SqlParameter("@AVR_TYPE", SqlDbType.Char, 8),
new SqlParameter("@AVR_LOG", SqlDbType.Char, 1000),
new SqlParameter("@AVR_WRITE_TIME", SqlDbType.Char, 32)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.TASK_NO;
parameters[2].Value = model.AVR_DEVICE_ID;
parameters[3].Value = model.AVR_TYPE;
parameters[4].Value = model.AVR_LOG;
parameters[5].Value = model.AVR_WRITE_TIME;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CLDC_Dispatcher.Model.DSPTCH_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DSPTCH_LOG(");
strSql.Append("TASK_NO,AVR_DEVICE_ID,AVR_TYPE,AVR_LOG,AVR_WRITE_TIME,AVR_SOURCE");
strSql.Append(") values (");
strSql.Append("@TASK_NO,@AVR_DEVICE_ID,@AVR_TYPE,@AVR_LOG,@AVR_WRITE_TIME,@AVR_SOURCE");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@TASK_NO", SqlDbType.Char, 32),
new SqlParameter("@AVR_DEVICE_ID", SqlDbType.Char, 32),
new SqlParameter("@AVR_TYPE", SqlDbType.Char, 8),
new SqlParameter("@AVR_LOG", SqlDbType.Char, 1000),
new SqlParameter("@AVR_WRITE_TIME", SqlDbType.Char, 32),
new SqlParameter("@AVR_SOURCE", SqlDbType.Char, 8)
};
parameters[0].Value = model.TASK_NO;
parameters[1].Value = model.AVR_DEVICE_ID;
parameters[2].Value = model.AVR_TYPE;
parameters[3].Value = model.AVR_LOG;
parameters[4].Value = model.AVR_WRITE_TIME;
parameters[5].Value = model.AVR_SOURCE;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <CLDC_Dispatcher.Model.DSPTCH_LOG> GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM DSPTCH_LOG ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds == null)
{
return(null);
}
List <CLDC_Dispatcher.Model.DSPTCH_LOG> lst_M = new List <CLDC_Dispatcher.Model.DSPTCH_LOG>();
foreach (DataRow row in ds.Tables[0].Rows)
{
CLDC_Dispatcher.Model.DSPTCH_LOG model = new CLDC_Dispatcher.Model.DSPTCH_LOG();
if (row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
model.TASK_NO = row["TASK_NO"].ToString();
model.AVR_DEVICE_ID = row["AVR_DEVICE_ID"].ToString();
model.AVR_TYPE = row["AVR_TYPE"].ToString();
model.AVR_LOG = row["AVR_LOG"].ToString();
model.AVR_WRITE_TIME = row["AVR_WRITE_TIME"].ToString();
lst_M.Add(model);
}
return(lst_M);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CLDC_Dispatcher.Model.DSPTCH_LOG GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, TASK_NO, AVR_DEVICE_ID, AVR_TYPE, AVR_LOG, AVR_WRITE_TIME ");
strSql.Append(" from DSPTCH_LOG ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
CLDC_Dispatcher.Model.DSPTCH_LOG model = new CLDC_Dispatcher.Model.DSPTCH_LOG();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
model.TASK_NO = ds.Tables[0].Rows[0]["TASK_NO"].ToString();
model.AVR_DEVICE_ID = ds.Tables[0].Rows[0]["AVR_DEVICE_ID"].ToString();
model.AVR_TYPE = ds.Tables[0].Rows[0]["AVR_TYPE"].ToString();
model.AVR_LOG = ds.Tables[0].Rows[0]["AVR_LOG"].ToString();
model.AVR_WRITE_TIME = ds.Tables[0].Rows[0]["AVR_WRITE_TIME"].ToString();
return(model);
}
else
{
return(null);
}
}
