//删除档案管理员
public static void DeleteAdmin(String id)
{
CommTable comm1 = new CommTable("U_DepartDangAnAdminUsers");
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("id", id, SearchFieldType.数值型));
comm1.DeleteData(condition);
comm1.Close();
}
private void DeleteData(String key)
{
CommTable comm1 = new CommTable("U_LawZC");
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("id", key, SearchFieldType.数值型));
comm1.DeleteData(condition);
comm1.Close();
}
//删除过期的档案申请
private static void DeleteGuoQiBill()
{
CommTable com1 = new CommTable("DA_JyBill");
List <SearchField> condition = new List <SearchField>();
DateTime dt1 = DateTime.Now.AddYears(-1);
condition.Add(new SearchField("time0", dt1.ToString(), SearchOperator.小于));
com1.DeleteData(condition);
com1.Close();
}
//删除回款计划数据
private void DeleteHuiKuan(String id)
{
CommTable com1 = new CommTable();
com1.TabName = "CW_ShouKuanPlan";
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("id", id, SearchFieldType.数值型));
com1.DeleteData(condition);
com1.Close();
}
/// <summary>
/// 删除资产处置表的数据
/// </summary>
/// <param name="spid"></param>
private void DeleteSpData(String spid)
{
CommTable com1 = new CommTable();
com1.TabName = "U_ZC2";
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("id", spid, SearchFieldType.数值型));
com1.DeleteData(condition);
com1.Close();
}
private void ChangeData()
{
CommTable com1 = new CommTable();
com1.TabName = "CW_ShouKuan1";
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("Bzeren is null", "", SearchOperator.用户定义));
condition.Add(new SearchField("checktime is null", "", SearchOperator.用户定义));
com1.DeleteData(condition);
com1.Close();
}
//删除所中的数据
protected void Button2_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(Request.Form["Seldoc"]) == false)
{
CommTable comm1 = new CommTable();
comm1.TabName = "ZX_QuickTalk";
List <SearchField> list1 = new List <SearchField>();
list1.Add(new SearchField("tmen", User.Identity.Name));
list1.Add(new SearchField("id", Request.Form["Seldoc"], SearchOperator.集合, SearchFieldType.数值型));
comm1.DeleteData(list1);
comm1.Close();
this.BindData();
}
}
//删除一个已存在的日程安排
protected void Button2_Click(object sender, EventArgs e)
{
CommTable comm1 = new CommTable();
comm1.TabName = "ZX_RCAP";
string infoid = this.id.Value;
List <SearchField> list1 = new List <SearchField>();
list1.Add(new SearchField("id", infoid, SearchFieldType.数值型));
list1.Add(new SearchField("sname", User.Identity.Name));
comm1.DeleteData(list1);
comm1.Close();
Response.Redirect("MyRcaiPai.aspx", true);
}
//删除数据
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
HiddenField hid1 = e.Item.FindControl("HiddenField1") as HiddenField;
if (hid1 != null)
{
string id = hid1.Value;
CommTable comm1 = new CommTable("ZX_QuickTalk");
List <SearchField> list1 = new List <SearchField>();
list1.Add(new SearchField("id", id, SearchFieldType.数值型));
comm1.DeleteData(list1);
comm1.Close();
}
}
//重新设置审批流程
protected void Button5_Click(object sender, EventArgs e)
{
CommTable comm1 = new CommTable();
////////////////////////////////////////////////////////////////
comm1.TabName = "U_ZC2";
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("id", Request["id"], SearchFieldType.数值型));
Hashtable ht = new Hashtable();
ht["status"] = "04";
comm1.EditQuickData(condition, ht);
////////////////////////////////////////////////////////////////
comm1.TabName = "U_ZCSP";
condition.Clear();
condition.Add(new SearchField("CZID", Request["id"], SearchFieldType.数值型));
comm1.DeleteData(condition);
comm1.Close();
Response.Redirect(Request.PathInfo, true);
}