/// <summary>
/// 生成报名序号
/// </summary>
/// <param name="xuexiao"></param>
/// <param name="kelei"></param>
/// <param name="makeType"></param>
private void MakeBmxh(string xuexiao, string kelei, string makeType)
{
if (makeType == "4")
{
int xh = 1;//序号
var list1 = Bmk.Find(p => p.hk != "88" && p.hk != "99", "class,xstbh");
foreach (var bmk in list1)
{
bmk.bmxh = string.Format("{0}{1}{2}", xuexiao, kelei, xh.ToString().PadLeft(4, '0'));
bmk.Save();
xh++;
}
var list2 = Bmk.Find(p => p.hk == "88" || p.hk == "99", "class,xstbh");
foreach (var bmk in list2)
{
bmk.bmxh = string.Format("{0}{1}{2}", xuexiao, kelei, xh.ToString().PadLeft(4, '0'));
bmk.Save();
xh++;
}
this.MessageBox("OK");
}
else
{
MessageBox("未实现");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var list = Bmk.Find(p => p.bj == this.Bj, "bmxh");
if (list.Count > 35)
{
this.GridView1.RowStyle.Height = (Unit)23;
}
else
{
this.GridView1.RowStyle.Height = (Unit)28;
}
this.GridView1.DataSource = list;
this.GridView1.DataBind();
this.tc1 = 0;
this.tc2 = 0;
this.tc3 = 0;
this.tc4 = 0;
this.tc5 = 0;
this.tc6 = 0;
this.tc7 = 0;
}
}
private void BindData()
{
this.GridView1.EnableViewState = false;
this.GridView1.DataSource = Bmk.Find(p => p.bj == this.Bj, "bmxh");
this.GridView1.DataBind();
this.GridView1.Caption = string.Format("鹿城实验中学2011级{0}班中考志愿确认表（总共{0}人）", this.GridView1.Rows.Count);
}
/// <summary>
/// 更新数据到报名
/// </summary>
/// <param name="bmk"></param>
private int UpdateBmkBase(Bmk bmk)
{
ArrayList al = new ArrayList();
//报名序号
al.Add(OleDbHelper.CreateInParam("bmxh", OleDbType.Char, 9, bmk.bmxh));
al.Add(OleDbHelper.CreateInParam("xm", OleDbType.Char, 8, bmk.xm));
al.Add(OleDbHelper.CreateInParam("sfzh", OleDbType.Char, 18, bmk.sfzh));
al.Add(OleDbHelper.CreateInParam("xb", OleDbType.Char, 1, bmk.xb));
al.Add(OleDbHelper.CreateInParam("mz", OleDbType.Char, 1, bmk.mz));
al.Add(OleDbHelper.CreateInParam("csny", OleDbType.Char, 8, bmk.csny));
al.Add(OleDbHelper.CreateInParam("hk", OleDbType.Char, 2, bmk.hk));
al.Add(OleDbHelper.CreateInParam("syqk", OleDbType.Char, 1, bmk.syqk));
al.Add(OleDbHelper.CreateInParam("kslb", OleDbType.Char, 1, bmk.kslb));
al.Add(OleDbHelper.CreateInParam("byxxdm", OleDbType.Char, 4, bmk.byxxdm));
al.Add(OleDbHelper.CreateInParam("byxxmc", OleDbType.Char, 16, bmk.byxxmc));
al.Add(OleDbHelper.CreateInParam("xh", OleDbType.Char, 2, bmk.xh));
al.Add(OleDbHelper.CreateInParam("class", OleDbType.Char, 2, bmk.bj));
al.Add(OleDbHelper.CreateInParam("jtzz", OleDbType.Char, 50, bmk.jtzz));
al.Add(OleDbHelper.CreateInParam("tel", OleDbType.Char, 30, bmk.tel));
al.Add(OleDbHelper.CreateInParam("post", OleDbType.Char, 6, bmk.post));
al.Add(OleDbHelper.CreateInParam("ty", OleDbType.Char, 1, bmk.ty ));
al.Add(OleDbHelper.CreateInParam("bz1", OleDbType.Char, 2, bmk.bz1));
al.Add(OleDbHelper.CreateInParam("xstbh", OleDbType.Char, 9, bmk.xstbh));
string strSql = @"update bmk ";//
strSql += " set bmxh = ? , xm = ? , sfzh = ? , xb = ? ,mz = ? , csny = ?, hk = ? ,syqk= ? , kslb = ? , byxxdm = ?, byxxmc = ?, xh = ? , class = ? , jtzz = ? , tel = ? , post = ? ,ty = ? ,bz1 = ? ";
strSql += " where xstbh = ? ";
return OleDbHelper.ExcuteSQL(this.VfpConnection, strSql, (OleDbParameter[])al.ToArray(typeof(OleDbParameter)));
}
/// <summary>
/// 插入报名信息表
/// </summary>
/// <param name="bmk"></param>
/// <returns></returns>
private int InsertBmkBase(Bmk bmk)
{
ArrayList al = new ArrayList();
//报名序号
al.Add(OleDbHelper.CreateInParam("bmxh", OleDbType.Char, 9, bmk.bmxh ?? ""));
al.Add(OleDbHelper.CreateInParam("xstbh", OleDbType.Char, 9, bmk.xstbh));
al.Add(OleDbHelper.CreateInParam("sfzh", OleDbType.Char, 18, bmk.sfzh));
al.Add(OleDbHelper.CreateInParam("xb", OleDbType.Char, 1, bmk.xb));
al.Add(OleDbHelper.CreateInParam("mz", OleDbType.Char, 1, bmk.mz));
al.Add(OleDbHelper.CreateInParam("csny", OleDbType.Char, 8, bmk.csny));
al.Add(OleDbHelper.CreateInParam("hk", OleDbType.Char, 2, bmk.hk));
al.Add(OleDbHelper.CreateInParam("syqk", OleDbType.Char, 1, bmk.syqk));
al.Add(OleDbHelper.CreateInParam("kslb", OleDbType.Char, 1, bmk.kslb));
al.Add(OleDbHelper.CreateInParam("byxxdm", OleDbType.Char, 4, bmk.byxxdm));
al.Add(OleDbHelper.CreateInParam("byxxmc", OleDbType.Char, 16, bmk.byxxmc));
al.Add(OleDbHelper.CreateInParam("xh", OleDbType.Char, 2, bmk.xh));
al.Add(OleDbHelper.CreateInParam("class", OleDbType.Char, 2, bmk.bj));
al.Add(OleDbHelper.CreateInParam("jtzz", OleDbType.Char, 50, bmk.jtzz));
al.Add(OleDbHelper.CreateInParam("tel", OleDbType.Char, 30, bmk.tel));
al.Add(OleDbHelper.CreateInParam("post", OleDbType.Char, 6, bmk.post));
al.Add(OleDbHelper.CreateInParam("zkzh", OleDbType.Char, 11, bmk.zkzh));
string strSql = @"insert into bmk (bmxh,xstbh,sfzh,
xb,mz,csny,hk,syqk, kslb,byxxdm,byxxmc,xh,class,
jtzz,tel,post)";
strSql += " values (?,?,?, ?,?,?,?,?, ?,?,?,?,?, ?,?,?) ";
Debug.Write(strSql);
return OleDbHelper.ExcuteSQL(this.VfpConnection, strSql, (OleDbParameter[])al.ToArray(typeof(OleDbParameter)));
// return 1;
}
/// <summary>
/// 导入综合素质数据
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
private bool ImportZhongheSuzi(DataTable dt)
{
foreach (DataRow dr in dt.Rows)
{
string xjh = dr["学籍号"].ToString();
Bmk bmk = Bmk.FindOne(p => p.xstbh == xjh);
if (bmk != null)
{
// 审美与艺术 运动与健康 探究与实践 劳动与技能 综合表现
if (dt.Columns.Contains("审美与艺术"))
bmk.km71 = dr["审美与艺术"].ToString();
if (dt.Columns.Contains("运动与健康"))
bmk.km72 = dr["运动与健康"].ToString();
if (dt.Columns.Contains("探究与实践"))
bmk.km73 = dr["探究与实践"].ToString();
if (dt.Columns.Contains("劳动与技能"))
bmk.km74 = dr["劳动与技能"].ToString();
if (dt.Columns.Contains("综合表现评定"))
bmk.km81 = dr["综合表现评定"].ToString();
if (dt.Columns.Contains("综合表现评语"))
bmk.km8 = dr["综合表现评语"].ToString();
bmk.Save();
}
}
return true;
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
CheckBoxList cbl = (CheckBoxList)e.Row.FindControl("CheckBoxList1");
Bmk bmk = (Bmk)e.Row.DataItem;
if (bmk.xb == "1")
{
cbl.Items[6].Enabled = false;
}
else if (bmk.xb == "2")
{
cbl.Items[5].Enabled = false;
}
if (!String.IsNullOrWhiteSpace(bmk.tcxm))
{
char tcxm1 = bmk.tcxm[0];
char tcxm2 = bmk.tcxm[1];
if (cbl.Items.FindByValue(tcxm1.ToString()) != null)
{
cbl.Items.FindByValue(tcxm1.ToString()).Selected = true;
}
if (cbl.Items.FindByValue(tcxm2.ToString()) != null)
{
cbl.Items.FindByValue(tcxm2.ToString()).Selected = true;
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
this.lblMsg.Text = string.Empty;
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
Bmk bmk = Bmk.FindById((long)this.GridView1.DataKeys[i].Value);
CheckBoxList cbl = (CheckBoxList)this.GridView1.Rows[i].FindControl("CheckBoxList1");
string str = string.Empty;
foreach (ListItem item in cbl.Items)
{
if (item.Selected)
{
str += item.Value;
}
}
if (str.Length == 2 && str != bmk.tcxm)
{
bmk.tcxm = str;
bmk.Save();
}
else if (String.IsNullOrEmpty(str))
{
bmk.tcxm = string.Empty;
bmk.Save();
}
else if (str.Length != 2)
{
this.lblMsg.Text += bmk.xm + "的数据录入有误:" + str + "<br />";
}
}
if (!string.IsNullOrEmpty(this.lblMsg.Text))
{
// JsUtil.MessageBox(this,this.lblMsg.Text);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.GridView1.DataSource = Bmk.Find(p => p.bj == this.Bj, "bmxh");
this.GridView1.DataBind();
}
}
private static void SystemInit()
{
Bmk.GetCount(Condition.Empty);
if (!Roles.RoleExists("Administrators"))
{
Roles.CreateRole("Administrators");
}
if (!Roles.RoleExists("Teachers"))
{
Roles.CreateRole("Teachers");
}
if (!Roles.RoleExists("Students"))
{
Roles.CreateRole("Students");
}
if (!Roles.RoleExists("input"))
{
Roles.CreateRole("input");
}
if (Membership.GetUser("admin") == null)
{
Membership.CreateUser("admin", "admin");
}
//录入员
if (Membership.GetUser("input1") == null)
{
Membership.CreateUser("input1", "input1");
}
if (Membership.GetUser("input2") == null)
{
Membership.CreateUser("input2", "input2");
}
if (!Roles.IsUserInRole("admin", "Administrators"))
{
Roles.AddUserToRole("admin", "Administrators");
}
if (!Roles.IsUserInRole("admin", "Teachers"))
{
Roles.AddUserToRole("admin", "Teachers");
}
if (!Roles.IsUserInRole("admin", "input"))
{
Roles.AddUserToRole("admin", "input");
}
if (!Roles.IsUserInRole("input1", "input"))
{
Roles.AddUserToRole("input1", "input");
}
if (!Roles.IsUserInRole("input2", "input"))
{
Roles.AddUserToRole("input2", "input");
}
}
private void BindData()
{
this.GridView1.EnableViewState = false;
Condition con = null;
string orderStr = "";
switch (this.ddlHk.SelectedValue)
{
case "1":
con &= CK.K["hk"] == "25";
break;
case "2":
con &= CK.K["hk"] != "25";
con &= CK.K["hk"] != "88";
con &= CK.K["hk"] != "99";
break;
case "3":
con &= (CK.K["hk"] == "88" | CK.K["hk"] == "99");
break;
default:
break;
}
if (this.ddlSyqk.SelectedIndex > 0)
{
con &= CK.K["syqk"] == this.ddlSyqk.SelectedValue;
}
if (this.ddlBj.SelectedIndex != this.ddlBj.Items.Count - 1)
{
con &= CK.K["class"] == this.ddlBj.SelectedValue;
}
switch (this.ddlOrder.SelectedValue)
{
case "0":
orderStr = "xstbh";
break;
case "1":
orderStr = "bmxh";
break;
case "2":
orderStr = "hk,xstbh";
break;
default:
orderStr = "hk,xstbh";
break;
}
this.GridView1.DataSource = Bmk.Find(con, orderStr);
this.GridView1.DataBind();
lblMsg.Text = string.Format("总共{0}人", this.GridView1.Rows.Count);
}
protected override void AddPermitRoles()
{
if (User.IsInRole("Students") && Bmk.GetCount(p => p.xstbh == this.User.Identity.Name) == 0)
{
throw new Exception("中考报名库中没有你的名字，若你是初三学生，请尽快联系教务处解决此问题");
}
this.AddPermitRole("Teachers");
this.AddPermitRole("Students");
base.AddPermitRoles();
}
/// <summary>
/// 保存数据到文件
/// </summary>
/// <param name="bmk"></param>
private void Save2File(Bmk bmk)
{
string filepath = "~/Data/BmkHistory/" + bmk.RecordGuid.ToString() + ".txt";
filepath = Server.MapPath(filepath);
if (!File.Exists(filepath))
{
FileHelper.CreateFile(filepath);
}
FileHelper.WriteLine(filepath, bmk.Json());
}
private void SaveData()
{
this.lblMsg.Text = string.Empty;
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
Bmk bmk = Bmk.FindById((long)this.GridView1.DataKeys[i].Value);
TextBox txtKm8 = (TextBox)this.GridView1.Rows[i].FindControl("txtKm8");
bmk.km8 = txtKm8.Text;
bmk.Save();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
long id = (long)this.GridView1.DataKeys[e.RowIndex].Value;
Bmk stu = Bmk.FindById(id);
if (stu != null)
{
Leafing.Core.Logging.Logger.Default.Info(string.Format("{0}删除了报考学生信息{1}", this.User.Identity, stu.Json()));
stu.Delete();
}
this.BindData();
}
protected void btnTy_Click(object sender, EventArgs e)
{
var list = Bmk.Find(Condition.Empty);
foreach (var item in list)
{
if (item.ty.IsNullOrEmpty())
{
item.ty = "0";
item.Save();
}
}
this.MessageBox("OK");
}
private void BindData()
{
if (this.ddlBj.SelectedIndex == this.ddlBj.Items.Count - 1)
{
this.GridView1.DataSource = Bmk.Find(Condition.Empty, "bmxh"); // Bmk.Find(p => p.bj == this.Bj);
}
else
{
this.GridView1.DataSource = Bmk.Find(p => p.bj == this.ddlBj.SelectedValue, "bmxh");
}
this.GridView1.DataBind();
lblMsg.Text = string.Format("总共{0}人", this.GridView1.Rows.Count);
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Bmk bmk = e.Row.DataItem as Bmk;
DropDownList ddlKm81 = (DropDownList)e.Row.FindControl("ddlKm81");
if (!string.IsNullOrWhiteSpace(bmk.km81))
{
if (ddlKm81.Items.FindByText(bmk.km81) != null)
{
ddlKm81.Items.FindByText(bmk.km81).Selected = true;
}
}
}
}
protected void btnBatchSeting_Click(object sender, EventArgs e)
{
var list = Bmk.Find(Condition.Empty);
foreach (var item in list)
{
if (item.byxxdm.IsNullOrEmpty())
{
item.byxxdm = this.txtByxxdm.Text;
item.byxxmc = this.txtByxxmc.Text;
item.Save();
}
}
this.MessageBox("OK");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.GridView1.DataSource = Bmk.Find(Condition.Empty, "bmxh");
this.GridView1.DataBind();
this.tc1 = 0;
this.tc2 = 0;
this.tc3 = 0;
this.tc4 = 0;
this.tc5 = 0;
this.tc6 = 0;
this.tc7 = 0;
}
}
private void BindData()
{
this.GridView1.Columns[3].Visible = this.Xm == "km61";
this.GridView1.Columns[4].Visible = this.Xm == "km62";
this.GridView1.Columns[5].Visible = this.Xm == "km63";
this.GridView1.Columns[6].Visible = this.Xm == "km71";
this.GridView1.Columns[7].Visible = this.Xm == "km72";
this.GridView1.Columns[8].Visible = this.Xm == "km73";
this.GridView1.Columns[9].Visible = this.Xm == "km74";
this.GridView1.Columns[10].Visible = this.Xm == "km81";
this.GridView1.DataSource = Bmk.Find(p => p.bj == this.Bj);
this.GridView1.DataBind();
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
CheckBoxList cbl = (CheckBoxList)e.Row.FindControl("CheckBoxList1");
Bmk bmk = (Bmk)e.Row.DataItem;
if (bmk.xb == "1")
{
cbl.Items[6].Enabled = false;
}
else if (bmk.xb == "2")
{
cbl.Items[5].Enabled = false;
}
}
}
private void BindData()
{
hlPrint.NavigateUrl = string.Format("frmZhiyuanListPrint.aspx?bj={0}", this.ddlBj.SelectedValue);
hlPrint.Target = "_blank";
this.GridView1.EnableViewState = false;
if (this.ddlBj.SelectedIndex == this.ddlBj.Items.Count - 1)
{
this.GridView1.DataSource = Bmk.Find(Condition.Empty, "bmxh"); // Bmk.Find(p => p.bj == this.Bj);
}
else
{
this.GridView1.DataSource = Bmk.Find(p => p.bj == this.ddlBj.SelectedValue, "bmxh");
}
this.GridView1.DataBind();
lblMsg.Text = string.Format("总共{0}人", this.GridView1.Rows.Count);
}
/// <summary>
/// 邮政编码为空设为
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnPost_Click(object sender, EventArgs e)
{
if (this.txtPost.Text.Length != 6)
{
this.MessageBox("邮政编码必须为6位");
return;
}
var list = Bmk.Find(Condition.Empty);
foreach (var item in list)
{
if (item.post.Length != 6)
{
item.post = this.txtPost.Text;
item.post = this.txtPost.Text;
item.Save();
}
}
this.MessageBox("OK");
}
protected void btnPwd_Click(object sender, EventArgs e)
{
PasswordGenerator pg = new PasswordGenerator();
pg.ExcludeSymbols = true;
pg.Exclusions = "0oABCDEFGHIJKLMNOPQRSTUVWXYZ`~!@#$^*()-_=+[]{}\\|;:'\",./";
pg.Maximum = 10;
pg.Minimum = 6;
var list = Bmk.Find(Condition.Empty);
foreach (var stu in list)
{
string xh = stu.xstbh.Trim();
MembershipUser user = Membership.GetUser(xh);
if (user != null)
{
string oldPwd = user.ResetPassword();
stu.Password = pg.Generate();
stu.Save();
user.ChangePassword(oldPwd, stu.Password.Trim());
if (Roles.IsUserInRole(xh, "Students") == false)
{
Roles.AddUserToRole(xh, "Students");
}
}
else
{
stu.Password = pg.Generate();
stu.Save();
Membership.CreateUser(xh, stu.Password.Trim());
if (Roles.IsUserInRole(xh, "Students") == false)
{
Roles.AddUserToRole(xh, "Students");
}
}
}
this.BindData();
}
protected void btnInit_Click(object sender, EventArgs e)
{
var list = Bmk.Find(Condition.Empty);
foreach (var bmk in list)
{
if (bmk.tcxm.Contains("2"))
{
Youyong youyong = Youyong.FindOne(p => p.bmxh == bmk.bmxh);
if (youyong == null)
{
youyong = new Youyong();
}
youyong.bmxh = bmk.bmxh;
youyong.xm = bmk.xm;
youyong.xb = bmk.xb;
youyong.Save();
}
}
this.Succeed("游泳学生数据初始化成功");
CountRenshu();
}
/// <summary>
/// 导入学生名单
/// </summary>
/// <param name="datatable">数据表</param>
/// <returns>是否成功</returns>
private bool ImportStudent(DataTable datatable)
{
foreach (DataRow dr in datatable.Rows)
{
Bmk bmk = Bmk.FindOne(p => p.bmxh == dr["bmxh"].ToString());
if (bmk == null)
bmk = new Bmk();
bmk.byxxdm = dr["byxxdm"].ToString();
bmk.byxxmc = dr["byxxmc"].ToString();
bmk.bmxh = dr["bmxh"].ToString();
bmk.xm = dr["xm"].ToString();
bmk.bj = dr["class"].ToString();
bmk.xh = dr["xh"].ToString();
bmk.xstbh = dr["xstbh"].ToString();
bmk.sfzh = dr["sfzh"].ToString();
bmk.xb = dr["xb"].ToString();
bmk.csny = dr["csny"].ToString();
bmk.ty = dr["ty"].ToString();
bmk.mz = dr["mz"].ToString();
bmk.kslb = dr["kslb"].ToString();
bmk.hk = dr["hk"].ToString();
bmk.tel = dr["tel"].ToString();
bmk.jtzz = dr["jtzz"].ToString();
bmk.post = dr["post"].ToString();
bmk.syqk = dr["syqk"].ToString();
bmk.bz1 = dr["bz1"].ToString();
bmk.bz2 = dr["bz2"].ToString();
bmk.bz3 = dr["bz3"].ToString();
bmk.bz4 = dr["bz4"].ToString();
bmk.Save();
}
return true;
}
private static void ImportFromJson(string jsonContent)
{
var list = JsonConvert.DeserializeObject <List <Bmk> >(jsonContent);
foreach (var item in list)
{
Bmk bmk = null;
if (item.bmxh.IsNullOrEmpty() == false)
{
bmk = Bmk.FindOne(p => p.bmxh == item.bmxh);
}
else
{
bmk = Bmk.FindOne(p => p.RecordGuid == item.RecordGuid);
}
if (bmk == null)
{
bmk = new Bmk();
}
ModelCopier.CopyModel(item, bmk, new[] { "Id" });
bmk.Save();
}
}
private static void ImportFromJson(string jsonContent)
{
var list = JsonConvert.DeserializeObject<List<Bmk>>(jsonContent);
foreach (var item in list)
{
Bmk bmk = null;
if (item.bmxh.IsNullOrEmpty() == false)
{
bmk = Bmk.FindOne(p => p.bmxh == item.bmxh);
}
else
{
bmk = Bmk.FindOne(p => p.RecordGuid == item.RecordGuid);
}
if (bmk == null)
{
bmk = new Bmk();
}
ModelCopier.CopyModel(item, bmk, new[] { "Id" });
bmk.Save();
}
}
private void BindData()
{
this.GridView1.DataSource = Bmk.Find(p => p.bj == this.Bj, p => p.bmxh);
this.GridView1.DataBind();
}
/// <summary>
/// 保存数据到文件
/// </summary>
/// <param name="bmk"></param>
private void Save2File(Bmk bmk)
{
string filepath = "~/Data/BmkHistory/" + bmk.RecordGuid.ToString() + ".txt";
filepath = Server.MapPath(filepath);
if(!File.Exists(filepath))
FileHelper.CreateFile(filepath);
FileHelper.WriteLine(filepath,bmk.Json());
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Bmk bmk = (Bmk)e.Row.DataItem;
if (!String.IsNullOrWhiteSpace(bmk.tcxm) && bmk.tcxm.Length == 2)
{
char strTcxm1 = bmk.tcxm[0];
char strTcxm2 = bmk.tcxm[1];
switch (strTcxm1)
{
case '1':
tc1++;
break;
case '2':
tc2++;
break;
case '3':
tc3++;
break;
case '4':
tc4++;
break;
case '5':
tc5++;
break;
case '6':
tc6++;
break;
case '7':
tc7++;
break;
default:
break;
}
switch (strTcxm2)
{
case '1':
tc1++;
break;
case '2':
tc2++;
break;
case '3':
tc3++;
break;
case '4':
tc4++;
break;
case '5':
tc5++;
break;
case '6':
tc6++;
break;
case '7':
tc7++;
break;
default:
break;
}
Label lblTc1 = (Label)e.Row.FindControl("lblTc1");
lblTc1.Text = bmk.CheckTcxm('1') ? "√" : "";
Label lblTc2 = (Label)e.Row.FindControl("lblTc2");
lblTc2.Text = bmk.CheckTcxm('2') ? "√" : "";
Label lblTc3 = (Label)e.Row.FindControl("lblTc3");
lblTc3.Text = bmk.CheckTcxm('3') ? "√" : "";
Label lblTc4 = (Label)e.Row.FindControl("lblTc4");
lblTc4.Text = bmk.CheckTcxm('4') ? "√" : "";
Label lblTc5 = (Label)e.Row.FindControl("lblTc5");
lblTc5.Text = bmk.CheckTcxm('5') ? "√" : "";
Label lblTc6 = (Label)e.Row.FindControl("lblTc6");
lblTc6.Text = bmk.CheckTcxm('6') ? "√" : "";
Label lblTc7 = (Label)e.Row.FindControl("lblTc7");
lblTc7.Text = bmk.CheckTcxm('7') ? "√" : "";
}
}
else if (e.Row.RowType == DataControlRowType.Footer)
{
Label lblTc1 = (Label)e.Row.FindControl("lblTc1");
lblTc1.Text = tc1.ToString();
Label lblTc2 = (Label)e.Row.FindControl("lblTc2");
lblTc2.Text = tc2.ToString();
Label lblTc3 = (Label)e.Row.FindControl("lblTc3");
lblTc3.Text = tc3.ToString();
Label lblTc4 = (Label)e.Row.FindControl("lblTc4");
lblTc4.Text = tc4.ToString();
Label lblTc5 = (Label)e.Row.FindControl("lblTc5");
lblTc5.Text = tc5.ToString();
Label lblTc6 = (Label)e.Row.FindControl("lblTc6");
lblTc6.Text = tc6.ToString();
Label lblTc7 = (Label)e.Row.FindControl("lblTc7");
lblTc7.Text = tc7.ToString();
}
}
private void ImportStudent()
{
string dbfPath = Server.MapPath("~/Data/Dbf/userdbfs/");
string dbfTable = "bmk.dbf";
//OleDbDataReader dr = null;
//DataTable dt = DbfHelper.ToDataTable(dbfPath, dbfTable);
//foreach (DataRow dr in dt.Rows)
DbfHelper.ExcuteDataReader(dbfPath, dbfTable,
dr =>
{
while (dr.Read())
{
string bmxh = dr["bmxh"].ToString();
Bmk bmk = Bmk.FindOne(p => p.bmxh == bmxh);
if (bmk == null)
{
bmk = new Bmk();
bmk.RecordGuid = Guid.NewGuid().ToString();
bmk.bmxh = bmxh;
}
bmk.xm = dr["xm"].ToString();
bmk.xb = dr["xb"].ToString();
bmk.xstbh = dr["xstbh"].ToString();
#region dr 操作
bmk.zkzh = dr["zkzh"].ToString();
bmk.xm = dr["xm"].ToString();
bmk.sfzh = dr["sfzh"].ToString();
bmk.xb = dr["xb"].ToString();
bmk.mz = dr["mz"].ToString();
bmk.csny = dr["csny"].ToString();
bmk.ty = dr["ty"].ToString();
bmk.tcxm = dr["tcxm"].ToString();
bmk.hk = dr["hk"].ToString();
bmk.xz = dr["xz"].ToString();
bmk.kslb = dr["kslb"].ToString();
bmk.byxxdm = dr["byxxdm"].ToString();
bmk.byxxmc = dr["byxxmc"].ToString();
bmk.xh = dr["xh"].ToString();
bmk.bj = dr["class"].ToString();
bmk.kl = dr["kl"].ToString();
bmk.jtzz = dr["jtzz"].ToString();
bmk.tel = dr["tel"].ToString();
bmk.post = dr["post"].ToString();
bmk.bz1 = dr["bz1"].ToString();
bmk.bz2 = dr["bz2"].ToString();
bmk.bz3 = dr["bz3"].ToString();
bmk.bz4 = dr["bz4"].ToString();
bmk.xstbh = dr["xstbh"].ToString();
bmk.kddm = dr["kddm"].ToString();
bmk.kdmc = dr["kdmc"].ToString();
bmk.scbm = dr["scbm"].ToString();
bmk.tbsch = dr["tbsch"].ToString();
bmk.zwh = dr["zwh"].ToString();
bmk.scmh = dr["scmh"].ToString();
//bmk.km1 = dr["km1"].to();
//bmk.km2 = dr["km2"].ToString();
//bmk.km3 = dr["km3"].ToString();
//bmk.km31 = dr["km31"].ToString();
//bmk.km32 = dr["km32"].ToString();
//bmk.km4 = dr["km4"].ToString();
//bmk.km5 = dr["km5"].ToString();
//bmk.km51 = dr["km51"].ToString();
//bmk.km61 = dr["km61"].ToString();
//bmk.km62 = dr["km62"].ToString();
//bmk.km621 = dr["km621"].ToString();
//bmk.km63 = dr["km63"].ToString();
//bmk.km6 = dr["km6"].ToString();
bmk.km71 = dr["km71"].ToString();
bmk.km72 = dr["km72"].ToString();
bmk.km73 = dr["km73"].ToString();
bmk.km74 = dr["km74"].ToString();
bmk.km81 = dr["km81"].ToString();
//bmk.tyf = dr["tyf"].ToString();
//bmk.tzf = dr["tzf"].ToString();
//bmk.tcf = dr["tcf"].ToString();
//bmk.zf = dr["zf"].ToString();
//bmk.tot1 = dr["tot1"].ToString();
//bmk.tot2 = dr["tot2"].ToString();
//bmk.mch = dr["mch"].ToString();
//bmk.tzdm = dr["tzdm"].ToString();
//bmk.tzmc = dr["tzmc"].ToString();
bmk.tcdm = dr["tcdm"].ToString();
bmk.tcmc = dr["tcmc"].ToString();
bmk.zy11 = dr["zy11"].ToString();
bmk.zy12 = dr["zy12"].ToString();
bmk.zy13 = dr["zy13"].ToString();
bmk.zy21 = dr["zy21"].ToString();
bmk.zy22 = dr["zy22"].ToString();
bmk.zy23 = dr["zy23"].ToString();
bmk.zy31 = dr["zy31"].ToString();
bmk.zy32 = dr["zy32"].ToString();
bmk.zy33 = dr["zy33"].ToString();
bmk.zy41 = dr["zy41"].ToString();
bmk.zy42 = dr["zy42"].ToString();
bmk.zy43 = dr["zy43"].ToString();
bmk.zy51 = dr["zy51"].ToString();
bmk.zy52 = dr["zy52"].ToString();
bmk.zy53 = dr["zy53"].ToString();
bmk.fc = dr["fc"].ToString();
bmk.jb = dr["jb"].ToString();
bmk.syqk = dr["syqk"].ToString();
#endregion
bmk.Save();
}
}
);
}
/// <summary>
/// 从excel文件导入
/// </summary>
/// <param name="filepath"></param>
private void ImportFromExcel(string filepath)
{
var list = ExcelHelper.GetSheetNameList(filepath);
string sheetName = "Sheet1";
if (list.Count == 0)
{
throw new Exception("Excel文件中不存在任何表格");
}
else
{
bool flag = false;
foreach (var item in list)
{
if (item.Name == sheetName)
{
flag = true;
break;
}
}
if (flag == false)
{
sheetName = list[0].Name;
}
}
DataTable datatable = ExcelHelper.ExcelToDataTable(filepath, sheetName);
//报名序号 学籍主号 姓名 班级 班内编号 性别 出生日期 民族
//政治面貌 户籍类别 家庭电话 监护人手机 现居住地址 家庭邮码 学籍辅号
int total = 0;//总共
int import = 0; //导入数据
if (datatable.Columns.Contains("学籍辅号") && datatable.Columns.Contains("姓名")
&& datatable.Columns.Contains("班级"))
{
foreach (DataRow row in datatable.Rows)
{
total++;
string xstbh = row["学籍辅号"].ToString();
string xm = row["姓名"].ToString();
string bj = row["班级"].ToString();
if (!xstbh.IsNullOrEmpty())
{
var stu = Bmk.FindOne(p => p.xstbh == xstbh);
if (stu == null)
{
stu = new Bmk();
stu.xstbh = xstbh;
}
stu.xm = xm;
if (bj.IsNullOrEmpty() == false)
stu.bj = bj.Substring(bj.IndexOf('(') + 1).TrimEnd(')').PadLeft(2, '0'); ;
stu.Save();
import++;
}
}
JsUtil.MessageBox(this, string.Format("学生总共{0}人,导入{1}", total, import));
}
else
{
JsUtil.MessageBox(this, "学籍辅号 姓名 班级 这3列必须存在");
}
}
/// <summary>
/// 从~/Data/Dbf/userdbfs/bmk.dbf导入数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnImportFromDatapath_Click(object sender, EventArgs e)
{
string dbfPath = Server.MapPath("~/Data/Dbf/userdbfs/");
string dbfTable = "bmk.dbf";
DataTable dt = DbfHelper.ToDataTable(dbfPath, dbfTable);
foreach (DataRow dr in dt.Rows)
{
string bmxh = dr["bmxh"].ToString();
Bmk bmk = Bmk.FindOne(p => p.bmxh == bmxh);
if (bmk == null)
{
bmk = new Bmk();
bmk.RecordGuid = Guid.NewGuid().ToString();
bmk.bmxh = bmxh;
}
bmk.xm = dr["xm"].ToString();
bmk.xb = dr["xb"].ToString();
bmk.xstbh = dr["xstbh"].ToString();
bmk.bmxh = dr["bmxh"].ToString();
bmk.zkzh = dr["zkzh"].ToString();
bmk.xm = dr["xm"].ToString();
bmk.sfzh = dr["sfzh"].ToString();
bmk.xb = dr["xb"].ToString();
bmk.mz = dr["mz"].ToString();
bmk.csny = dr["csny"].ToString();
bmk.ty = dr["ty"].ToString();
bmk.tcxm = dr["tcxm"].ToString();
bmk.hk = dr["hk"].ToString();
bmk.xz = dr["xz"].ToString();
bmk.kslb = dr["kslb"].ToString();
bmk.byxxdm = dr["byxxdm"].ToString();
bmk.byxxmc = dr["byxxmc"].ToString();
bmk.xh = dr["xh"].ToString();
bmk.bj = dr["class"].ToString();
bmk.kl = dr["kl"].ToString();
bmk.jtzz = dr["jtzz"].ToString();
bmk.tel = dr["tel"].ToString();
bmk.post = dr["post"].ToString();
bmk.bz1 = dr["bz1"].ToString();
bmk.bz2 = dr["bz2"].ToString();
bmk.bz3 = dr["bz3"].ToString();
bmk.bz4 = dr["bz4"].ToString();
bmk.xstbh = dr["xstbh"].ToString();
bmk.kddm = dr["kddm"].ToString();
bmk.kdmc = dr["kdmc"].ToString();
bmk.scbm = dr["scbm"].ToString();
bmk.tbsch = dr["tbsch"].ToString();
bmk.zwh = dr["zwh"].ToString();
bmk.scmh = dr["scmh"].ToString();
//bmk.km1 = dr["km1"].to();
//bmk.km2 = dr["km2"].ToString();
//bmk.km3 = dr["km3"].ToString();
//bmk.km31 = dr["km31"].ToString();
//bmk.km32 = dr["km32"].ToString();
//bmk.km4 = dr["km4"].ToString();
//bmk.km5 = dr["km5"].ToString();
//bmk.km51 = dr["km51"].ToString();
//bmk.km61 = dr["km61"].ToString();
//bmk.km62 = dr["km62"].ToString();
//bmk.km621 = dr["km621"].ToString();
//bmk.km63 = dr["km63"].ToString();
//bmk.km6 = dr["km6"].ToString();
bmk.km71 = dr["km71"].ToString();
bmk.km72 = dr["km72"].ToString();
bmk.km73 = dr["km73"].ToString();
bmk.km74 = dr["km74"].ToString();
bmk.km81 = dr["km81"].ToString();
//bmk.tyf = dr["tyf"].ToString();
//bmk.tzf = dr["tzf"].ToString();
//bmk.tcf = dr["tcf"].ToString();
//bmk.zf = dr["zf"].ToString();
//bmk.tot1 = dr["tot1"].ToString();
//bmk.tot2 = dr["tot2"].ToString();
//bmk.mch = dr["mch"].ToString();
//bmk.tzdm = dr["tzdm"].ToString();
//bmk.tzmc = dr["tzmc"].ToString();
bmk.tcdm = dr["tcdm"].ToString();
bmk.tcmc = dr["tcmc"].ToString();
bmk.zy11 = dr["zy11"].ToString();
bmk.zy12 = dr["zy12"].ToString();
bmk.zy13 = dr["zy13"].ToString();
bmk.zy21 = dr["zy21"].ToString();
bmk.zy22 = dr["zy22"].ToString();
bmk.zy23 = dr["zy23"].ToString();
bmk.zy31 = dr["zy31"].ToString();
bmk.zy32 = dr["zy32"].ToString();
bmk.zy33 = dr["zy33"].ToString();
bmk.zy41 = dr["zy41"].ToString();
bmk.zy42 = dr["zy42"].ToString();
bmk.zy43 = dr["zy43"].ToString();
bmk.zy51 = dr["zy51"].ToString();
bmk.zy52 = dr["zy52"].ToString();
bmk.zy53 = dr["zy53"].ToString();
bmk.fc = dr["fc"].ToString();
bmk.jb = dr["jb"].ToString();
bmk.syqk = dr["syqk"].ToString();
bmk.Save();
}
this.Succeed("导入完毕!");
}
/// <summary>
/// 导入学生名单
/// </summary>
/// <param name="datatable">数据表</param>
/// <returns>是否成功</returns>
private bool ImportStudent(DataTable datatable)
{
foreach (DataRow dr in datatable.Rows)
{
Bmk bmk = Bmk.FindOne(p => p.bmxh == dr["bmxh"].ToString());
if (bmk == null)
bmk = new Bmk();
bmk.byxxdm = dr["byxxdm"].ToString();
bmk.byxxmc = dr["byxxmc"].ToString();
bmk.bmxh = dr["bmxh"].ToString();
bmk.xm = dr["xm"].ToString();
bmk.bj = dr["class"].ToString();
bmk.xh = dr["xh"].ToString();
bmk.xstbh = dr["xstbh"].ToString();
bmk.sfzh = dr["sfzh"].ToString();
bmk.xb = dr["xb"].ToString();
bmk.csny = dr["csny"].ToString();
bmk.ty = dr["ty"].ToString();
bmk.mz = dr["mz"].ToString();
bmk.kslb = dr["kslb"].ToString();
bmk.hk = dr["hk"].ToString();
bmk.tel = dr["tel"].ToString();
bmk.jtzz = dr["jtzz"].ToString();
bmk.post = dr["post"].ToString();
bmk.syqk = dr["syqk"].ToString();
bmk.bz1 = dr["bz1"].ToString();
bmk.bz2 = dr["bz2"].ToString();
bmk.bz3 = dr["bz3"].ToString();
bmk.bz4 = dr["bz4"].ToString();
bmk.Save();
}
return true;
}
/// <summary>
/// 更新数据到报名
/// </summary>
/// <param name="bmk"></param>
private int UpdateBmkBase(Bmk bmk)
{
ArrayList al = new ArrayList();
//报名序号
al.Add(OleDbHelper.CreateInParam("bmxh", OleDbType.Char, 9, bmk.bmxh));
al.Add(OleDbHelper.CreateInParam("xm", OleDbType.Char, 8, bmk.xm));
al.Add(OleDbHelper.CreateInParam("sfzh", OleDbType.Char, 18, bmk.sfzh));
al.Add(OleDbHelper.CreateInParam("xb", OleDbType.Char, 1, bmk.xb));
al.Add(OleDbHelper.CreateInParam("mz", OleDbType.Char, 1, bmk.mz));
al.Add(OleDbHelper.CreateInParam("csny", OleDbType.Char, 8, bmk.csny));
al.Add(OleDbHelper.CreateInParam("hk", OleDbType.Char, 2, bmk.hk));
al.Add(OleDbHelper.CreateInParam("syqk", OleDbType.Char, 1, bmk.syqk));
al.Add(OleDbHelper.CreateInParam("kslb", OleDbType.Char, 1, bmk.kslb));
al.Add(OleDbHelper.CreateInParam("byxxdm", OleDbType.Char, 4, bmk.byxxdm));
al.Add(OleDbHelper.CreateInParam("byxxmc", OleDbType.Char, 16, bmk.byxxmc));
al.Add(OleDbHelper.CreateInParam("xh", OleDbType.Char, 2, bmk.xh));
al.Add(OleDbHelper.CreateInParam("class", OleDbType.Char, 2, bmk.bj));
al.Add(OleDbHelper.CreateInParam("jtzz", OleDbType.Char, 50, bmk.jtzz));
al.Add(OleDbHelper.CreateInParam("tel", OleDbType.Char, 30, bmk.tel));
al.Add(OleDbHelper.CreateInParam("post", OleDbType.Char, 6, bmk.post));
al.Add(OleDbHelper.CreateInParam("ty", OleDbType.Char, 1, bmk.ty ));
al.Add(OleDbHelper.CreateInParam("bz1", OleDbType.Char, 2, bmk.bz1));
al.Add(OleDbHelper.CreateInParam("xstbh", OleDbType.Char, 9, bmk.xstbh));
string strSql = @"update bmk ";//
strSql += " set bmxh = ? , xm = ? , sfzh = ? , xb = ? ,mz = ? , csny = ?, hk = ? ,syqk= ? , kslb = ? , byxxdm = ?, byxxmc = ?, xh = ? , class = ? , jtzz = ? , tel = ? , post = ? ,ty = ? ,bz1 = ? ";
strSql += " where xstbh = ? ";
return OleDbHelper.ExcuteSQL(this.VfpConnection, strSql, (OleDbParameter[])al.ToArray(typeof(OleDbParameter)));
}
/// <summary>
/// 插入报名信息表
/// </summary>
/// <param name="bmk"></param>
/// <returns></returns>
private int InsertBmkBase(Bmk bmk)
{
ArrayList al = new ArrayList();
//报名序号
al.Add(OleDbHelper.CreateInParam("bmxh", OleDbType.Char, 9, bmk.bmxh ?? ""));
al.Add(OleDbHelper.CreateInParam("xstbh", OleDbType.Char, 9, bmk.xstbh));
al.Add(OleDbHelper.CreateInParam("sfzh", OleDbType.Char, 18, bmk.sfzh));
al.Add(OleDbHelper.CreateInParam("xb", OleDbType.Char, 1, bmk.xb));
al.Add(OleDbHelper.CreateInParam("mz", OleDbType.Char, 1, bmk.mz));
al.Add(OleDbHelper.CreateInParam("csny", OleDbType.Char, 8, bmk.csny));
al.Add(OleDbHelper.CreateInParam("hk", OleDbType.Char, 2, bmk.hk));
al.Add(OleDbHelper.CreateInParam("syqk", OleDbType.Char, 1, bmk.syqk));
al.Add(OleDbHelper.CreateInParam("kslb", OleDbType.Char, 1, bmk.kslb));
al.Add(OleDbHelper.CreateInParam("byxxdm", OleDbType.Char, 4, bmk.byxxdm));
al.Add(OleDbHelper.CreateInParam("byxxmc", OleDbType.Char, 16, bmk.byxxmc));
al.Add(OleDbHelper.CreateInParam("xh", OleDbType.Char, 2, bmk.xh));
al.Add(OleDbHelper.CreateInParam("class", OleDbType.Char, 2, bmk.bj));
al.Add(OleDbHelper.CreateInParam("jtzz", OleDbType.Char, 50, bmk.jtzz));
al.Add(OleDbHelper.CreateInParam("tel", OleDbType.Char, 30, bmk.tel));
al.Add(OleDbHelper.CreateInParam("post", OleDbType.Char, 6, bmk.post));
al.Add(OleDbHelper.CreateInParam("zkzh", OleDbType.Char, 11, bmk.zkzh));
string strSql = @"insert into bmk (bmxh,xstbh,sfzh,
xb,mz,csny,hk,syqk, kslb,byxxdm,byxxmc,xh,class,
jtzz,tel,post)";
strSql += " values (?,?,?, ?,?,?,?,?, ?,?,?,?,?, ?,?,?) ";
Debug.Write(strSql);
return OleDbHelper.ExcuteSQL(this.VfpConnection, strSql, (OleDbParameter[])al.ToArray(typeof(OleDbParameter)));
// return 1;
}
