/// <summary>
/// 删除事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnDelete_Click(object sender, EventArgs e)
{
try
{
CheckBox cb;
int resourceID;
ExtendBLL.FavoriteResource fr = new ExtendBLL.FavoriteResource();
LabMS.Model.FavoriteResource frInfo = new LabMS.Model.FavoriteResource();
for (int i = GridViewResourceList.Rows.Count - 1; i > -1; i--)
{
cb = (CheckBox)GridViewResourceList.Rows[i].FindControl("CBSelect");
if (cb.Checked)
{
resourceID = int.Parse(GridViewResourceList.DataKeys[i].Value.ToString());
frInfo.ResourceID = resourceID;
frInfo.UserID = int.Parse(UserID);
frInfo.UserType = Base.PrivilegeManager.GetUserTypeCode();
fr.Delete(frInfo);
}
}
BindData();
WriteBackScript("alert('已成功删除相关资源')");
}
catch (Exception ex)
{
}
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public LabMS.Model.FavoriteResource GetModel(int ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ID,UserID,ResourceID,UserType from FavoriteResource ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID;
LabMS.Model.FavoriteResource model=new LabMS.Model.FavoriteResource();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["ID"].ToString()!="")
{
model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if(ds.Tables[0].Rows[0]["UserID"].ToString()!="")
{
model.UserID=int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
if(ds.Tables[0].Rows[0]["ResourceID"].ToString()!="")
{
model.ResourceID=int.Parse(ds.Tables[0].Rows[0]["ResourceID"].ToString());
}
if(ds.Tables[0].Rows[0]["UserType"].ToString()!="")
{
model.UserType=int.Parse(ds.Tables[0].Rows[0]["UserType"].ToString());
}
return model;
}
else
{
return null;
}
}
