/// <summary>
/// 实体信息
/// </summary>
private MItemWeb GetModel(DataRow row)
{
MItemWeb model = new MItemWeb();
model.ID = Convert.ToInt32(row["ID"]);
model.WID = Convert.ToInt32(row["WID"]);
model.IID = Convert.ToInt64(row["IID"]);
model.WName = Convert.ToString(row["WName"]);
return(model);
}
private SqlCommand GetCommand(MItemWeb model)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(new SqlParameter(ID, SqlDbType.Int));
cmd.Parameters.Add(new SqlParameter(WID, SqlDbType.Int));
cmd.Parameters.Add(new SqlParameter(IID, SqlDbType.BigInt));
cmd.Parameters[ID].Value = model.ID;
cmd.Parameters[WID].Value = model.WID;
cmd.Parameters[IID].Value = model.IID;
return(cmd);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(MItemWeb model, string strWhere, string ConnStr)
{
StringBuilder sql = new StringBuilder();
sql.Append(" INSERT Web_ItemWeb");
sql.Append(" SET");
sql.Append(" WID = @WID, ");
sql.Append(" IID = @IID ");
sql.Append("WHERE ID = @ID ");
SqlCommand cmd = GetCommand(model);
DbHelperSQL.RunSqlText(sql.ToString(), cmd, 3600, ConnStr);
return(Convert.ToInt32(cmd.Parameters[ID].Value));
}
/// <summary>
/// 增加
/// </summary>
public int Insert(MItemWeb model, string ConnStr)
{
StringBuilder sql = new StringBuilder();
sql.Append(" INSERT Web_ItemWeb (");
sql.Append(" WID,IID )");
sql.Append(" SELECT");
sql.Append(" @WID,@IID");
sql.Append(" SELECT @ID=@@IDENTITY");
SqlCommand cmd = GetCommand(model);
DbHelperSQL.RunSqlText(sql.ToString(), cmd, 3600, ConnStr);
return(Convert.ToInt32(cmd.Parameters[ID].Value));
}
/// <summary>
/// 根据 主键编号 更新
/// </summary>
public int Update(MItemWeb model)
{
return(dal.Update(model, "", ConnStr));
}
/// <summary>
/// 增加
/// </summary>
public long Insert(MItemWeb model)
{
return(dal.Insert(model, ConnStr));
}
