public static void Add(int id, string SheepNo, int ProjectId, string WorkRemark, int PlanType, DateTime StartTime, DateTime EndTime, DateTime RealStartTime, DateTime RealEndTime, DateTime PublishTime, int State, int NeederId, string Remark, int userid, string tester, string dever, string FilePath, DateTime SecretScanTime, int SecretScanCount)
{
string sql = @" if exists(select Id from WorkPlans where Id=@Id)
update WorkPlans set SheepNo=@SheepNo,ProjectId=@ProjectId,WorkRemark=@WorkRemark,PlanType=@PlanType,StartTime=@StartTime,EndTime=@EndTime,RealStartTime=@RealStartTime,RealEndTime=@RealEndTime,PublishTime=@PublishTime,State=@State,NeederId=@NeederId,Remark=@Remark,LastModifyUser=@userid,LastModifyTime=getdate(),Tester=@Tester,Dever=@Dever,FilePath=@FilePath,SecretScanTime=@SecretScanTime,SecretScanCount=@SecretScanCount where Id=@Id
else
insert into WorkPlans(SheepNo,ProjectId,WorkRemark,PlanType,StartTime,EndTime,RealStartTime,RealEndTime,PublishTime,State,NeederId,Remark,LastModifyUser,LastModifyTime,Tester,Dever,FilePath,SecretScanTime,SecretScanCount) values(@SheepNo,@ProjectId,@WorkRemark,@PlanType,@StartTime,@EndTime,@RealStartTime,@RealEndTime,@PublishTime,@State,@NeederId,@Remark,@userid,getdate(),@Tester,@Dever,@FilePath,@SecretScanTime,@SecretScanCount)" ;
SqlParam p = new SqlParam();
p.AddParam("@Id", id, SqlDbType.Int, 0);
p.AddParam("@SheepNo", SheepNo, SqlDbType.VarChar, 200);
p.AddParam("@ProjectId", ProjectId, SqlDbType.Int, 0);
p.AddParam("@WorkRemark", WorkRemark, SqlDbType.VarChar, 1000);
p.AddParam("@PlanType", PlanType, SqlDbType.Int, 0);
p.AddParam("@StartTime", StartTime, SqlDbType.DateTime, 0);
p.AddParam("@EndTime", EndTime, SqlDbType.DateTime, 0);
p.AddParam("@RealStartTime", RealStartTime, SqlDbType.DateTime, 0);
p.AddParam("@RealEndTime", RealEndTime, SqlDbType.DateTime, 0);
p.AddParam("@PublishTime", PublishTime, SqlDbType.DateTime, 0);
p.AddParam("@State", State, SqlDbType.Int, 0);
p.AddParam("@NeederId", NeederId, SqlDbType.Int, 0);
p.AddParam("@Remark", Remark, SqlDbType.NVarChar, 4000);
p.AddParam("@userid", userid, SqlDbType.Int, 0);
p.AddParam("@Tester", tester, SqlDbType.VarChar, 500);
p.AddParam("@Dever", dever, SqlDbType.VarChar, 500);
p.AddParam("@FilePath", FilePath, SqlDbType.VarChar, 200);
p.AddParam("@SecretScanTime", RealEndTime, SqlDbType.DateTime, 0);
p.AddParam("@SecretScanCount", SecretScanCount, SqlDbType.Int, 0);
ProjectDB.SqlExecute(sql, p);
}
public static void Delete(int id)
{
string sql = @"Delete from Attentions where Id=@id";
SqlParam p = new SqlParam();
p.AddParam("@id", id, SqlDbType.Int, 0);
ProjectDB.SqlExecute(sql, p);
}
public static void Add(string Remark, string ProjectId)
{
string sql = @"INSERT INTO [dbo].[Attentions] ([Remark] ,[ProjectId]) VALUES (@Remark ,@ProjectId)";
SqlParam p = new SqlParam();
p.AddParam("@Remark", Remark, SqlDbType.VarChar, 2000);
p.AddParam("@ProjectId", ProjectId, SqlDbType.VarChar, 1000);
ProjectDB.SqlExecute(sql, p);
}
public static void Delete(int id)
{
string sql = @"Delete from Projects where Id=@id";
SqlParam p = new SqlParam();
p.AddParam("@id", id, SqlDbType.Int, 0);
ProjectDB.SqlExecute(sql, p);
UnicornCache.Remove(CacheKey.Project);
}
public static void Update(int id)
{
string sql = @"update Users set [Status]=[Status]%2+1 where Id=@id";
SqlParam p = new SqlParam();
p.AddParam("@id", id, SqlDbType.Int, 0);
ProjectDB.SqlExecute(sql, p);
UnicornCache.Remove(CacheKey.User);
}
public static void Update(int id, string Remark, string ProjectId)
{
string sql = @"UPDATE [dbo].[Attentions] SET [Remark] = @Remark,[ProjectId] = @ProjectId WHERE id=@id";
SqlParam p = new SqlParam();
p.AddParam("@Remark", Remark, SqlDbType.VarChar, 2000);
p.AddParam("@ProjectId", ProjectId, SqlDbType.VarChar, 1000);
p.AddParam("@id", id, SqlDbType.Int, 0);
ProjectDB.SqlExecute(sql, p);
}
public static void Update(int id, string username, string password)
{
string sql = @"update Users set Password=@Password where Id=@id";
SqlParam p = new SqlParam();
p.AddParam("@id", id, SqlDbType.Int, 0);
p.AddParam("@Password", St.GetMd5(username + password), SqlDbType.VarChar, 100);
ProjectDB.SqlExecute(sql, p);
UnicornCache.Remove(CacheKey.User);
}
public static void Add(int WorkPlanId, string FileName, string FilePath)
{
string sql = @"INSERT INTO [dbo].[WorkPlanFiles] ([WorkPlanId] ,[FileName], [FilePath], [AddTime]) VALUES (@WorkPlanId ,@FileName, @FilePath, GetDate())";
SqlParam p = new SqlParam();
p.AddParam("@WorkPlanId", WorkPlanId, SqlDbType.Int, 0);
p.AddParam("@FileName", FileName, SqlDbType.VarChar, 200);
p.AddParam("@FilePath", FilePath, SqlDbType.VarChar, 200);
ProjectDB.SqlExecute(sql, p);
}
public static void Add(string code, string name, int type, string remark)
{
string sql = @"insert into Dics(Code,Name,Type,Remark) values(@Code,@Name,@Type,@Remark)";
SqlParam p = new SqlParam();
p.AddParam("@Code", code, SqlDbType.VarChar, 50);
p.AddParam("@Name", name, SqlDbType.VarChar, 50);
p.AddParam("@Type", type, SqlDbType.Int, 0);
p.AddParam("@Remark", remark, SqlDbType.VarChar, 50);
ProjectDB.SqlExecute(sql, p);
UnicornCache.Remove(CacheKey.Dic);
}
public static void Update(int id, string code, string name, int type, string remark)
{
string sql = @"update Dics set Code=@Code,Name=@Name,Type=@Type,Remark=@Remark where Id=@id";
SqlParam p = new SqlParam();
p.AddParam("@id", id, SqlDbType.Int, 0);
p.AddParam("@Code", code, SqlDbType.VarChar, 50);
p.AddParam("@Name", name, SqlDbType.VarChar, 50);
p.AddParam("@Type", type, SqlDbType.Int, 0);
p.AddParam("@Remark", remark, SqlDbType.VarChar, 50);
ProjectDB.SqlExecute(sql, p);
UnicornCache.Remove(CacheKey.Dic);
}
public static void Add(string ServerName, string UserName, string Password, string IISVersion, string SqlVersion, string ProjectId, string OSName, string ServerType)
{
string sql = @"INSERT INTO [dbo].[Servers] ([ServerName] ,[UserName] ,[Password] ,[IISVersion] ,[SqlVersion] ,[ProjectId] ,[AddTime],[OSName],[ServerType]) VALUES (@ServerName ,@UserName ,@Password ,@IISVersion ,@SqlVersion ,@ProjectId,GETDATE(),@OSName,@ServerType)";
SqlParam p = new SqlParam();
p.AddParam("@ServerName", ServerName, SqlDbType.VarChar, 200);
p.AddParam("@UserName", UserName, SqlDbType.VarChar, 200);
p.AddParam("@Password", Password, SqlDbType.VarChar, 200);
p.AddParam("@IISVersion", IISVersion, SqlDbType.VarChar, 50);
p.AddParam("@SqlVersion", SqlVersion, SqlDbType.VarChar, 50);
p.AddParam("@ProjectId", ProjectId, SqlDbType.VarChar, 1000);
p.AddParam("@OSName", OSName, SqlDbType.VarChar, 100);
p.AddParam("@ServerType", ServerType, SqlDbType.VarChar, 100);
ProjectDB.SqlExecute(sql, p);
}
public static void Update(int id, string ServerName, string UserName, string Password, string IISVersion, string SqlVersion, string ProjectId, string OSName, string ServerType)
{
string sql = @"UPDATE [dbo].[Servers] SET [ServerName] = @ServerName,[UserName] = @UserName,[Password] = @Password,[IISVersion] = @IISVersion,[SqlVersion] = @SqlVersion,[ProjectId] = @ProjectId,[OSName]=@OSName,[ServerType]=@ServerType WHERE id=@id";
SqlParam p = new SqlParam();
p.AddParam("@ServerName", ServerName, SqlDbType.VarChar, 200);
p.AddParam("@UserName", UserName, SqlDbType.VarChar, 200);
p.AddParam("@Password", Password, SqlDbType.VarChar, 200);
p.AddParam("@IISVersion", IISVersion, SqlDbType.VarChar, 50);
p.AddParam("@SqlVersion", SqlVersion, SqlDbType.VarChar, 50);
p.AddParam("@ProjectId", ProjectId, SqlDbType.VarChar, 1000);
p.AddParam("@OSName", OSName, SqlDbType.VarChar, 100);
p.AddParam("@ServerType", ServerType, SqlDbType.VarChar, 100);
p.AddParam("@id", id, SqlDbType.Int, 0);
ProjectDB.SqlExecute(sql, p);
}
public static void Add(string username, string realname, int userrole, DateTime leavetime, int bugzillaid)
{
string sql = @" if exists(select Id from Users where UserName=@UserName)
update Users set RealName=@RealName,RoleType=@RoleType,LeaveTime=@LeaveTime,bugzillaid=@bugzillaid where UserName=@UserName
else
insert into Users(UserName,Password,RealName,RoleType,Status,LeaveTime,bugzillaid) values(@UserName,@Password,@RealName,@RoleType,1,@LeaveTime,@bugzillaid)" ;
SqlParam p = new SqlParam();
p.AddParam("@UserName", username, SqlDbType.VarChar, 100);
p.AddParam("@RealName", realname, SqlDbType.VarChar, 500);
p.AddParam("@RoleType", userrole, SqlDbType.Int, 0);
p.AddParam("@Password", St.GetMd5(username + "123456"), SqlDbType.VarChar, 100);
p.AddParam("@LeaveTime", leavetime, SqlDbType.DateTime, 0);
p.AddParam("@bugzillaid", bugzillaid, SqlDbType.Int, 0);
ProjectDB.SqlExecute(sql, p);
UnicornCache.Remove(CacheKey.User);
}
public static void Add(int id, string name, string url, int parentid, string TestUrl, string SiteFileName, string DatabaseName, string TestUserName, string TestPassword, string Remark, int IsShow)
{
string sql = @" if exists(select Id from Projects where Id=@Id)
update Projects set Name=@Name,ParentId=@ParentId,Url=@Url,TestUrl=@TestUrl,SiteFileName=@SiteFileName,DatabaseName=@DatabaseName,TestUserName=@TestUserName,TestPassword=@TestPassword,Remark=@Remark,IsShow=@IsShow where Id=@Id
else
insert into Projects(Name,ParentId,Url,TestUrl,SiteFileName,DatabaseName,TestUserName,TestPassword,Remark,IsShow) values(@Name,@ParentId,@Url,@TestUrl,@SiteFileName,@DatabaseName,@TestUserName,@TestPassword,@Remark,@IsShow)" ;
SqlParam p = new SqlParam();
p.AddParam("@Id", id, SqlDbType.Int, 0);
p.AddParam("@Name", name, SqlDbType.VarChar, 500);
p.AddParam("@ParentId", parentid, SqlDbType.Int, 0);
p.AddParam("@Url", url, SqlDbType.VarChar, 500);
p.AddParam("@TestUrl", TestUrl, SqlDbType.VarChar, 500);
p.AddParam("@SiteFileName", SiteFileName, SqlDbType.VarChar, 500);
p.AddParam("@DatabaseName", DatabaseName, SqlDbType.VarChar, 500);
p.AddParam("@TestUserName", TestUserName, SqlDbType.VarChar, 200);
p.AddParam("@TestPassword", TestPassword, SqlDbType.VarChar, 200);
p.AddParam("@Remark", Remark, SqlDbType.VarChar, 500);
p.AddParam("@IsShow", IsShow, SqlDbType.Int, 0);
ProjectDB.SqlExecute(sql, p);
UnicornCache.Remove(CacheKey.Project);
}
