public static int UpdateShowChiClient(Model.px_ShowChiClientModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update px_ShowChiClient set ");
strSql.Append("SName=@SName,");
strSql.Append("ClientIP=@ClientIP,");
strSql.Append("SAddTime=@SAddTime,");
strSql.Append("SRole=@SRole");
strSql.Append(" where SID=@SID");
SqlParameter[] parameters =
{
new SqlParameter("@SName", SqlDbType.NVarChar),
new SqlParameter("@ClientIP", SqlDbType.NVarChar),
new SqlParameter("@SAddTime", SqlDbType.DateTime),
new SqlParameter("@SRole", SqlDbType.NVarChar),
new SqlParameter("@SID", SqlDbType.Int)
};
parameters[0].Value = model.SName;
parameters[1].Value = model.ClientIP;
parameters[2].Value = Convert.ToDateTime(model.SAddTime);
parameters[3].Value = model.SRole;
parameters[4].Value = Convert.ToInt32(model.SID);
int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, strSql.ToString(), parameters);
return(rows);
}
public static int AddShowChiClient(Model.px_ShowChiClientModel model)
{
string maxid = @"set identity_insert px_ShowChiClient ON;
declare @i int;
SELECT @i=max([SID]) FROM [px_ShowChiClient];
if @i is null
begin
set @i=1
end
else
begin
set @i=@i+1
end;
";
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into px_ShowChiClient(");
strSql.Append("SID,SName,ClientIP,SAddTime,SRole)");
strSql.Append(" values (");
strSql.Append("@i,@SName,@ClientIP,@SAddTime,@SRole)");
SqlParameter[] parameters =
{
new SqlParameter("@SName", SqlDbType.NVarChar),
new SqlParameter("@ClientIP", SqlDbType.NVarChar),
new SqlParameter("@SAddTime", SqlDbType.DateTime),
new SqlParameter("@SRole", SqlDbType.NVarChar)
};
parameters[0].Value = model.SName;
parameters[1].Value = model.ClientIP;
parameters[2].Value = Convert.ToDateTime(model.SAddTime);
parameters[3].Value = model.SRole;
string end = @"set identity_insert px_ShowChiClient OFF";
int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, maxid + strSql + end, parameters);
return(rows);
}
