/// <summary>
/// 得到一个对象实体
/// </summary>
public BWJSLog.Model.MachineLocationLog GetModel(int MachineLocationLogId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select MachineLocationLogId, CreateDate, IsDeleted, Remark, UserId, MachineId, IP, MAC, Latitude, Longitude, LocationAddress, LocationData ");
strSql.Append(" from dbo.[MachineLocationLog] ");
strSql.Append(" where MachineLocationLogId=@MachineLocationLogId");
SqlParameter[] parameters =
{
new SqlParameter("@MachineLocationLogId", SqlDbType.Int, 4)
};
parameters[0].Value = MachineLocationLogId;
BWJSLog.Model.MachineLocationLog model = new BWJSLog.Model.MachineLocationLog();
DataSet ds = BWJSLogHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BWJSLog.Model.MachineLocationLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo.[MachineLocationLog] set ");
strSql.Append(" CreateDate = @CreateDate , ");
strSql.Append(" IsDeleted = @IsDeleted , ");
strSql.Append(" Remark = @Remark , ");
strSql.Append(" UserId = @UserId , ");
strSql.Append(" MachineId = @MachineId , ");
strSql.Append(" IP = @IP , ");
strSql.Append(" MAC = @MAC , ");
strSql.Append(" Latitude = @Latitude , ");
strSql.Append(" Longitude = @Longitude , ");
strSql.Append(" LocationAddress = @LocationAddress , ");
strSql.Append(" LocationData = @LocationData ");
strSql.Append(" where MachineLocationLogId=@MachineLocationLogId ");
SqlParameter[] parameters =
{
new SqlParameter("@MachineLocationLogId", model.MachineLocationLogId),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@UserId", model.UserId),
new SqlParameter("@MachineId", model.MachineId),
new SqlParameter("@IP", model.IP),
new SqlParameter("@MAC", model.MAC),
new SqlParameter("@Latitude", model.Latitude),
new SqlParameter("@Longitude", model.Longitude),
new SqlParameter("@LocationAddress", model.LocationAddress),
new SqlParameter("@LocationData", model.LocationData)
};
int rows = BWJSLogHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// datarow转成对象实体
/// </summary>
public BWJSLog.Model.MachineLocationLog DataRowToModel(DataRow row)
{
BWJSLog.Model.MachineLocationLog model = new BWJSLog.Model.MachineLocationLog();
if (row != null)
{
if (row["MachineLocationLogId"].ToString() != "")
{
model.MachineLocationLogId = int.Parse(row["MachineLocationLogId"].ToString());
}
if (row["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(row["CreateDate"].ToString());
}
if (row["IsDeleted"].ToString() != "")
{
model.IsDeleted = int.Parse(row["IsDeleted"].ToString());
}
model.Remark = row["Remark"].ToString();
if (row["UserId"].ToString() != "")
{
model.UserId = int.Parse(row["UserId"].ToString());
}
if (row["MachineId"].ToString() != "")
{
model.MachineId = int.Parse(row["MachineId"].ToString());
}
model.IP = row["IP"].ToString();
model.MAC = row["MAC"].ToString();
model.Latitude = row["Latitude"].ToString();
model.Longitude = row["Longitude"].ToString();
model.LocationAddress = row["LocationAddress"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BWJSLog.Model.MachineLocationLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo.[MachineLocationLog](");
strSql.Append("CreateDate,IsDeleted,Remark,UserId,MachineId,IP,MAC,Latitude,Longitude,LocationAddress,LocationData");
strSql.Append(") values (");
strSql.Append("@CreateDate,@IsDeleted,@Remark,@UserId,@MachineId,@IP,@MAC,@Latitude,@Longitude,@LocationAddress,@LocationData");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@IsDeleted", model.IsDeleted),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@UserId", model.UserId),
new SqlParameter("@MachineId", model.MachineId),
new SqlParameter("@IP", model.IP),
new SqlParameter("@MAC", model.MAC),
new SqlParameter("@Latitude", model.Latitude),
new SqlParameter("@Longitude", model.Longitude),
new SqlParameter("@LocationAddress", model.LocationAddress),
new SqlParameter("@LocationData", model.LocationData)
};
object obj = BWJSLogHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
