void button1_Click(object sender, EventArgs e)
{
WebFrame.Data.JTable tab1 = new WebFrame.Data.JTable("PERSONGZ");
System.Collections.Generic.List <WebFrame.Data.SearchField> condition =
new System.Collections.Generic.List <WebFrame.Data.SearchField>();
System.Collections.Generic.Dictionary <String, object> data1 =
new System.Collections.Generic.Dictionary <string, object>();
int i = 10;
String[] arr1 = "Qtfy".Split(',');
foreach (RepeaterItem item in this.Repeater1.Items)
{
condition.Clear();
condition.Add(new WebFrame.Data.SearchField("num", i + "", WebFrame.SearchFieldType.NumericType));
data1.Clear();
foreach (String m in arr1)
{
TextBox t1 = item.FindControl(m) as TextBox;
if (t1 != null)
{
data1[m] = t1.Text;
}
}
tab1.EditData(data1, condition);
i++;
}
tab1.Close();
BusinessRule.PersonGZProfile.SetData();
WebFrame.Util.JAjax.Alert("提示：更新数据操作成功！");
}
private void TongBuData()
{
WebFrame.Data.JConnect conn0 = WebFrame.Data.JConnect.GetConnect("DefaultConnstring");
WebFrame.Data.JConnect conn1 = WebFrame.Data.JConnect.GetConnect("HKConnstring");
if (conn0 != null && conn1 != null)
{
WebFrame.Data.JTable tab0 = new WebFrame.Data.JTable(conn0, "U_UserName");
WebFrame.Data.JTable tab1 = new WebFrame.Data.JTable(conn1, "U_UserName");
List <WebFrame.Data.SearchField> condition = new List <WebFrame.Data.SearchField>();
condition.Add(new WebFrame.Data.SearchField("lockflag is null", "", WebFrame.SearchOperator.UserDefine));
DataSet ds0 = tab0.SearchData(condition, -1, "*");
DataSet ds1 = null;
DataRow dr1 = null;
String[] arr1 = new String[] { "num", "sname", "px", "depart", "job", "password",
"cell", "email", "login", "leader",
"phone", "lockflag" };
foreach (DataRow dr0 in ds0.Tables[0].Rows)
{
condition.Clear();
condition.Add(new WebFrame.Data.SearchField("Sname", dr0["Sname"].ToString()));
ds1 = tab1.SearchData(condition, -1, "*");
if (ds1 != null)
{
if (ds1.Tables[0].Rows.Count > 0)
{
dr1 = ds1.Tables[0].Rows[0];
}
else
{
dr1 = ds1.Tables[0].NewRow();
ds1.Tables[0].Rows.Add(dr1);
}
foreach (String m in arr1)
{
dr1[m] = dr0[m];
}
tab1.Update(ds1.Tables[0]);
}
}
conn0.Dispose();
conn1.Dispose();
JSJ.SysFrame.Util.alert(this.Page, "提示：同步数据操作成功！");
}
}
private void BindData()
{
String trainkind = Request.QueryString["kind"];
WebFrame.Data.JTable tab1 = new WebFrame.Data.JTable("NewTrain");
tab1.OrderBy = "trainname";
System.Collections.Generic.List <WebFrame.Data.SearchField> list1
= new List <WebFrame.Data.SearchField>();
list1.Add(new WebFrame.Data.SearchField("TrainType", trainkind));
System.Data.DataSet ds1 = tab1.SearchData(list1, -1, "trainname");
tab1.Close();
this.repeater1.DataSource = ds1;
this.repeater1.DataBind();
}
void button2_Click(object sender, EventArgs e)
{
WebFrame.Data.JTable tab1 = new WebFrame.Data.JTable("A2A3FEE");
System.Collections.Generic.List <WebFrame.Data.SearchField> condition =
new System.Collections.Generic.List <WebFrame.Data.SearchField>();
System.Collections.Generic.Dictionary <String, object> data1 =
new System.Collections.Generic.Dictionary <string, object>();
int i = 1;
String[] arr1 = "A2Fee,A3Fee".Split(',');
foreach (RepeaterItem item in this.Repeater2.Items)
{
condition.Clear();
condition.Add(new WebFrame.Data.SearchField("num", i + "", WebFrame.SearchFieldType.NumericType));
data1.Clear();
foreach (String m in arr1)
{
TextBox t1 = item.FindControl(m) as TextBox;
if (t1 != null)
{
if (t1.Text.Trim() != String.Empty)
{
data1[m] = t1.Text;
}
else
{
data1[m] = "0";
}
}
}
tab1.EditData(data1, condition);
i++;
}
tab1.Close();
BusinessRule.CheXianProfile.SetData();
BusinessRule.RiChangFeeProfile.SetData();
BusinessRule.A2A3FeeProfile.SetData();
WebFrame.Util.JAjax.Alert("提示：更新数据操作成功！");
}
private void TongBuData()
{
WebFrame.Data.JConnect conn0 = WebFrame.Data.JConnect.GetConnect("DefaultConnstring");
WebFrame.Data.JConnect conn1 = WebFrame.Data.JConnect.GetConnect("HKConnstring");
if (conn0 != null && conn1 != null)
{
WebFrame.Data.JTable tab0 = new WebFrame.Data.JTable(conn0, "U_UserName");
WebFrame.Data.JTable tab1 = new WebFrame.Data.JTable(conn1, "U_UserName");
List <WebFrame.Data.SearchField> condition = new List <WebFrame.Data.SearchField>();
DataSet ds0 = tab0.SearchData(null, -1, "*");
DataSet ds1 = null;
DataRow dr1 = null;
String[] arr1 = new String[] { "num", "sname", "px", "depart", "job", "password", "cell", "email", "login", "leader",
"phone", "lockflag", "zeren1" };
foreach (DataRow dr0 in ds0.Tables[0].Rows)
{
condition.Clear();
condition.Add(new WebFrame.Data.SearchField("Sname", dr0["Sname"].ToString()));
ds1 = tab1.SearchData(condition, -1, "*");
if (ds1 != null)
{
if (ds1.Tables[0].Rows.Count > 0)
{
dr1 = ds1.Tables[0].Rows[0];
}
else
{
dr1 = ds1.Tables[0].NewRow();
}
}
}
conn0.Dispose();
conn1.Dispose();
}
}
