/// <summary>
/// 根据Pid更新一条数据Pmachine,Plock,Pdate
/// </summary>
public bool UpdateMachine(LearnSite.Model.Computers model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Computers set ");
strSql.Append("Pmachine=@Pmachine,");
strSql.Append("Plock=@Plock,");
strSql.Append("Pdate=@Pdate");
strSql.Append(" where Pid=@Pid");
SqlParameter[] parameters =
{
new SqlParameter("@Pid", SqlDbType.Int, 4),
new SqlParameter("@Pmachine", SqlDbType.NVarChar, 50),
new SqlParameter("@Plock", SqlDbType.Bit, 1),
new SqlParameter("@Pdate", SqlDbType.DateTime)
};
parameters[0].Value = model.Pid;
parameters[1].Value = model.Pmachine;
parameters[2].Value = model.Plock;
parameters[3].Value = model.Pdate;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LearnSite.Model.Computers model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Computers(");
strSql.Append("Pip,Pmachine,Plock,Pdate)");
strSql.Append(" values (");
strSql.Append("@Pip,@Pmachine,@Plock,@Pdate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Pip", SqlDbType.NVarChar, 50),
new SqlParameter("@Pmachine", SqlDbType.NVarChar, 50),
new SqlParameter("@Plock", SqlDbType.Bit, 1),
new SqlParameter("@Pdate", SqlDbType.DateTime)
};
parameters[0].Value = model.Pip;
parameters[1].Value = model.Pmachine;
parameters[2].Value = model.Plock;
parameters[3].Value = model.Pdate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 根据Pip得到一个对象实体
/// </summary>
public LearnSite.Model.Computers GetModelByIp(string Pip)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Pid,Pip,Pmachine,Plock,Pdate from Computers ");
strSql.Append(" where Pip=@Pip");
SqlParameter[] parameters =
{
new SqlParameter("@Pip", SqlDbType.NVarChar, 50)
};
parameters[0].Value = Pip;
LearnSite.Model.Computers model = new LearnSite.Model.Computers();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Pid"].ToString() != "")
{
model.Pid = int.Parse(ds.Tables[0].Rows[0]["Pid"].ToString());
}
model.Pip = ds.Tables[0].Rows[0]["Pip"].ToString();
model.Pmachine = ds.Tables[0].Rows[0]["Pmachine"].ToString();
if (ds.Tables[0].Rows[0]["Plock"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Plock"].ToString() == "1") || (ds.Tables[0].Rows[0]["Plock"].ToString().ToLower() == "true"))
{
model.Plock = true;
}
else
{
model.Plock = false;
}
}
if (ds.Tables[0].Rows[0]["Pdate"].ToString() != "")
{
model.Pdate = DateTime.Parse(ds.Tables[0].Rows[0]["Pdate"].ToString());
}
return(model);
}
else
{
return(null);
}
}
