/// <summary>
/// 写调度日志
/// </summary>
/// <param name="action"></param>
/// <param name="dispathcNumber"></param>
/// <param name="dispatchedNumbers"></param>
/// <param name="memo"></param>
/// <returns></returns>
public static bool WriteLog(CommControl.PublicEnums.EnumNormalCmd action, long dispathcNumber, string dispatchedNumbers, string memo)
{
if (dispathcNumber==0)
{
return false;
}
DB_Talk.Model.Data_DispatchLog log = new DB_Talk.Model.Data_DispatchLog();
log.dt_DateTime = DateTime.Now;
log.ManagerID = Pub.manageModel.ID;
log.DispatchTypeID = action.GetHashCode();
log.DispatchNumber = dispathcNumber;
log.DispatchedNumbers = dispatchedNumbers;
log.i_Result = 0;
log.BoxID = Pub.manageModel.BoxID;
log.i_State = 0;
log.vc_Memo = memo;
if ((new DB_Talk.BLL.Data_DispatchLog()).Add(log) > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<DB_Talk.Model.Data_DispatchLog> DataTableToList(DataSet ds)
{
List<DB_Talk.Model.Data_DispatchLog> modelList = new List<DB_Talk.Model.Data_DispatchLog>();
if (ds == null) return modelList;
DataTable dt = ds.Tables[0];
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
DB_Talk.Model.Data_DispatchLog model;
for (int n = 0; n < rowsCount; n++)
{
model = new DB_Talk.Model.Data_DispatchLog();
if(dt.Rows[n]["ID"]!=null && dt.Rows[n]["ID"].ToString()!="")
{
model.ID=int.Parse(dt.Rows[n]["ID"].ToString());
}
if(dt.Rows[n]["BoxID"]!=null && dt.Rows[n]["BoxID"].ToString()!="")
{
model.BoxID=int.Parse(dt.Rows[n]["BoxID"].ToString());
}
if(dt.Rows[n]["ManagerID"]!=null && dt.Rows[n]["ManagerID"].ToString()!="")
{
model.ManagerID=int.Parse(dt.Rows[n]["ManagerID"].ToString());
}
if(dt.Rows[n]["dt_DateTime"]!=null && dt.Rows[n]["dt_DateTime"].ToString()!="")
{
model.dt_DateTime=DateTime.Parse(dt.Rows[n]["dt_DateTime"].ToString());
}
if(dt.Rows[n]["DispatchNumber"]!=null && dt.Rows[n]["DispatchNumber"].ToString()!="")
{
model.DispatchNumber=int.Parse(dt.Rows[n]["DispatchNumber"].ToString());
}
if(dt.Rows[n]["DispatchTypeID"]!=null && dt.Rows[n]["DispatchTypeID"].ToString()!="")
{
model.DispatchTypeID=int.Parse(dt.Rows[n]["DispatchTypeID"].ToString());
}
if(dt.Rows[n]["DispatchedNumbers"]!=null && dt.Rows[n]["DispatchedNumbers"].ToString()!="")
{
model.DispatchedNumbers= dt.Rows[n]["DispatchedNumbers"].ToString();
}
if(dt.Rows[n]["i_Result"]!=null && dt.Rows[n]["i_Result"].ToString()!="")
{
model.i_Result=int.Parse(dt.Rows[n]["i_Result"].ToString());
}
if(dt.Rows[n]["i_State"]!=null && dt.Rows[n]["i_State"].ToString()!="")
{
model.i_State=int.Parse(dt.Rows[n]["i_State"].ToString());
}
if(dt.Rows[n]["vc_Memo"]!=null && dt.Rows[n]["vc_Memo"].ToString()!="")
{
model.vc_Memo= dt.Rows[n]["vc_Memo"].ToString();
}
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 根据条件得到一个对象实体
/// </summary>
public DB_Talk.Model.Data_DispatchLog GetModel(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append(" select top 1 ");
strSql.Append(" ID, BoxID, ManagerID, dt_DateTime, DispatchNumber, DispatchTypeID, DispatchedNumbers, i_Result, i_State, vc_Memo ");
strSql.Append(" from Data_DispatchLog ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
DB_Talk.Model.Data_DispatchLog model=new DB_Talk.Model.Data_DispatchLog();
DataSet ds=GetDataSet(strSql.ToString());
if(ds!=null && ds.Tables[0].Rows.Count>0)
{
model=DataTableToList(ds)[0];
return model;
}
else
{
return null;
}
}
