//删除收款凭证
private void DeleteShoukuan(String id)
{
List <SearchField> condition = new List <SearchField>();
CommTable com1 = new CommTable();
com1.TableConnect.BeginTrans();
try
{
com1.TabName = "CW_ShouKuan";
condition.Add(new SearchField("id", id, SearchFieldType.数值型));
DataSet ds1 = com1.SearchData("*", condition);
if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
{
DataRow dr1 = ds1.Tables[0].Rows[0];
String zcid = dr1["zcid"].ToString();
String checktime = dr1["checktime"].ToString().Trim();
double pbj = 0;
if (String.IsNullOrEmpty(dr1["pbj"].ToString().Trim()) == false)
{
pbj = double.Parse(dr1["pbj"].ToString());
}
double plx = 0;
if (String.IsNullOrEmpty(dr1["plx"].ToString().Trim()) == false)
{
plx = double.Parse(dr1["plx"].ToString());
}
//删除收款凭证的数据
dr1.Delete();
com1.Update(ds1);
//如果收款凭证已审核，则需调整资产中的相关数据
if (String.IsNullOrEmpty(checktime) == false)
{
com1.TabName = "u_zc3";
condition.Clear();
condition.Add(new SearchField("id", zcid, SearchFieldType.数值型));
DataSet ds2 = com1.SearchData("*", condition);
if (ds2 != null && ds2.Tables[0].Rows.Count > 0)
{
DataRow dr2 = ds2.Tables[0].Rows[0];
dr2["pbj"] = double.Parse(dr2["pbj"].ToString()) - pbj;
dr2["plx"] = double.Parse(dr2["plx"].ToString()) - plx;
com1.Update(ds2);
}
}
}
com1.TableConnect.CommitTrans();
}
catch (Exception err)
{
com1.TableConnect.RollBackTrans();
}
finally
{
com1.Close();
}
}
/// <summary>
/// 判断时效是否建立了日志
/// </summary>
/// <param name="TimeID"></param>
/// <param name="TimeKind"></param>
/// <returns></returns>
private static bool HasLog(String TimeID, String TimeKind, String UserName)
{
bool has = false;
CommTable comm1 = new CommTable("U_TimeLog");
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("TimeID", TimeID, SearchFieldType.数值型));
condition.Add(new SearchField("LogUser", UserName));
if (TimeKind == "0") //月显示
{
condition.Add(new SearchField("year(logtime)", DateTime.Today.Year + "", SearchFieldType.数值型));
condition.Add(new SearchField("month(logtime)", DateTime.Today.Month + "", SearchFieldType.数值型));
}
else if (TimeKind == "1") //周显示
{
}
else //日显示
{
condition.Add(new SearchField("year(logtime)", DateTime.Today.Year + "", SearchFieldType.数值型));
condition.Add(new SearchField("month(logtime)", DateTime.Today.Month + "", SearchFieldType.数值型));
condition.Add(new SearchField("day(logtime)", DateTime.Today.Day + "", SearchFieldType.数值型));
}
DataSet ds1 = comm1.SearchData("*", condition);
if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
{
has = true;
}
comm1.Close();
return(has);
}
private void SetPageInfo(DateTime time0)
{
CommTable comm1 = new CommTable();
comm1.TabName = "ZX_RCAP";
List <SearchField> list1 = new List <SearchField>();
list1.Add(new SearchField("sname", User.Identity.Name));
list1.Add(new SearchField("year(plantime)", time0.Year + "", SearchFieldType.数值型));
list1.Add(new SearchField("month(plantime)", time0.Month + "", SearchFieldType.数值型));
list1.Add(new SearchField("day(plantime)", time0.Day + "", SearchFieldType.数值型));
Hashtable ht = comm1.SearchData(list1);
if (ht != null && ht.Count > 0)
{
this.subject.Text = ht["subject"].ToString();
this.remark.Text = ht["remark"].ToString();
this.id.Value = ht["id"].ToString();
}
else
{
this.Button2.Visible = false;
}
comm1.Close();
}
/// <summary>
///
/// </summary>
/// <param name="czid"></param>
/// <param name="kind"></param>
/// <returns></returns>
private ShenPi GetYiJian(String czid, String kind)
{
ShenPi info1 = null;
CommTable comm1 = new CommTable();
comm1.TabName = "U_ZCSP";
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("czid", czid));
condition.Add(new SearchField("kind", kind));
condition.Add(new SearchField("pscount", "0", SearchOperator.大于));
condition.Add(new SearchField("time1 is not null", "", SearchOperator.用户定义));
DataSet ds = comm1.SearchData("top 1 zeren,PS,remark,time1", condition, "id desc");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
info1 = new ShenPi();
info1.Ren = ds.Tables[0].Rows[0]["zeren"].ToString();
info1.ShiJian = ds.Tables[0].Rows[0]["time1"].ToString();
String temp1 = ds.Tables[0].Rows[0]["PS"].ToString().Trim();
String temp2 = ds.Tables[0].Rows[0]["remark"].ToString().Trim();
if (temp2 != String.Empty && kind != "11" && kind != "17")
{
info1.YiJian = temp1 + "(" + temp2 + ")";
}
else
{
info1.YiJian = temp1;
}
}
comm1.Close();
return(info1);
}
void Repeater3_ItemCommand(object source, RepeaterCommandEventArgs e)
{
String id = e.CommandArgument.ToString();
if (String.IsNullOrEmpty(id) == false)
{
CommTable com1 = new CommTable("DA_AJDZFile");
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("id", id, JSJ.SysFrame.SearchFieldType.数值型));
DataSet ds1 = com1.SearchData("*", condition);
if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
{
DataRow dr1 = ds1.Tables[0].Rows[0];
String fileName = dr1["ajTrueFile"].ToString();
if (String.IsNullOrEmpty(fileName) == false)
{
fileName = Server.MapPath("../Common/AttachFiles/" + fileName);
if (System.IO.File.Exists(fileName))
{
System.IO.File.Delete(fileName);
}
}
dr1.Delete();
com1.Update(ds1);
}
com1.Close();
this.BindData();
}
}
/// <summary>
/// 根据条件，得到选择的资产
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public DataSet GetSelectZcList(List <SearchField> condition)
{
CommTable com1 = new CommTable();
com1.TabName = "ZCView";
List <SearchField> condition1 = new List <SearchField>();
if (condition != null)
{
foreach (SearchField search1 in condition)
{
condition1.Add(search1);
}
}
condition1.Add(new SearchField("zeren", Comm.CurUser));
/*
* 增加不在资产包的条件(2010年1月2日修改 */
SearchField search2 = new SearchField("not exists (select * from u_zcbaoinfo where zcid=zcView.id)", "", SearchOperator.用户定义);
condition1.Add(search2);
DataSet ds = com1.SearchData("*,left(danwei,20) as danwei1", condition1, "num2");
com1.Close();
return(ds);
}
protected override void OnPreRenderComplete(EventArgs e)
{
if (!Page.IsPostBack)
{
//设置档案文件
//this.Repeater2.Visible = false;
String ajnum = this.num2.Text;
if (String.IsNullOrEmpty(ajnum))
{
ajnum = this.num2_1.Text;
}
if (String.IsNullOrEmpty(ajnum) == false)
{
CommTable com1 = new CommTable("DA_AJDZFile");
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("ajnum", ajnum));
DataSet ds1 = com1.SearchData("*", condition);
this.Repeater3.DataSource = ds1;
this.Repeater3.DataBind();
com1.Close();
}
}
base.OnPreRenderComplete(e);
}
private Hashtable getCalenderData(int year, int month)
{
Hashtable ht = new Hashtable();
CommTable comm1 = new CommTable();
comm1.TabName = "ZX_RCAP";
List <SearchField> list1 = new List <SearchField>();
list1.Add(new SearchField("sname", User.Identity.Name));
list1.Add(new SearchField("year(plantime)", year + "", SearchFieldType.数值型));
list1.Add(new SearchField("month(plantime)", month + "", SearchFieldType.数值型));
DataSet ds = comm1.SearchData("*", list1, "plantime");
comm1.Close();
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
string ptime = DateTime.Parse(dt.Rows[i]["plantime"].ToString()).ToString("yyyy-MM-dd");
string subject = "";
if (dt.Rows[i]["subject"] != DBNull.Value)
{
subject = dt.Rows[i]["subject"].ToString();
}
ht[ptime] = subject;
}
return(ht);
}
private void BindData()
{
int totalRow = 0;
CommTable comm1 = new CommTable();
comm1.TabName = "ZX_QuickTalk";
List <SearchField> list1 = new List <SearchField>();
list1.Add(new SearchField("tmen", User.Identity.Name));
DataSet ds1 = comm1.SearchData("*", list1, "id desc", 1, -1, out totalRow);
this.GridView1.DataSource = ds1;
this.GridView1.DataBind();
//隐藏删除等控件
if (totalRow > 0)
{
this.info2.Visible = true;
}
else
{
this.info2.Visible = false;
}
//将所有的短消息设置为已读
list1.Add(new SearchField("isRead", "0"));
Hashtable ht = new Hashtable();
ht["isRead"] = "1";
comm1.EditQuickData(list1, ht);
comm1.Close();
}
/// <summary>
/// 计算资产处置的累计回款
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public double GetHuiKuan(String id, ZCKind kind1)
{
double sum1 = 0;
CommTable com1 = new CommTable();
List <SearchField> condition = new List <SearchField>();
if (kind1 == ZCKind.单条资产)
{
com1.TabName = "CW_ShouKuan";
condition.Add(new SearchField("zcid", id, SearchFieldType.数值型));
}
else
{
com1.TabName = "CW_ShouKuan1";
condition.Add(new SearchField("bid", id, SearchFieldType.数值型));
}
condition.Add(new SearchField("checktime is not null", "", SearchOperator.用户定义));
DataSet ds1 = com1.SearchData("isnull(pbj,0)+isnull(plx,0) as sum0", condition);
foreach (DataRow dr in ds1.Tables[0].Rows)
{
sum1 = sum1 + double.Parse(dr["sum0"].ToString());
}
com1.Close();
return(sum1);
}
private void SetData()
{
CommTable comm1 = new CommTable("U_LawZC");
string id1 = Request.QueryString["id"];
if (String.IsNullOrEmpty(id1) == false)
{
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("id", id1, SearchFieldType.数值型));
DataSet ds1 = comm1.SearchData("*", condition);
if (ds1.Tables[0].Rows.Count > 0)
{
DataRow dr1 = ds1.Tables[0].Rows[0];
if (this.sname.Items.FindByValue(dr1["sname"].ToString().Trim()) != null)
{
this.sname.SelectedValue = dr1["sname"].ToString().Trim();
}
if (this.kind.Items.FindByValue(dr1["kind"].ToString().Trim()) != null)
{
this.kind.SelectedValue = dr1["kind"].ToString().Trim();
}
}
}
comm1.Close();
}
//判断当前用户是否为某部门的档案管理员
public static bool IsAdminForDepart(String depart)
{
bool result = false;
String user1 = Comm.CurUser;
if (user1.ToLower() == "admin")
{
result = true;
}
else
{
if (String.IsNullOrEmpty(user1) == false)
{
CommTable com1 = new CommTable("U_DepartDangAnAdminUsers");
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("sname", user1));
condition.Add(new SearchField("depart", depart));
DataSet ds1 = com1.SearchData("count(*)", condition);
if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
{
if (int.Parse(ds1.Tables[0].Rows[0][0].ToString()) > 0)
{
result = true;
}
}
com1.Close();
}
}
return(result);
}
protected void Button2_Click(object sender, EventArgs e)
{
String sel = Request.Form["selFile"];
if (String.IsNullOrEmpty(sel) == false)
{
CommTable comm1 = new CommTable();
comm1.TabName = "U_CZFile";
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("id", sel, SearchOperator.集合, SearchFieldType.数值型));
DataSet ds1 = comm1.SearchData("*", condition);
foreach (DataRow dr in ds1.Tables[0].Rows)
{
String fileName = dr["FileName"].ToString();
dr.Delete();
String file1 = Server.MapPath("~/Common/AttachFiles/" + fileName);
if (File.Exists(file1))
{
File.Delete(file1);
}
}
comm1.Update(ds1);
}
Response.Redirect(Request.PathInfo, true);
}
//判断当前用户是否只有法律顾问
private bool isOnlyLaw()
{
bool result = false;
CommTable tab1 = new CommTable("U_RoleUsers");
List <SearchField> list1 = new List <SearchField>();
list1.Add(new SearchField("sname", Page.User.Identity.Name));
DataSet ds1 = tab1.SearchData("role", list1);
string temp1 = String.Empty;
bool first = true;
foreach (DataRow dr1 in ds1.Tables[0].Rows)
{
if (dr1[0].ToString().Trim() != String.Empty)
{
if (first)
{
temp1 = dr1[0].ToString().Trim();
first = false;
}
else
{
temp1 = temp1 + "," + dr1[0].ToString().Trim();
}
}
}
tab1.Close();
if (temp1 == "法律顾问")
{
result = true;
}
return(result);
}
//更新管理员
public static void UpdateAdmin(String id, String num,
String depart, String sname)
{
if (String.IsNullOrEmpty(id))
{
id = "-1";
}
DataRow dr1 = null;
CommTable comm1 = new CommTable("U_DepartDangAnAdminUsers");
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("id", id, SearchFieldType.数值型));
DataSet ds1 = comm1.SearchData("*", condition);
if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
{
dr1 = ds1.Tables[0].Rows[0];
dr1["num"] = num;
dr1["depart"] = depart;
dr1["sname"] = sname;
}
else
{
dr1 = ds1.Tables[0].NewRow();
dr1["num"] = num;
dr1["depart"] = depart;
dr1["sname"] = sname;
ds1.Tables[0].Rows.Add(dr1);
}
comm1.Update(ds1);
comm1.Close();
}
/// <summary>
/// 得到法律顾问的资产责任人选项
/// </summary>
/// <returns></returns>
public static List <string> GetZerenForZc()
{
int total1 = 0;
List <string> list1 = new List <string>();
//得到资产的所有责任人
CommTable comm1 = new CommTable("U_ZC");
DataSet ds1 = comm1.SearchData("distinct zeren", null, "zeren", -1, -1, out total1);
foreach (DataRow dr1 in ds1.Tables[0].Rows)
{
String temp = dr1[0].ToString().Trim();
if (temp != String.Empty)
{
if (list1.Contains(temp) == false)
{
list1.Add(temp);
}
}
}
comm1.Close();
list1.Sort();
return(list1);
}
/// <summary>
/// 计算资产处置的累计支持
/// </summary>
/// <param name="czid"></param>
/// <returns></returns>
public double GetZhiChu(String id, ZCKind kind1)
{
double sum1 = 0;
CommTable com1 = new CommTable();
List <SearchField> condition = new List <SearchField>();
if (kind1 == ZCKind.单条资产)
{
com1.TabName = "CW_Pay";
condition.Add(new SearchField("zcid", id, SearchFieldType.数值型));
}
else
{
com1.TabName = "CW_Pay1";
condition.Add(new SearchField("bid", id, SearchFieldType.数值型));
}
condition.Add(new SearchField("checktime is not null", "", SearchOperator.用户定义));
String fields = @"isnull(fee1,0)+isnull(fee2,0)+isnull(fee3,0)+isnull(fee4,0)
+isnull(fee5,0)+isnull(fee6,0)+isnull(fee7,0)+isnull(fee8,0)
+isnull(fee9,0)+isnull(fee10,0)+isnull(fee11,0)+isnull(fee12,0)
+isnull(fee13,0)+isnull(fee14,0)+isnull(fee15,0)+isnull(fee16,0)
+isnull(fee17,0)+isnull(fee18,0)+isnull(fee19,0)+isnull(fee20,0) as sum0";
DataSet ds1 = com1.SearchData(fields, condition);
foreach (DataRow dr in ds1.Tables[0].Rows)
{
sum1 = sum1 + double.Parse(dr["sum0"].ToString());
}
com1.Close();
return(sum1);
}
/// <summary>
/// 得到资产已处置的数量
/// </summary>
/// <param name="zcid">资产ID或资产包ID</param>
/// <param name="kind">类别</param>
/// <returns></returns>
public int GetZcCount(int zcid, ZCKind kind)
{
int result = 0;
CommTable com1 = new CommTable();
com1.TabName = "U_Zc2";
List <SearchField> condition = new List <SearchField>();
if (kind == ZCKind.单条资产)
{
condition.Add(new SearchField("zcid", zcid + "", SearchFieldType.数值型));
}
else
{
condition.Add(new SearchField("zcbid", zcid + "", SearchFieldType.数值型));
}
DataSet ds1 = com1.SearchData("id", condition);
if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
{
result = ds1.Tables[0].Rows.Count;
}
com1.Close();
return(result);
}
//审批档案，agree为true表示同意，agree为false表示不同意
public static void ShenPiDangAn(String ID, bool agree)
{
CommTable com1 = new CommTable("DA_JyBill");
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("id", ID, SearchFieldType.数值型));
DataSet ds1 = com1.SearchData("*", condition);
if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
{
DataRow dr1 = ds1.Tables[0].Rows[0];
if (agree)
{
dr1["status"] = "1";
}
else
{
dr1["status"] = "0";
}
dr1["checkman"] = Comm.CurUser;
dr1["checktime"] = DateTime.Now.ToString();
dr1["time1"] = DateTime.Now.AddMonths(1);
com1.Update(ds1);
}
com1.Close();
}
private DataSet GetData(int curpage, out int totalRow)
{
totalRow = 0;
DataSet ds1 = new DataSet();
CommTable com1 = new CommTable("DA_AJDZFileSeeLog");
List <SearchField> condition = new List <SearchField>();
if (this.ajnum.Text.Trim() != String.Empty)
{
condition.Add(new SearchField("ajnum", this.ajnum.Text.Trim()));
}
if (this.domen.Text.Trim() != String.Empty)
{
condition.Add(new SearchField("domen", this.domen.Text.Trim(), SearchOperator.包含));
}
String[] arr1 = new String[] { "*" };
if (condition.Count == 0)
{
condition = null;
}
ds1 = com1.SearchData(arr1, condition, "id desc",
curpage,
this.PageNavigator1.PageSize,
out totalRow);
com1.Close();
return(ds1);
}
private void BindData()
{
CommTable comm1 = new CommTable();
comm1.TabName = "ZX_RCAP";
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("sname", User.Identity.Name));
if (Request.QueryString["time0"] != null && Request.QueryString["time0"] != String.Empty)
{
condition.Add(new SearchField("plantime", Request.QueryString["time0"], SearchOperator.大于等于));
}
if (Request.QueryString["time1"] != null && Request.QueryString["time1"] != String.Empty)
{
condition.Add(new SearchField("plantime", Request.QueryString["time1"], SearchOperator.小于等于));
}
DataSet ds1 = comm1.SearchData("*", condition, "plantime");
comm1.Close();
this.repeater1.DataSource = ds1;
this.repeater1.DataBind();
}
//写入档案日志
public static void WriteDAFileLog(String FileName, String remark)
{
CommTable tab1 = new CommTable("DA_AJDZFile");
List <SearchField> condition = new List <SearchField>();
SearchField search1 = new SearchField("ajTrueFile", FileName);
condition.Add(search1);
DataSet ds1 = tab1.SearchData("*", condition);
if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
{
DataRow dr1 = ds1.Tables[0].Rows[0];
tab1.TabName = "DA_AJDZFileSeeLog";
Hashtable ht1 = new Hashtable();
ht1["ajnum"] = dr1["ajnum"].ToString();
ht1["time0"] = DateTime.Now.ToString();
ht1["domen"] = Comm.CurUser.ToLower();
ht1["ajFile"] = dr1["ajFile"].ToString();
if (String.IsNullOrEmpty(remark) == false)
{
ht1["remark"] = remark;
}
tab1.InsertData(ht1);
}
tab1.Dispose();
tab1.Close();
}
//判断用户是否有部门的资产
public static bool HaveBuZC()
{
U_UserNameBU user1 = new U_UserNameBU();
String userName1 = user1.GetSelfAndXiaShu(Comm.CurUser);
user1.Close();
bool result = false;
CommTable com1 = new CommTable();
com1.TabName = "u_zc";
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("zeren", userName1, SearchOperator.集合));
DataSet ds = com1.SearchData("count(*) count1", condition);
com1.Close();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
if (Int32.Parse(ds.Tables[0].Rows[0][0].ToString()) > 0)
{
result = true;
}
}
return(result);
}
/// <summary>
/// 检查是否是审核委员会主席，如果是，则判断其他用户是否已审批
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
private String CheckShenHeWeiYuanZhuXi(String id)
{
String domen = "";
CommTable comm1 = new CommTable();
comm1.TabName = "U_ZCSP";
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("id", id));
DataSet dt0 = comm1.SearchData("czid,zx,kind,zeren", condition);
if (dt0.Tables[0].Rows.Count > 0)
{
DataRow dr0 = dt0.Tables[0].Rows[0];
if (dr0["zx"].ToString().Trim() != String.Empty)
{
String czid = dr0["czid"].ToString();
String zeren1 = dr0["zeren"].ToString();
if (dr0["kind"].ToString() == "13" ||
dr0["kind"].ToString() == "15")
{
condition.Clear();
condition.Add(new SearchField("czid", czid));
condition.Add(new SearchField("zeren", zeren1,
SearchOperator.等于));
condition.Add(new SearchField("time1 is null", "",
SearchOperator.用户定义));
//查询数据
DataSet ds0 = comm1.SearchData("zeren", condition);
foreach (DataRow dr in ds0.Tables[0].Rows)
{
if (domen == String.Empty)
{
domen = dr["zeren"].ToString();
}
else
{
domen = domen + ";" + dr["zeren"].ToString();
}
}
}
}
}
comm1.Close();
return(domen);
}
//得到档案管理员列表
public static DataSet GetAdminList()
{
CommTable comm1 = new CommTable("U_DepartDangAnAdminUsers");
List <SearchField> condition = null;
DataSet ds1 = comm1.SearchData("*", condition);
comm1.Close();
return(ds1);
}
private void BindData()
{
CommTable com1 = new CommTable("U_TimeType");
List <SearchField> condition = new List <SearchField>();
DataSet ds1 = com1.SearchData("*", condition, "num");
this.GridView1.DataSource = ds1;
this.GridView1.DataBind();
com1.Close();
}
private void BindData()
{
CommTable comm1 = new CommTable("U_LawZC");
int totalRow = 0;
DataSet ds1 = comm1.SearchData("*", null, "sname,id desc", -1, -1, out totalRow);
this.GridView1.DataSource = ds1;
this.GridView1.DataBind();
comm1.Close();
}
//绑定资产列表
private DataSet GetZXListData(CommTable com1, string status1)
{
com1.TabName = "U_ZCTC";
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("status1", status1));
condition.Add(new SearchField("czid", this.CzID, SearchFieldType.数值型));
DataSet ds1 = com1.SearchData("*,left(remark,50) remark1", condition, "time0 ");
return(ds1);
}
private void BindData()
{
CommTable comm1 = new CommTable("U_ZC2");
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("zcid", Request.QueryString["id"], SearchFieldType.数值型));
DataSet ds1 = comm1.SearchData("*", condition, "id desc");
this.repeater1.DataSource = ds1;
this.repeater1.DataBind();
comm1.Close();
}
private void BindData(String timetypecode)
{
CommTable comm1 = new CommTable("U_TimeTypeDetail");
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("timetypecode", timetypecode));
DataSet ds1 = comm1.SearchData("*", condition, "num");
comm1.Close();
this.Repeater1.DataSource = ds1;
this.Repeater1.DataBind();
}
