【求助】小女子再问一个问题：有关C井.net的

小谢

本周和上周数据表格数据转换。

现在流程是这样：本周是报下周的报名，而到了实际日期的“下周”时，本周的数据转去上周，上周数据清除，插入本周的名单，而本周报名开始清除接受新的报名（即又报下周的）

代码如下！谢谢啊！

using System;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using Equiptech.Common;
using Equiptech.DataAccess;
using Equiptech.DataAccess.DTO;

namespace Equiptech.DataAccess
{
/// <summary>
/// DbBadminton 的摘要说明。
/// </summary>
public class DbBadminton
{
public DbBadminton()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
private string strSQL;
[Bindable(true),
Category("Appearance"),
DefaultValue("")]

//向Benzhou表插入资料
public bool Srv_Insert(clsDTO_Resole Insert)
{
try
{
strSQL="insert into Benzhou (Biaoshi,BWeek,BDatetime,BPersonnel) values( '" +
(string)Insert.Get_Value("星期1")+"','"+
"星期1"+"','"+
(string)Insert.Get_Value("BDatetime")+"','"+
(string)Insert.Get_Value("BPersonnel")+"');" +
"insert into Benzhou (Biaoshi,BWeek,BDatetime,BPersonnel) values( '" +
(string)Insert.Get_Value("星期2")+"','"+
"星期2"+"','"+
(string)Insert.Get_Value("BDatetime")+"','"+
(string)Insert.Get_Value("BPersonnel")+"');" +
"insert into Benzhou (Biaoshi,BWeek,BDatetime,BPersonnel) values( '" +
(string)Insert.Get_Value("星期3")+"','"+
"星期3"+"','"+
(string)Insert.Get_Value("BDatetime")+"','"+
(string)Insert.Get_Value("BPersonnel")+"');" +
"insert into Benzhou (Biaoshi,BWeek,BDatetime,BPersonnel) values( '" +
(string)Insert.Get_Value("星期4")+"','"+
"星期4"+"','"+
(string)Insert.Get_Value("BDatetime")+"','"+
(string)Insert.Get_Value("BPersonnel")+"');" +
"insert into Benzhou (Biaoshi,BWeek,BDatetime,BPersonnel) values( '" +
(string)Insert.Get_Value("星期5")+"','"+
"星期5"+"','"+
(string)Insert.Get_Value("BDatetime")+"','"+
(string)Insert.Get_Value("BPersonnel")+"')";

clsDataAccess EXESQL=new clsDataAccess();
EXESQL.ExeSQL(strSQL);
EXESQL.DisposeDataAccess();
return true;
}
catch
{return false;}
}

//修改资料
public bool Srv_Update(clsDTO_Resole Update)
{
try
{
strSQL="update Benzhou set "+
                     "Biaoshi='"+(string)Update.Get_Value("星期1")+ "'where BPersonnel='" +(string)Update.Get_Value("BPersonnel")+ "'and BWeek='星期1'"+";"+
         "update Benzhou set "+
                     "Biaoshi='"+(string)Update.Get_Value("星期2")+ "'where BPersonnel='" +(string)Update.Get_Value("BPersonnel")+ "' and BWeek='星期2'"+";"+
   "update Benzhou set "+
                     "Biaoshi='"+(string)Update.Get_Value("星期3")+ "'where BPersonnel='" +(string)Update.Get_Value("BPersonnel")+ "' and BWeek='星期3'"+";"+
   "update Benzhou set "+
                     "Biaoshi='"+(string)Update.Get_Value("星期4")+ "'where BPersonnel='" +(string)Update.Get_Value("BPersonnel")+ "' and BWeek='星期4'"+";"+
   "update Benzhou set "+
                     "Biaoshi='"+(string)Update.Get_Value("星期5")+ "'where BPersonnel='" +(string)Update.Get_Value("BPersonnel")+ "' and BWeek='星期5'";

clsDataAccess EXESQL=new clsDataAccess();
EXESQL.ExeSQL(strSQL);
return true;
}
catch
{return false;}
}

//查询本周记录
public bool Srv_Query(ref clsDTO_Resole Query)
{
try
{
string strSQL;

strSQL="select distinct bweek as 星期,dbo.fmerg(bweek) as 报名人员,count(bpersonnel)as 总计  from Benzhou where biaoshi='true' group by bweek";

clsDataAccess EXESQL=new clsDataAccess();
DataSet datBadminton=new DataSet();
EXESQL.ExeSQL(strSQL,ref datBadminton);
Query.Set_Value("查询返回数据集",datBadminton);
EXESQL.DisposeDataAccess();
return true;
}
catch
{return true;}
}

//查询上周记录
public bool Srv_SQuery(ref clsDTO_Resole Query)
{
try
{
string strSQL;

strSQL="select distinct sweek as 星期,dbo.fshang(sweek) as 报名人员,count(bpersonnel)as 总计  from Shangzhou where biaoshi='true' group by sweek";

clsDataAccess EXESQL=new clsDataAccess();
DataSet datBadminton=new DataSet();
EXESQL.ExeSQL(strSQL,ref datBadminton);
Query.Set_Value("查询返回数据集",datBadminton);
EXESQL.DisposeDataAccess();
return true;
}
catch
{return true;}
}

   /* public bool Srv_Change(clsDTO_Resole Change)
{
try
{
if((string)Change.Get_Value("BPersonnel")!="")
{
//把上周记录清理
string strSQL;
strSQL="delete from Shangzhou where BPersonnel='"+(string)Change.Get_Value("BPersonnel")+"'";
clsDataAccess EXESQL=new clsDataAccess();
EXESQL.ExeSQL(strSQL);

//把本周表的记录插到上周表
strSQL="insert into Shangzhou select * From Benzhou where getdate()-当前业务操作时间>7 and BPersonnel='"+
(string)Change.Get_Value("BPersonnel")+"'";

EXESQL.ExeSQL(strSQL);

//清理本周记录
strSQL="delete from Benzhou where getdate()-当前业务操作时间>7 and BPersonnel='"+
(string)Change.Get_Value("BPersonnel")+"'";

EXESQL.ExeSQL(strSQL);
EXESQL.DisposeDataAccess();

return true;
}

}
catch
{return false;}

}*/

}
}