public bool ChangeUInfo() { Tno = 教工号TextField.Text; Tname = 教师姓名TextField.Text; Tsex = 性别ComboBox.SelectedItem.Text; Tbith = 教师出生DateField.Text.ToString(); Tjiguan = 籍贯TextField.Text; Tnation = 民族ComBox.SelectedItem.Text; Tcollname = 院系TextField.Text; Teduback = 教育程度TextField.Text; Tmianmao = 政治面貌ComBox.SelectedItem.Text; Temail = 邮箱TextField.Text; DBHelp db = new DBHelp(); SqlConnection mycon = db.MyCon; mycon.Open(); SqlCommand mycmd = mycon.CreateCommand(); try { string updateUinfo = "update TInfo Set TName='" + Tname + "',TSex='" + Tsex + "',TNation='" + Tnation + "',TJiGuan='" + Tjiguan + "',TEduBack='" + Teduback + "',TBith='" + Tbith + "',TCollName='" + Tcollname + "',TMianMao='" + Tmianmao + "',TEmail='" + Temail + "' where TNo='" + Tno + "'"; mycmd.CommandText = updateUinfo; mycmd.ExecuteNonQuery(); return true; } catch(Exception) { return false; } finally { mycon.Close(); } }
protected void imgBtnConfirm_Click(object sender, ImageClickEventArgs e) { Panel1.Visible = true; string courseID = ddlCourse.SelectedValue; DBHelp db = new DBHelp();//创建DBHelp类对象 string GridView1Str = "select top " + int.Parse(txtSingleNum.Text.Trim()) + " * from SingleProblem where CourseID=" + courseID + " order by newid()";//根据参数设置查询单选题Sql语句 DataSet ds1 = db.GetDataSetSql(GridView1Str);//调用DBHelp类方法GetDataSetSql方法查询数据 GridView1.DataSource = ds1.Tables[0].DefaultView;//为单选题GridView控件指名数据源 GridView1.DataBind();//绑定数据 string GridView2Str = "select top " + int.Parse(txtMultiNum.Text.Trim()) + " * from MultiProblem where CourseID=" + courseID + " order by newid()";//根据参数设置查询多选题Sql语句 DataSet ds2 = db.GetDataSetSql(GridView2Str);//调用DBHelp类方法GetDataSetSql方法查询数据 GridView2.DataSource = ds2.Tables[0].DefaultView;//为多选题GridView控件指名数据源 GridView2.DataBind();//绑定数据 string GridView3Str = "select top " + int.Parse(txtJudgeNum.Text.Trim()) + " * from JudgeProblem where CourseID=" + courseID + " order by newid()";//根据参数设置查询判断题Sql语句 DataSet ds3 = db.GetDataSetSql(GridView3Str);//调用DBHelp类方法GetDataSetSql方法查询数据 GridView3.DataSource = ds3.Tables[0].DefaultView;//为判断题GridView控件指名数据源 GridView3.DataBind();//绑定数据 string GridView4Str = "select top " + int.Parse(txtFillNum.Text.Trim()) + " * from FillBlankProblem where CourseID=" + courseID + " order by newid()";//根据参数设置查询填空题Sql语句 DataSet ds4 = db.GetDataSetSql(GridView4Str);//调用DBHelp类方法GetDataSetSql方法查询数据 GridView4.DataSource = ds4.Tables[0].DefaultView;//为填空题GridView控件指名数据源 GridView4.DataBind();//绑定数据 string GridView5Str = "select top " + int.Parse(txtQuestionNum.Text.Trim()) + " * from QuestionProblem where CourseID=" + courseID + " order by newid()";//根据参数设置查询填空题Sql语句 DataSet ds5 = db.GetDataSetSql(GridView5Str);//调用DBHelp类方法GetDataSetSql方法查询数据 GridView5.DataSource = ds5.Tables[0].DefaultView;//为填空题GridView控件指名数据源 GridView5.DataBind();//绑定数据 }
protected void 审核提交Button_Click(object sender, EventArgs e) { int PId; if (选择编号TextField.Text == "") { X.Msg.Alert("Status", "请选择要审核通过的论文.").Show(); return; } PId = Convert.ToInt32(选择编号TextField.Text); DBHelp db = new DBHelp(); SqlConnection mycon = db.MyCon; mycon.Open(); SqlCommand mycmd = mycon.CreateCommand(); try { string updateUinfo = "update PaperInfo Set PVType='1' where PId="+PId; mycmd.CommandText = updateUinfo; mycmd.ExecuteNonQuery(); X.Msg.Alert("Status", "审核通过.").Show(); return; } catch (Exception) { X.Msg.Alert("Status", "出错.").Show(); return; } finally { mycon.Close(); } }
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e) { DBHelp db = new DBHelp(); string insertpaper = "insert into Paper(CourseID,PaperName,PaperState) values(" + int.Parse(ddlCourse.SelectedValue) + ",'" + txtPaperName.Text + "',1) SELECT @@IDENTITY as id"; int afterID = GetIDInsert(insertpaper);//保存试卷,并返回自动生成的试卷编号 if (afterID > 0) { foreach (GridViewRow dr in GridView1.Rows)//保存试卷单选题信息 { string single = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'单选题'," + int.Parse(((Label)dr.FindControl("Label3")).Text) + "," + int.Parse(txtSingleFen.Text) + ")"; db.Insert(single); } foreach (GridViewRow dr in GridView2.Rows)//保存试卷多选题信息 { string multi = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'多选题'," + int.Parse(((Label)dr.FindControl("Label6")).Text) + "," + int.Parse(txtMultiFen.Text) + ")"; db.Insert(multi); } foreach (GridViewRow dr in GridView3.Rows)//保存试卷判断题信息 { string judge = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'判断题'," + int.Parse(((Label)dr.FindControl("Label7")).Text) + "," + int.Parse(txtJudgeFen.Text) + ")"; db.Insert(judge); } foreach (GridViewRow dr in GridView4.Rows)//保存试卷填空题信息 { string fill = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'填空题'," + int.Parse(((Label)dr.FindControl("Label8")).Text) + "," + int.Parse(txtFillFen.Text) + ")"; db.Insert(fill); } foreach (GridViewRow dr in GridView5.Rows)//保存试卷填空题信息 { string que = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'问答题'," + int.Parse(((Label)dr.FindControl("Label23")).Text) + "," + int.Parse(txtQuestionFen.Text) + ")"; db.Insert(que); } Response.Write("<script language=javascript>alert('保存成功');location='PaperLists.aspx'</script>"); } }
protected void 保存Button_Click(object sender, EventArgs e) { Tno = 选择工号TextField.Text; Tname = 选择姓名TextField.Text; Tsex = 选择性别ComboBox.SelectedItem.Text; Tbith = 选择出生DateField.Text.ToString(); Tjiguan = 选择籍贯TextField.Text; Tnation = 选择民族ComboBox.SelectedItem.Text; Tcollname = 选择院系ComboBox.SelectedItem.Text; Teduback = 选择背景TextField.Text; Tmianmao = 选择面貌ComBox.SelectedItem.Text; Temail = 选择邮箱TextField.Text; DBHelp db = new DBHelp(); SqlConnection mycon = db.MyCon; mycon.Open(); SqlCommand mycmd = mycon.CreateCommand(); try { string updateUinfo = "update TInfo Set TName='" + Tname + "',TSex='" + Tsex + "',TNation='" + Tnation + "',TJiGuan='" + Tjiguan + "',TEduBack='" + Teduback + "',TBith='" + Tbith + "',TCollName='" + Tcollname + "',TMianMao='" + Tmianmao + "',TEmail='" + Temail + "' where TNo='" + Tno + "'"; mycmd.CommandText = updateUinfo; mycmd.ExecuteNonQuery(); X.Msg.Alert("Status", "修改成功.").Show(); return; } catch (Exception) { X.Msg.Alert("Status", "修改失败.").Show(); return ; } finally { mycon.Close(); } }
protected void 登录ImageButton_Click(object sender, ImageClickEventArgs e) { 用户名TextBox.Text = "123"; DBHelp db = new DBHelp(); SqlConnection mycon = db.MyCon; mycon.Open(); string sel = "select * from TInfo where TNo='" + 用户名TextBox.Text + "'and TPwd='" + 密码TextBox.Text + "'"; SqlCommand mycmd = mycon.CreateCommand(); mycmd.CommandText = sel; SqlDataReader myreader = mycmd.ExecuteReader(); try { if (myreader.Read()) { TPwd = myreader["TPwd"].ToString(); //Label1.Text = TName; //Session.Timeout = 18000; if (管理员RadioButton.Checked) { MNo = myreader["TNo"].ToString(); Session["MNo"] = MNo; Response.Redirect("Glymain.aspx"); } else { TNo = myreader["TNo"].ToString(); Session["TNo"] = TNo; Response.Redirect("Main.aspx"); } } else { Response.Write("<script>alert('用户名或密码有误!')</script>"); } } catch (Exception) { X.Msg.Alert("Status", "登录出错,请重新登录.").Show(); } finally { myreader.Close(); mycon.Close(); } //Label1.Text=DESzh.DesEncrypt(密码TextBox.Text); //Label2.Text = "解密后"+DESzh.DesDecrypt(Label1.Text); }
protected void 已审核查询Button_Click(object sender, EventArgs e) { DBHelp db = new DBHelp(); SqlConnection mycon = db.MyCon; mycon.Open(); string selstr = ""; selstr = "select * from XMInfo where XVType='1'"; if (多项Radio.Checked) { if (院系ComboBox.SelectedItem.Text != "") { selstr = selstr + "and XMDeptName='" + 院系ComboBox.SelectedItem.Text.Trim() + "'"; } /*else { X.Msg.Alert("Status", "请选择查询单位.").Show(); return; }*/ } else if (单项Radio.Checked) { if (项目名称TextField.Text != "") { selstr = selstr + "and XMName='" + 项目名称TextField.Text.Trim() + "'"; } else if (工号TextField.Text != "") { selstr = selstr + "and TNo='" + 工号TextField.Text.Trim() + "'"; } else if (项目类型TextField.Text != "") { selstr = selstr + "and XMType='" + 项目类型TextField.Text.Trim() + "'"; } /*else { X.Msg.Alert("Status", "请填写查询条件.").Show(); return; }*/ } SqlCommand mycmd = mycon.CreateCommand(); mycmd.CommandText = selstr; SqlDataReader myread = mycmd.ExecuteReader(); 项目Store.DataSourceID = ""; 项目Store.DataSource = myread; 项目Store.DataBind(); mycon.Close(); 审核Button.Disabled = false; 撤销审核Button.Disabled = true; }
protected void 保存Button_Click(object sender, EventArgs e) { if (密码TextField.Text != 确认密码TextField.Text) { X.Msg.Alert("Status", "密码不一致.").Show(); } else { string username, oldpwd1, newpwd, oldpwd2; username = 用户名TextField.Text; newpwd = 旧密码TextField.Text; oldpwd1 = 密码TextField.Text; oldpwd2 = 确认密码TextField.Text; DBHelp db = new DBHelp(); bool flag = db.ChangePwd(username, newpwd, oldpwd1); if (flag) { X.Msg.Alert("Status", "保存成功.").Show(); } } }
/// <summary> /// 通过用户名获取用户信息 /// </summary> /// <param name="userid">用户ID(工号)</param> /// <returns></returns> public HttpResponseMessage GetUserInfoByUserID(string userid) { string sql = "Select * From tblUser Where usercode=:userid";//:userid 参数名称必须以冒号开头 OracleParameter[] ops = { new OracleParameter(":userid", OracleDbType.Varchar2) //这里的冒号可以省略 }; ops[0].Value = userid; DataTable dt = OracleHelp.GetDataTable(sql, ops); string sql2 = "Select * From tblUser Where usercode=:userid or organiZationID=:Orgid"; List <OracleParameter> oracleParameters = new List <OracleParameter>(); OracleParameter oracleParameter1 = new OracleParameter(":userid", OracleDbType.Varchar2) { Value = userid }; oracleParameters.Add(oracleParameter1); OracleParameter oracleParameter2 = new OracleParameter(":ORGID", OracleDbType.Int32) { Value = 181 }; oracleParameters.Add(oracleParameter2); DataTable dt2 = OracleHelp.GetDataTable(sql2, oracleParameters); if (dt != dt2) { dt = dt2; } return(DBHelp.ConvertToHttpResponseMessage(dt)); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.EFrom.tb_QuotePrice GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append("IsShuiYin,IsGaiZhang,IsRemark,LastYH,IsYH,LIlv,LaborCost,EngineeringTax,QPType,IsBrand,IsProduct, Remark,ZLBZ,YSBJ,FWBXDJ,JFQ,Total,loginName,tb_QuotePrice.Id,QuoteNo,GuestName,GuestNo,QuoteDate,ResultGuestName,ResultGuestNo,PayStyle,GuestNameToInv,ContactPerToInv,telToInv,AddressToInv,InvoHeader,InvContactPer,InvAddress,InvTel,NaShuiPer,brandNo,GuestNameTofa,ContactPerTofa,telTofa,AddressTofa,BuessName,BuessEmail,ComTel,ComChuanZhen,ComBusTel,ComName,NaShuiNo,Address,ComBrand,CreateUser,CreateTime "); strSql.Append(" from tb_QuotePrice left join tb_User on tb_User.id=tb_QuotePrice.CreateUser"); strSql.Append(" where tb_QuotePrice.Id=" + id + ""); VAN_OA.Model.EFrom.tb_QuotePrice model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.BaseInfo.CaiOilXSInfo GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" Id,CarNo,OilXs "); strSql.Append(" from CaiOilXSInfo "); strSql.Append(" where Id=" + ID + ""); VAN_OA.Model.BaseInfo.CaiOilXSInfo model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader objReader = objCommand.ExecuteReader()) { if (objReader.Read()) { model = ReaderBind(objReader); } } } return(model); }
/// <summary> /// 得到一个员工基本信息的对象实体 /// </summary> public VAN_OA.Model.HR.HR_PERSON GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" ID,Code,Department,Position,Name,Birthday,Sex,EducationLevel,EducationSchool,Major,GraduationTime,OnBoardTime,BeNormalTime,ContractTime,ContractCloseTime,HuKou,Marriage,IDCard,MobilePhone,HomePhone,HomeAddress,EmailAddress,CreateTime,CreatePerson,UpdateTime,UpdatePerson,QuitStatus,'' as QuitStatusName "); strSql.Append(" from HR_PERSON "); strSql.Append(" where ID=" + ID + ""); VAN_OA.Model.HR.HR_PERSON model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader objReader = objCommand.ExecuteReader()) { if (objReader.Read()) { model = ReaderBind(objReader); } } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.EFrom.Tb_ExpInv GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" Tb_ExpInv.Id,CreateUserId,ExpTime,ProNo,loginName,loginIPosition,EventNo,IfOutGoods,OutTime "); strSql.Append(" from Tb_ExpInv left join tb_User on tb_User.id=Tb_ExpInv.CreateUserId"); strSql.Append(" where Tb_ExpInv.Id=" + id + ""); VAN_OA.Model.EFrom.Tb_ExpInv model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.EFrom.Tb_LeaveTask GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" Tb_LeaveTask.Id,UserId,LeverType,BeginTime,ToTime,Remark ,loginName,loginIPosition,zhiwu ,proNo,AppDate"); strSql.Append(" from Tb_LeaveTask left join tb_User on tb_User.id=Tb_LeaveTask.UserId"); strSql.Append(" where Tb_LeaveTask.Id=" + id + ""); VAN_OA.Model.EFrom.Tb_LeaveTask model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.EFrom.tb_ToolsApp GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" id,departName,appName,dateTime,toolName,toolYong ,proNo"); strSql.Append(" from tb_ToolsApp "); strSql.Append(" where id=" + id + ""); VAN_OA.Model.EFrom.tb_ToolsApp model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.JXC.Sell_OrderInHouse GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" SellInType,Sell_OrderInHouse.Id,CreateUserId,CreateTime,RuTime,GuestNAME,DoPer,ChcekProNo,ProNo,PONo,POName,Remark ,tb_User.loginName as CreateName,Status,FPNo,DaiLi,TuiTotal "); strSql.Append(" from Sell_OrderInHouse left join tb_User on tb_User.id=CreateUserId "); strSql.Append(" where Sell_OrderInHouse.Id=" + id + ""); VAN_OA.Model.JXC.Sell_OrderInHouse model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } } return(model); }
/// <summary> /// 得到一个员工基本工资的对象实体 /// </summary> public VAN_OA.Model.HR.HR_PERSON GetSalary(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select"); strSql.Append(" H.ID,U.Name,H.BasicSalary,H.GongLin,H.MobileFee,H.PositionFee,H.YangLaoJin,H.UnionFee,H.DefaultWorkDays,H.IsRetailed,H.IsQuit,H.UpdateTime,H.UpdatePerson,U.OnBoardTime,U.QuitTime,U1.loginName as UpdatePersonName"); strSql.Append(" from HR_Salary H right join HR_Person U on H.ID=U.ID left join tb_user U1 on H.UpdatePerson=U1.ID"); strSql.Append(" where U.ID=" + ID + ""); VAN_OA.Model.HR.HR_PERSON model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader objReader = objCommand.ExecuteReader()) { if (objReader.Read()) { model = SalaryReaderBind(objReader); } } } return(model); }
public int addTran(VAN_OA.Model.EFrom.tb_DeliverGoods model, VAN_OA.Model.EFrom.tb_EForm eform) { int id = 0; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; try { tb_EFormService eformSer = new tb_EFormService(); string proNo = eformSer.GetAllE_No("tb_DeliverGoods", objCommand); model.ProNo = proNo; eform.E_No = proNo; objCommand.Parameters.Clear(); id = Add(model, objCommand); eform.allE_id = id; eformSer.Add(eform, objCommand); tan.Commit(); } catch (Exception) { tan.Rollback(); return(0); } return(id); } }
/// <summary> /// 获取省份信息 /// </summary> /// <returns></returns> public List <string> CityList(string ProvinceName) { List <string> cityList = new List <string>(); string sql = string.Format(@"select CityName from [dbo].[TB_City] where ProvinceId in (select id from TB_Province where ProvinceName='{0}') union all select DistrictName as CityName from[dbo].[TB_District] where CityID in ( select id from[dbo].[TB_City] where ProvinceId in (select id from TB_Province where ProvinceName = '{0}') )", ProvinceName); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(sql, conn); using (SqlDataReader objReader = objCommand.ExecuteReader()) { while (objReader.Read()) { cityList.Add(objReader[0].ToString()); } } } return(cityList); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.EFrom.tb_DeliverGoods GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" id,DepartName,Name,dateTime,SongHuo,CompName,GoTime,BackTime,InvName,Address,proNo "); strSql.Append(" from tb_DeliverGoods "); strSql.Append(" where id=" + id + ""); VAN_OA.Model.EFrom.tb_DeliverGoods model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } } return(model); }
/// <summary> /// 下拉列表 /// </summary> public List <VAN_OA.Model.BaseInfo.TB_GoodsType> GetListArrayToDdl(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,GoodTypeName "); strSql.Append(" FROM TB_GoodsType "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by GoodTypeName "); List <VAN_OA.Model.BaseInfo.TB_GoodsType> list = new List <VAN_OA.Model.BaseInfo.TB_GoodsType>(); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { while (dataReader.Read()) { VAN_OA.Model.BaseInfo.TB_GoodsType model = new VAN_OA.Model.BaseInfo.TB_GoodsType(); object ojb; ojb = dataReader["Id"]; if (ojb != null && ojb != DBNull.Value) { model.Id = (int)ojb; } model.GoodTypeName = dataReader["GoodTypeName"].ToString(); list.Add(model); } } } return(list); }
private void IniData() { tvMain.Nodes.Clear(); TreeNode trNo = new TreeNode("↓ 开始"); trNo.ImageUrl = "~/Image/per.ico"; trNo.Value = "0"; tvMain.Nodes.Add(trNo); List <A_ProInfos> getAllPros = new List <A_ProInfos>(); A_ProInfosService prosSer = new A_ProInfosService(); if (Request["proId"] != null) { getAllPros = prosSer.GetListArray(string.Format(" pro_Id={0}", Request["proId"])); object obj = DBHelp.ExeScalar("select pro_Type from A_ProInfo where pro_Id=" + Request["proId"]); lblName.Text = obj.ToString(); } for (int i = 0; i < getAllPros.Count; i++) { TreeNode maintrNo = new TreeNode("↓ " + getAllPros[i].RoleName); maintrNo.ImageUrl = "~/Image/per.ico"; maintrNo.Value = getAllPros[i].ids.ToString(); tvMain.Nodes.Add(maintrNo); } TreeNode trNoLast = new TreeNode("结束"); trNoLast.ImageUrl = "~/Image/per.ico"; trNoLast.Value = "-1"; tvMain.Nodes.Add(trNoLast); tvMain.ExpandAll(); }
/// <summary> /// 更新一条模版及子项和众评人 /// </summary> public void Update(A_PATemplate model) { StringBuilder strSql = new StringBuilder(); string strSql3; strSql.Append("update A_PATemplate set "); if (model.A_PATemplateName != null) { strSql.Append("A_PATemplateName='" + model.A_PATemplateName + "',"); } else { strSql.Append("A_PATemplateName= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where A_PATemplateID=" + model.A_PATemplateID + ""); DBHelp.ExeCommand(strSql.ToString()); if (model.A_PATemplateItem.Count > 0) { strSql3 = "delete from A_PATemplateItem where A_PATemplateID=" + model.A_PATemplateID + ";delete from A_PATemplateItemUser where A_PATemplateID=" + model.A_PATemplateID; object obj1 = DBHelp.ExeScalar(strSql3.ToString()); for (int i = 0; i < model.A_PATemplateItem.Count; i++) { strSql3 = "Insert into A_PATemplateItem (A_PATemplateID,Sequence,A_PASectionID,A_PAItemID,A_PAItemScore,A_PAItemAmount,A_PAIsFirstReview,A_PAFirstReviewUserID,A_PAIsSecondReview,A_PASecondReviewUserID,A_PAIsMultiReview) values (" + model.A_PATemplateID + "," + model.A_PAItemSequence[i].ToString() + "," + model.A_PATemplateSection[i].ToString() + "," + model.A_PATemplateItem[i].ToString() + "," + model.A_PATemplateScore[i].ToString() + "," + model.A_PATemplateAmount[i].ToString() + "," + (model.A_PATemplateIsFirstReview[i] ? 1 : 0) + "," + model.A_PATemplateFirstReviewUserID[i].ToString() + "," + (model.A_PATemplateIsSecondReview[i] ? 1 : 0) + "," + model.A_PATemplateSecondReviewUserID[i].ToString() + "," + (model.A_PATemplateIsMultiReview[i] ? 1 : 0) + ")"; object obj2 = DBHelp.ExeScalar(strSql3.ToString()); for (int j = 0; j < model.A_PATemplateMultiReviewUserID[i].Count; j++) { strSql3 = "Insert into A_PATemplateItemUser (A_PATemplateID,A_PASection_ID,A_PAItemID,User_ID) values (" + model.A_PATemplateID.ToString() + "," + model.A_PATemplateSection[i].ToString() + "," + model.A_PATemplateItem[i].ToString() + "," + model.A_PATemplateMultiReviewUserID[i][j].ToString() + ")"; object obj4 = DBHelp.ExeScalar(strSql3.ToString()); } } } }
/// <summary> /// 获取所有入库尚未退货的子信息集合 /// </summary> public List <VAN_OA.Model.JXC.CAI_OrderInHouses> GetListArrayCai_POOrderInHouse_Cai_POOrderOutHouse_ListView(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" Ids,id,GooId,GoodNum,GoodPrice,GoodRemark,GoodNo,GoodName,GoodSpec,GoodModel,GoodUnit,GoodTypeSmName,OrderCheckIds,totalOrderNum,QingGouPer"); strSql.Append(" from Cai_POOrderInHouse_Cai_POOrderOutHouse_ListView"); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } List <VAN_OA.Model.JXC.CAI_OrderInHouses> list = new List <VAN_OA.Model.JXC.CAI_OrderInHouses>(); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { while (dataReader.Read()) { CAI_OrderInHouses model = ReaderBind(dataReader); object ojb; ojb = dataReader["totalOrderNum"]; if (ojb != null && ojb != DBNull.Value) { model.GoodNum = model.GoodNum - Convert.ToDecimal(ojb); } list.Add(model); } } } return(list); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.EFrom.tb_Post GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" tb_Post.Id,AppName,AppTime,PostAddress,ToPer,Tel,WuliuName,PostCode,Remark,loginName,proNo ,FromPer,PostContext,PostFrom,PostFromAddress,PostTo,PostToAddress,PostTotal,PostRemark,POGuestName,PONo,POName "); strSql.Append(" from tb_Post left join tb_User on tb_Post.AppName=tb_User.Id"); strSql.Append(" where tb_Post.Id=" + id + ""); VAN_OA.Model.EFrom.tb_Post model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.EFrom.TB_POOrder GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" TB_POOrder.Id,AppName,loginName,CaiGou,cRemark ,fileName,fileType ,proNo"); strSql.Append(" from TB_POOrder left join tb_User on tb_User.id=TB_POOrder.AppName"); strSql.Append(" where TB_POOrder.Id=" + id + ""); VAN_OA.Model.EFrom.TB_POOrder model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.BaseInfo.GuestProBaseInfo GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,GuestPro,JiLiXiShu,XiShu,GuestMonth "); strSql.Append(" FROM GuestProBaseInfo "); strSql.Append(" where ID=" + ID + ""); VAN_OA.Model.BaseInfo.GuestProBaseInfo model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader objReader = objCommand.ExecuteReader()) { if (objReader.Read()) { model = ReaderBind(objReader); } } } return(model); }
protected void imgBtnSubmit_Click(object sender, ImageClickEventArgs e) { TextBox text = new TextBox(); int grade = 0; for (int k = 0; k < GridView1.Rows.Count; k++) { text = GridView1.Rows[k].FindControl("tbxqueScore1") as TextBox; grade += Convert.ToInt32(text.Text); } for (int k = 0; k < GridView2.Rows.Count; k++) { text = GridView2.Rows[k].FindControl("tbxqueScore2") as TextBox; grade += Convert.ToInt32(text.Text); } for (int k = 0; k < GridView3.Rows.Count; k++) { text = GridView5.Rows[k].FindControl("tbxqueScore3") as TextBox; grade += Convert.ToInt32(text.Text); } for (int k = 0; k < GridView4.Rows.Count; k++) { text = GridView4.Rows[k].FindControl("tbxqueScore") as TextBox; grade += Convert.ToInt32(text.Text); } for (int k = 0; k < GridView5.Rows.Count; k++) { text = GridView5.Rows[k].FindControl("tbxqueScore") as TextBox; grade += Convert.ToInt32(text.Text); } string userID = Session["userID"].ToString(); int exerciseID = Convert.ToInt32(Session["ExerciseID"]); DBHelp db = new DBHelp(); string sql = "insert into ExerciseScore(UserID,ExerciseID,Score) values('" + userID + "'," + exerciseID + "," + grade + ")"; db.Insert(sql); }
/// <summary> /// 退库商品是否含税 /// </summary> /// <param name="id"></param> /// <returns></returns> public Dictionary <int, bool> GetCAI_OrderOutHouse_HanShui(string id) { Dictionary <int, bool> list = new Dictionary <int, bool>(); string sql = string.Format("select IsHanShui,CAI_OrderOutHouses.Id from Cai_Info left join CAI_OrderOutHouses on CAI_OrderOutHouses.OrderCheckIds=Cai_Info.CaiInHouseIds where CAI_OrderOutHouses.id in ({0}) ", id); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(sql, conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { while (dataReader.Read()) { int Id = 0; bool IsHanShui = false; object ojb; ojb = dataReader["IsHanShui"]; if (ojb != null && ojb != DBNull.Value) { IsHanShui = ojb.ToString() == "1" ? true : false; } ojb = dataReader["Id"]; if (ojb != null && ojb != DBNull.Value) { Id = (int)ojb; } if (!list.ContainsKey(Id)) { list.Add(Id, IsHanShui); } } } } return(list); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.BaseInfo.Invoice_BillType GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" Id,BillName,BillType,IsStop "); strSql.Append(" from Invoice_BillType "); strSql.Append(" where ID=" + ID + ""); VAN_OA.Model.BaseInfo.Invoice_BillType model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader objReader = objCommand.ExecuteReader()) { if (objReader.Read()) { model = ReaderBind(objReader); } } } return(model); }
public List <User> getUserReportTos(string sql) { List <User> list = new List <User>(); list.Add(new User()); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(sql, conn); using (SqlDataReader objReader = objCommand.ExecuteReader()) { while (objReader.Read()) { User User = new User(); User.LoginName = objReader.GetString(0); User.Id = Convert.ToInt32(objReader["ID"]); list.Add(User); } objReader.Close(); } } return(list); }
protected string wrap_helplist() { string str = string.Empty; string item_count = string.Empty, sub_item = item_count; str += "<div class=\"help-list\">"; DataSet ds1 = DBHelp.DataSet_ds("select [Number],[upid],[title],[CloseS] from [e_helplist] where [CloseS]<>1 and [upid]='0' order by [Stat],[Number]", "@value"); foreach (DataRow rs1 in ds1.Tables["@value"].Select()) { str += "<dl><dt>" + rs1["title"].ToString() + "</dt>"; DataSet ds2 = DBHelp.DataSet_ds("select [Number],[upid],[title],[CloseS],[Reded] from [e_helplist] where [CloseS]<>1 and [upid]='" + rs1["Number"].ToString() + "' order by [Stat],[Number]", "@value"); foreach (DataRow rs2 in ds2.Tables["@value"].Select()) { str += "<dd><a href=\"#\" target=\"_blank\">" + rs2["title"].ToString() + "</a></dd>"; } ds2.Clear(); ds2.Dispose(); str += "</dl>"; } ds1.Clear(); ds1.Dispose(); return(str + "</div>"); }
protected void btnGuestType_Click(object sender, EventArgs e) { if (ViewState["isGuestType"] == null) { //保存客户类型信息 using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = conn.CreateCommand(); for (int i = 0; i < this.gvMain.Rows.Count; i++) { Label lblIds = (gvMain.Rows[i].FindControl("PONo")) as Label; DropDownList drp = ((DropDownList)gvMain.Rows[i].FindControl("dllGuestType")); objCommand.CommandText = string.Format("update CG_POOrder set GuestType='{1}' where PONO='{0}'", lblIds.Text, drp.Text); objCommand.ExecuteNonQuery(); } conn.Close(); } base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('保存成功!');</script>"); } //Show(); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.EFrom.tb_Complaint GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" * "); strSql.Append(" from tb_ComplaintP_view "); strSql.Append(" where id=" + id + ""); VAN_OA.Model.EFrom.tb_Complaint model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } } return(model); }
/// <summary> /// 分页获取数据列表 /// </summary> public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex) { string sql = "SELECT * FROM ( SELECT ROW_NUMBER() OVER ({0})AS Row, T.*,C.CategoryName from News T join Caegory C on T.CategoryID=C.ID {1}) TT WHERE TT.Row between {2} and {3};SELECT COUNT(1) AS 'count' FROM News T {1}"; string o = ""; string w = ""; if (!string.IsNullOrEmpty(orderby.Trim())) { o = "order by T." + orderby; } else { o = "order by T.ID desc"; } if (!string.IsNullOrEmpty(strWhere.Trim())) { w = " WHERE " + strWhere; } sql = string.Format(sql, o, w, startIndex, endIndex); return(DBHelp.ExecteDataSet(sql, DBHelp.Databasetype.SQL2005.ToString(), CommandType.Text)); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.EFrom.tb_Dispatching GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" MyXiShu,MyPoNo,MyValue,NiDate,NiHours,fileName,fileType,Id,Dispatcher,DisDate,OutDispater,GueName,Tel,Address,Contacter,GoDate,BackDate,Question,QuestionRemark,SuiTongRen ,proNo"); strSql.Append(" from tb_Dispatching "); strSql.Append(" where Id=" + id + ""); VAN_OA.Model.EFrom.tb_Dispatching model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(VAN_OA.Model.BaseInfo.FpTaxInfo model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.FpType != null) { strSql1.Append("FpType,"); strSql2.Append("'" + model.FpType + "',"); } if (model.Tax != null) { strSql1.Append("Tax,"); strSql2.Append("" + model.Tax + ","); } strSql.Append("insert into FpTaxInfo("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DBHelp.ExeScalar(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public List <User> getZaiZhiList(string where = "") { string sql = "select loginName from tb_User where 1=1 " + where + " order by loginName"; List <User> list = new List <User>(); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(sql, conn); using (SqlDataReader objReader = objCommand.ExecuteReader()) { while (objReader.Read()) { User User = new User(); User.LoginName = objReader.GetString(0); list.Add(User); } objReader.Close(); } } return(list); }
protected void btnSave_Click(object sender, EventArgs e) { string where = " ID in ("; string expWhere = " ID in ("; for (int i = 0; i < this.gvList.Rows.Count; i++) { CheckBox cb = (gvList.Rows[i].FindControl("cbIsUse")) as CheckBox; if (cb.Checked) { Label lblIds = (gvList.Rows[i].FindControl("myId")) as Label; where += "'" + lblIds.Text + "',"; } else { Label lblIds = (gvList.Rows[i].FindControl("myId")) as Label; expWhere += "'" + lblIds.Text + "',"; } } if (where != " ID in (") { where = where.Substring(0, where.Length - 1) + ")"; var sql = "update TB_SupplierInfo set IsUse=1 where " + where; DBHelp.ExeCommand(sql); base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('保存成功!');</script>"); } if (expWhere != " ID in (") { expWhere = expWhere.Substring(0, expWhere.Length - 1) + ")"; var sql = "update TB_SupplierInfo set IsUse=0 where " + expWhere; DBHelp.ExeCommand(sql); base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('保存成功!');</script>"); } }
protected void 保存Button_Click(object sender, EventArgs e) { if (Session["TNo"] == null) { X.Msg.Alert("Status", "保存出错1.").Show(); return; } if (题目TextField.Text == "") { X.Msg.Alert("Status", "请填写题目.").Show(); return; } if (期刊名TextField.Text == "") { X.Msg.Alert("Status", "请填写期刊名.").Show(); return; } if (第一作者TextField.Text == "") { X.Msg.Alert("Status", "请填写第一作者.").Show(); return; } if (接收日期DateField.Text == "") { X.Msg.Alert("Status", "请填写日期.").Show(); return; } if (基金TextField.Text == "") { X.Msg.Alert("Status", "请填写基金.").Show(); return; } if (单位ComboBox.Text == "") { X.Msg.Alert("Status", "请填写单位.").Show(); return; } if (级别ComboBox.Text == "") { X.Msg.Alert("Status", "请填写级别.").Show(); return; } if (卷号TextField.Text == "") { PJuanNo = 0; } else { int num = 0; if (int.TryParse(卷号TextField.Text, System.Globalization.NumberStyles.Integer, null, out num)) { PJuanNo = Convert.ToInt32(卷号TextField.Text); } else { X.Msg.Alert("Status", "卷号应为数字.").Show(); return; } } if (期号TextField.Text == "") { PQiNo = 0; } else { int num = 0; if (int.TryParse(期号TextField.Text, System.Globalization.NumberStyles.Integer, null, out num)) { PQiNo = Convert.ToInt32(期号TextField.Text); } else { X.Msg.Alert("Status", "期号应为数字.").Show(); return; } } DBHelp db = new DBHelp(); if (db.CheckPaper(题目TextField.Text)==2) { SqlConnection mycon = db.MyCon; mycon.Open(); SqlCommand mycmd = mycon.CreateCommand(); string sel = "insert into PaperInfo(PName,TNo,PJName,PFirstName,PSecondName,PAcceptTime,PFundName,PJuanNo,PQiNo,PDeptName,PYeNo,PRank,PRemark,PType,PVType) Values('" + 题目TextField.Text + "','" + Session["TNo"].ToString() + "','" + 期刊名TextField.Text + "','" + 第一作者TextField.Text + "','" + 第二作者TextField.Text + "','" + 接收日期DateField.Text + "','" + 基金TextField.Text + "'," +PJuanNo + "," + PQiNo + ",'" + 单位ComboBox.SelectedItem.Text + "','" + 页码TextField.Text + "','" + 级别ComboBox.SelectedItem.Text + "','" + 备注TextArea.Text + "','" + 0 + "','"+0+"')"; mycmd.CommandText = sel; mycmd.ExecuteNonQuery(); mycon.Close(); X.Msg.Alert("Status", "保存成功.").Show(); } else { X.Msg.Alert("Status", "保存出错2.").Show(); } }
protected void 提交Button_Click(object sender, EventArgs e) { if (选择名称TextField.Text == "") { X.Msg.Alert("Status", "请填写会议名称.").Show(); return; } if (选择论文TextField.Text == "") { X.Msg.Alert("Status", "请填写论文名称.").Show(); return; } if (第一作者TextField.Text == "") { X.Msg.Alert("Status", "请填写第一作者.").Show(); return; } if (接收日期DateField.Text == "") { X.Msg.Alert("Status", "请填写日期.").Show(); return; } if (选择基金TextField.Text == "") { X.Msg.Alert("Status", "请填写基金.").Show(); return; } if (选择单位ComboBox.Text == "") { X.Msg.Alert("Status", "请填写单位.").Show(); return; } if (选择级别ComboBox.Text == "") { X.Msg.Alert("Status", "请填写级别.").Show(); return; } if (选择卷号TextField.Text == "") { CJuanNo = 0; } else { int num = 0; if (int.TryParse(选择卷号TextField.Text, System.Globalization.NumberStyles.Integer, null, out num)) { CJuanNo = Convert.ToInt32(选择卷号TextField.Text); } else { X.Msg.Alert("Status", "卷号应为数字.").Show(); return; } } if (选择期号TextField.Text == "") { CQiNo = 0; } else { int num = 0; if (int.TryParse(选择期号TextField.Text, System.Globalization.NumberStyles.Integer, null, out num)) { CQiNo = Convert.ToInt32(选择期号TextField.Text); } else { X.Msg.Alert("Status", "期号应为数字.").Show(); return; } } CId = Convert.ToInt32(选择编号TextField.Text); DBHelp db = new DBHelp(); SqlConnection mycon = db.MyCon; mycon.Open(); SqlCommand mycmd = mycon.CreateCommand(); string sel = "update CInfo Set CName='" + 选择名称TextField.Text + "',CPaperName='" + 选择论文TextField.Text + "',CDeptName='" + 选择单位ComboBox.SelectedItem.Text + "',CBeginTime='" + 选择开始DateField.Text + "',CEndTime='" + 选择结束DateField.Text + "',CAcceptTime='" + 接收日期DateField.Text + "',CFundName='" + 选择基金TextField.Text + "',CPFirstName='" + 第一作者TextField.Text + "',CPSecondName='" + 第二作者TextField.Text + "',CPJuanNo=" + CJuanNo + ",CCanJia='" + 选择参加TextField.Text + "',CPQiNo=" + CQiNo + ",CPYeNo='" + 选择页号TextField.Text + "',CPRank='" + 选择级别ComboBox.SelectedItem.Text + "',CRemark='" +选择备注TextArea.Text + "',CType='1' where CId=" + CId; mycmd.CommandText = sel; mycmd.ExecuteNonQuery(); mycon.Close(); X.Msg.Alert("Status", "提交成功.").Show(); }
public static string saveDrug(string jsonStr) { string key = "ccode"; string val = "无法读取属性"; int info = 0; err = ""; DataTable dt = new DataTable(); //添加表字段 dt.Columns.Add("ccode"); dt.Columns.Add("cname"); dt.Columns.Add("spec"); dt.Columns.Add("dos"); dt.Columns.Add("dosu"); dt.Columns.Add("spell"); dt.Columns.Add("cap"); dt.Columns.Add("capu"); dt.Columns.Add("pishi"); dt.Columns.Add("portno"); dt.Columns.Add("idupdate"); string reqMsgSerial = "";//发送方报文流水号 List<string> msgs = PrintError.printErrMsg(info.ToString()); List<Dictionary<string, object>> rows = new List<Dictionary<string,object>>(); try { rows = MakeJson.JsonToDataTable(jsonStr, out reqMsgSerial); for (int m = 0; m < rows.Count; m++) { dt.Rows.Add(new object[] { rows[m]["ccode"].ToString(), rows[m]["cname"].ToString(), rows[m]["spec"].ToString(), rows[m]["dos"].ToString(), rows[m]["dosu"].ToString(), rows[m]["spell"].ToString(), rows[m]["cap"].ToString(), rows[m]["capu"].ToString(), rows[m]["pishi"].ToString(), rows[m]["portno"].ToString(), rows[m]["idupdate"].ToString() }); } DBHelp dbhelp = new DBHelp("sqlConnection"); //统计数据执行条数 int count = 0; int countUpdate = 0; for (int i = 0; i < dt.Rows.Count; i++) { StringBuilder sql = new StringBuilder(); switch (dt.Rows[i]["idupdate"].ToString().ToLower()) { case "insert": sql.Append("insert into [DDrug]([DrugCode],[DrugName],[Spec],[Dosage],[DosageUnit]"); sql.Append(",[SpellCode],[Capacity],[CapacityUnit],[PiShi],[PortNo],[flag]) values("); sql.Append("'" + dt.Rows[i]["ccode"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["cname"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["spec"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["dos"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["dosu"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["spell"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["cap"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["capu"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["pishi"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["portno"].ToString() + "'"); sql.Append(",0"); sql.Append(")"); break; case "update": sql.Append("update [DDrug] set"); sql.Append(" [DrugName] = '" + dt.Rows[i]["cname"].ToString() + "'"); sql.Append(",[Spec] = '" + dt.Rows[i]["spec"].ToString() + "'"); sql.Append(",[Dosage] = '" + dt.Rows[i]["dos"].ToString() + "'"); sql.Append(",[DosageUnit] = '" + dt.Rows[i]["dosu"].ToString() + "'"); sql.Append(",[SpellCode] = '" + dt.Rows[i]["spell"].ToString() + "'"); sql.Append(",[Capacity] = '" + dt.Rows[i]["cap"].ToString() + "'"); sql.Append(",[CapacityUnit] = '" + dt.Rows[i]["capu"].ToString() + "'"); sql.Append(",[PiShi] = '" + dt.Rows[i]["pishi"].ToString() + "'"); sql.Append(",[PortNo] = '" + dt.Rows[i]["portno"].ToString() + "'"); sql.Append(",[flag] = 0"); sql.Append(" where [DDrug].[DrugCode] = '" + dt.Rows[i]["ccode"].ToString() + "'"); break; case "delete": sql.Append("delete from [DDrug]"); sql.Append(" where [DDrug].[DrugCode] = '" + dt.Rows[i]["ccode"].ToString() + "'"); break; default: info = 3; throw new Exception(info.ToString()); } int n = dbhelp.addAndUpdate(sql.ToString()); if (n == 0) { if (dt.Rows[i]["idupdate"].ToString().ToLower() == "update") { sql.Append("insert into [DDrug]([DrugCode],[DrugName],[Spec],[Dosage],[DosageUnit]"); sql.Append(",[SpellCode],[Capacity],[CapacityUnit],[PiShi],[PortNo],[flag]) values("); sql.Append("'" + dt.Rows[i]["ccode"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["cname"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["spec"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["dos"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["dosu"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["spell"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["cap"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["capu"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["pishi"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["portno"].ToString() + "'"); sql.Append(",0"); sql.Append(")"); n = dbhelp.addAndUpdate(sql.ToString()); } else { CommonUtil.isCount(dt.Rows[i]["idupdate"].ToString().ToLower()); } } count += n; } if (count == dt.Rows.Count) { //标识同步数据完成 for (int j = 0; j < dt.Rows.Count; j++) { if (dt.Rows[j]["idupdate"].ToString().ToLower() == "delete") { countUpdate += 1; break; } string updateSql = "update [DDrug] set flag = 1 where [DDrug].[DrugCode] = '" + dt.Rows[j]["ccode"].ToString() + "'"; countUpdate += dbhelp.addAndUpdate(updateSql); } } else { info = 7; throw new Exception(info.ToString()); } } catch (Exception ex) { //确认错误类型 msgs = PrintError.printErrMsg(ex.Message); writeContent.writeText(DateTime.Now.ToString("HHmmss") + msgs[0], msgs[0] + "\r\n" + msgs[1] + "\r\n" + ex.ToString() + "\r\nUUID:" + reqMsgSerial); } string p; if (0 != rows.Count) { if(rows[0].ContainsKey(key)) { val = rows[0][key].ToString(); } } p = MakeHeaders.makePayLoad(key, val, msgs); if (0 != info) { err = msgs[0]; } string result = MakeHeaders.responseHeader(reqMsgSerial, responseMsgCode, err, p); writeContent.writeOutLog("Drug_" + DateTime.Now.ToString("HHmmss"), "HISLog", result); return result; }
private void NewMethod() { if (!(singleSelectedService.Getitem(Session["userID"].ToString(), Request["PaperID"].ToString()))) { Response.Write("<script language=javascript>alert('您已经考过!');window.close();</script>"); return; } string Label = labSingle.Text;//单选分数 string paperid = Session["PaperID"].ToString(); string UserId = Session["userID"].ToString(); DBHelp db = new DBHelp(); foreach (RepeaterItem item in singleRep.Items) { HiddenField titleId = item.FindControl("titleId") as HiddenField; string id = (string)titleId.Value; string str = ""; if (((RadioButton)item.FindControl("rbA")).Checked) { str = "A"; } else if (((RadioButton)item.FindControl("rbB")).Checked) { str = "B"; } else if (((RadioButton)item.FindControl("rbC")).Checked) { str = "C"; } else if (((RadioButton)item.FindControl("rbD")).Checked) { str = "D"; } string single = "insert into UserAnswer(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + UserId + "','" + paperid + "','单选题','" + id + "','" + Label + "','" + str + "','" + DateTime.Now.ToString() + "')"; db.Insert(single); } string labeM = Label3.Text;//多选分数 foreach (RepeaterItem item in Repeater2.Items) { HiddenField titleId = item.FindControl("titleId") as HiddenField; string id = (string)titleId.Value; string str = ""; if (((CheckBox)item.FindControl("CheckBox1")).Checked) { str += "A"; } if (((CheckBox)item.FindControl("CheckBox2")).Checked) { str += "B"; } if (((CheckBox)item.FindControl("CheckBox3")).Checked) { str += "C"; } if (((CheckBox)item.FindControl("CheckBox4")).Checked) { str += "D"; } string Multi = "insert into UserAnswer(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + UserId + "','" + paperid + "','多选题','" + id + "','" + labeM + "','" + str + "','" + DateTime.Now.ToString() + "')"; db.Insert(Multi); } string labeJ = Label4.Text;//判断分数 foreach (RepeaterItem item in Repeater3.Items) { HiddenField titleId = item.FindControl("titleId") as HiddenField; string id = (string)titleId.Value; string str = Convert.ToString(false); if (((RadioButton)item.FindControl("rbA")).Checked) { str = Convert.ToString(true); } else if (((RadioButton)item.FindControl("rbB")).Checked) { str = Convert.ToString(false); } string Judge = "insert into UserAnswer(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + UserId + "','" + paperid + "','判断题','" + id + "','" + labeJ + "','" + str + "','" + DateTime.Now.ToString() + "')"; db.Insert(Judge); } string labeF = Label5.Text;//填空分数 foreach (RepeaterItem item in Repeater1.Items) { HiddenField titleId = item.FindControl("titleId") as HiddenField; string id = (string)titleId.Value; string str = ""; str = ((TextBox)item.FindControl("TextBox1")).Text.Trim(); string Fill = "insert into UserAnswer(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + UserId + "','" + paperid + "','填空题','" + id + "','" + labeF + "','" + str + "','" + DateTime.Now.ToString() + "')"; db.Insert(Fill); } string labeQ = Label6.Text;//问答分数 foreach (RepeaterItem item in Repeater4.Items) { HiddenField titleId = item.FindControl("titleId") as HiddenField; string id = (string)titleId.Value; string str = ""; str = ((TextBox)item.FindControl("TextBox2")).Text.Trim(); string Que = "insert into UserAnswer(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + UserId + "','" + paperid + "','问答题','" + id + "','" + labeQ + "','" + str + "','" + DateTime.Now.ToString() + "')"; db.Insert(Que); } // Session["Test"] = "eeee"; string del = "delete UserCache where UserID='" + UserId + "' and PaperID=" + paperid; db.Insert(del); Response.Write("<script language=javascript>alert('试卷提交成功!');window.close();</script>"); }
protected void 保存Button_Click(object sender, EventArgs e) { if (Session["TNo"] == null) { X.Msg.Alert("Status", "保存出错1.").Show(); return; } if (会议名称TextField.Text == "") { X.Msg.Alert("Status", "请填写会议名称.").Show(); return; } if (发表论文TextField.Text == "") { X.Msg.Alert("Status", "请填写发表的论文名称.").Show(); return; } if (单位ComboBox.Text == "") { X.Msg.Alert("Status", "请填写参与人单位.").Show(); return; } if (起始日期DateField.Text == "") { X.Msg.Alert("Status", "请填写会议起始日期.").Show(); return; } if (结束日期DateField.Text == "") { X.Msg.Alert("Status", "请填写会议结束日期.").Show(); return; } if (接收日期DateField.Text == "") { X.Msg.Alert("Status", "请填写接收日期.").Show(); return; } if (第一作者TextField.Text == "") { X.Msg.Alert("Status", "请填写第一作者.").Show(); return; } if (级别ComboBox.Text == "") { X.Msg.Alert("Status", "请填写会议级别.").Show(); return; } if (卷号TextField.Text == "") { PJuanNo = 0; } else { int num = 0; if (int.TryParse(卷号TextField.Text, System.Globalization.NumberStyles.Integer, null, out num)) { PJuanNo = Convert.ToInt32(卷号TextField.Text); } else { X.Msg.Alert("Status", "卷号应为数字.").Show(); return; } } if (期号TextField.Text == "") { PQiNo = 0; } else { int num = 0; if (int.TryParse(期号TextField.Text, System.Globalization.NumberStyles.Integer, null, out num)) { PQiNo = Convert.ToInt32(期号TextField.Text); } else { X.Msg.Alert("Status", "期号应为数字.").Show(); return; } } DBHelp db = new DBHelp(); if (db.CheckConf(发表论文TextField.Text) == 2) { SqlConnection mycon = db.MyCon; mycon.Open(); SqlCommand mycmd = mycon.CreateCommand(); string sel = "insert into CInfo(CName,TNo,CPaperName,CDeptName,CBeginTime,CEndTime,CAcceptTime,CFundName,CPFirstName,CPSecondName,CPJuanNo,CCanJia,CPQiNo,CPYeNo,CPRank,CRemark,CType,CVType) Values('" + 会议名称TextField.Text + "','" + Session["TNo"].ToString() + "','" + 发表论文TextField.Text + "','" + 单位ComboBox.SelectedItem.Text + "','" + 起始日期DateField.Text + "','" + 结束日期DateField.Text + "','" + 接收日期DateField.Text + "','" + 基金TextField.Text + "','" + 第一作者TextField.Text + "','" + 第二作者TextField.Text + "'," + PJuanNo + ",'" + 参加人员TextField.Text + "'," + PQiNo + ",'" + 页码TextField.Text + "','" + 级别ComboBox.SelectedItem.Text + "','" + 备注TextArea.Text + "','0','0')"; mycmd.CommandText = sel; mycmd.ExecuteNonQuery(); mycon.Close(); X.Msg.Alert("Status", "保存成功.").Show(); } else { X.Msg.Alert("Status", "保存出错2.").Show(); } }
public static string savePrescription(string jsonStr) { string key = "ccode"; string val = "无法读取属性"; int info = 0; err = ""; DataTable dt = new DataTable(); #region 添加字段名 dt.Columns.Add("act_order_no"); dt.Columns.Add("parent_no"); dt.Columns.Add("ward_code"); dt.Columns.Add("wardname"); dt.Columns.Add("bed_no"); dt.Columns.Add("hospital_no"); dt.Columns.Add("inpatient_no"); dt.Columns.Add("patientname"); dt.Columns.Add("sex"); dt.Columns.Add("age"); dt.Columns.Add("ageunit"); dt.Columns.Add("birthday"); dt.Columns.Add("avdp"); dt.Columns.Add("doctor"); dt.Columns.Add("doctor_name"); dt.Columns.Add("drawer"); dt.Columns.Add("drawername"); dt.Columns.Add("freq_code"); dt.Columns.Add("charge_code"); dt.Columns.Add("drugname"); dt.Columns.Add("specification"); dt.Columns.Add("dose"); dt.Columns.Add("dose_unit"); dt.Columns.Add("quantity"); dt.Columns.Add("pack_unit"); dt.Columns.Add("drug_company"); dt.Columns.Add("start_time"); dt.Columns.Add("end_time"); dt.Columns.Add("remark"); dt.Columns.Add("selfbuy"); dt.Columns.Add("tpn"); dt.Columns.Add("state"); dt.Columns.Add("idupdate"); dt.Columns.Add("reportdate"); dt.Columns.Add("last_perform_date_time"); #endregion string reqMsgSerial = "";//发送方报文流水号 List<string> msgs = PrintError.printErrMsg(info.ToString()); List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>(); try { rows = MakeJson.JsonToDataTable(jsonStr, out reqMsgSerial); //HIS所加字段判断同步的操作类型{insert|update|delete} foreach (var row in rows) { //Dictionary<string, object> data = (Dictionary<string, object>)row; #region 获取传入数据 dt.Rows.Add(new object[] { row["act_order_no"].ToString(), row["parent_no"].ToString(), row["ward_code"].ToString(), row["wardname"].ToString(), row["bed_no"].ToString(), row["hospital_no"].ToString(), row["inpatient_no"].ToString(), row["patientname"].ToString(), row["sex"].ToString(), row["age"].ToString(), row["ageunit"].ToString(), row["birthday"].ToString(), row["avdp"].ToString(), row["doctor"].ToString(), row["doctor_name"].ToString(), "",//row["drawer"].ToString(), "",//row["drawername"].ToString(), row["freq_code"].ToString(), row["charge_code"].ToString(), row["drugname"].ToString(), row["specification"].ToString(), row["dose"].ToString(), row["dose_unit"].ToString(), row["qantity"].ToString(), row["pack_unit"].ToString(), row["drug_company"].ToString(), row["start_time"].ToString(), row["end_time"].ToString(), row["remark"].ToString(), row["selfbuy"].ToString(), row["tpn"].ToString(), row["state"].ToString(), row["idupdate"].ToString(), row["reportdate"].ToString()}); #endregion } DBHelp dbhelp = new DBHelp("sqlConnection"); //统计数据执行条数 int count = 0; int countUpdate = 0; for (int i = 0; i < dt.Rows.Count; i++) { StringBuilder sql = new StringBuilder(); switch (dt.Rows[i]["idupdate"].ToString().ToLower()) { case "insert": #region 插入SQL sql.Append("insert into [RecipeSync]([RecipeID],[RecipeNo],[GroupNo],[WardCode],[WardName]"); sql.Append(",[BedNo],[HospitalNo],[PatientCode],[PatientName],[sex],[age],[ageunit]"); sql.Append(",[Birthday],[avdp],[DoctorCode],[DoctorName],[DrawerCode],[DrawerName]"); sql.Append(",[FreqCode],[ChargeCode],[DrugName],[specification],[dose],[dose_unit],[quantity]"); sql.Append(",[pack_unit],[DrugCompany],[InceptDT],[StartTime],[EndTime],[remark],[SelfBuy],[TPN],[state],[flag]) values("); sql.Append("'" + dt.Rows[i]["inpatient_no"].ToString() + "Y" + dt.Rows[i]["parent_no"].ToString() + "Z" + dt.Rows[i]["act_order_no"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["act_order_no"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["parent_no"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["ward_code"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["wardname"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["bed_no"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["hospital_no"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["inpatient_no"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["patientname"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["sex"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["age"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["ageunit"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["birthday"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["avdp"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["doctor"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["doctor_name"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["drawer"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["drawername"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["freq_code"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["charge_code"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["drugname"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["specification"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["dose"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["dose_unit"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["quantity"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["pack_unit"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["drug_company"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["reportdate"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["start_time"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["end_time"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["remark"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["selfbuy"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["tpn"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["state"].ToString() + "'"); sql.Append(",0"); sql.Append(")"); sql.AppendLine(""); #endregion break; case "update": #region 修改SQL sql.Append("update [RecipeSync] set"); sql.Append(" [RecipeSync].[GroupNo]='" + dt.Rows[i]["parent_no"].ToString() + "'"); sql.Append(",[RecipeSync].[WardCode]='" + dt.Rows[i]["ward_code"].ToString() + "'"); sql.Append(",[RecipeSync].[WardName]='" + dt.Rows[i]["wardname"].ToString() + "'"); sql.Append(",[RecipeSync].[BedNo]='" + dt.Rows[i]["bed_no"].ToString() + "'"); sql.Append(",[RecipeSync].[HospitalNo]='" + dt.Rows[i]["hospital_no"].ToString() + "'"); sql.Append(",[RecipeSync].[PatientCode]='" + dt.Rows[i]["inpatient_no"].ToString() + "'"); sql.Append(",[RecipeSync].[PatientName]='" + dt.Rows[i]["patientname"].ToString() + "'"); sql.Append(",[RecipeSync].[sex]='" + dt.Rows[i]["sex"].ToString() + "'"); sql.Append(",[RecipeSync].[age]='" + dt.Rows[i]["age"].ToString() + "'"); sql.Append(",[RecipeSync].[ageunit]='" + dt.Rows[i]["ageunit"].ToString() + "'"); sql.Append(",[RecipeSync].[Birthday]='" + dt.Rows[i]["birthday"].ToString() + "'"); sql.Append(",[RecipeSync].[avdp]='" + dt.Rows[i]["avdp"].ToString() + "'"); sql.Append(",[RecipeSync].[DoctorCode]='" + dt.Rows[i]["doctor"].ToString() + "'"); sql.Append(",[RecipeSync].[DoctorName]='" + dt.Rows[i]["doctor_name"].ToString() + "'"); sql.Append(",[RecipeSync].[DrawerCode]='" + dt.Rows[i]["drawer"].ToString() + "'"); sql.Append(",[RecipeSync].[DrawerName]='" + dt.Rows[i]["drawername"].ToString() + "'"); sql.Append(",[RecipeSync].[FreqCode]='" + dt.Rows[i]["freq_code"].ToString() + "'"); sql.Append(",[RecipeSync].[ChargeCode]='" + dt.Rows[i]["charge_code"].ToString() + "'"); sql.Append(",[RecipeSync].[DrugName]='" + dt.Rows[i]["drugname"].ToString() + "'"); sql.Append(",[RecipeSync].[specification]='" + dt.Rows[i]["specification"].ToString() + "'"); sql.Append(",[RecipeSync].[dose]='" + dt.Rows[i]["dose"].ToString() + "'"); sql.Append(",[RecipeSync].[dose_unit]='" + dt.Rows[i]["dose_unit"].ToString() + "'"); sql.Append(",[RecipeSync].[quantity]='" + dt.Rows[i]["quantity"].ToString() + "'"); sql.Append(",[RecipeSync].[pack_unit]='" + dt.Rows[i]["pack_unit"].ToString() + "'"); sql.Append(",[RecipeSync].[DrugCompany]='" + dt.Rows[i]["drug_company"].ToString() + "'"); sql.Append(",[RecipeSync].[StartTime]='" + dt.Rows[i]["start_time"].ToString() + "'"); sql.Append(",[RecipeSync].[EndTime]='" + dt.Rows[i]["end_time"].ToString() + "'"); sql.Append(",[RecipeSync].[remark]='" + dt.Rows[i]["remark"].ToString() + "'"); sql.Append(",[RecipeSync].[SelfBuy]='" + dt.Rows[i]["selfbuy"].ToString() + "'"); sql.Append(",[RecipeSync].[TPN]='" + dt.Rows[i]["tpn"].ToString() + "'"); sql.Append(",[RecipeSync].[state]='" + dt.Rows[i]["state"].ToString() + "'"); sql.Append(",[RecipeSync].[flag] = 0"); sql.Append(" where [RecipeSync].[RecipeID] = '" + dt.Rows[i]["inpatient_no"].ToString() + "Y" + dt.Rows[i]["parent_no"].ToString() + "Z" + dt.Rows[i]["act_order_no"].ToString() + "'"); #endregion break; case "delete": sql.Append("delete from [RecipeSync]"); sql.Append(" where [RecipeSync].[RecipeID] = '" + dt.Rows[i]["inpatient_no"].ToString() + "Y" + dt.Rows[i]["parent_no"].ToString() + "Z" + dt.Rows[i]["act_order_no"].ToString() + "'"); break; default: info = 3; throw new Exception(info.ToString()); } int n = dbhelp.addAndUpdate(sql.ToString()); if (n == 0) { if (dt.Rows[i]["idupdate"].ToString().ToLower() == "update") { #region 插入SQL sql.Append("insert into [RecipeSync]([RecipeID],[RecipeNo],[GroupNo],[WardCode],[WardName]"); sql.Append(",[BedNo],[HospitalNo],[PatientCode],[PatientName],[sex],[age],[ageunit]"); sql.Append(",[Birthday],[avdp],[DoctorCode],[DoctorName],[DrawerCode],[DrawerName]"); sql.Append(",[FreqCode],[ChargeCode],[DrugName],[specification],[dose],[dose_unit],[quantity]"); sql.Append(",[pack_unit],[DrugCompany],[InceptDT],[StartTime],[EndTime],[remark],[SelfBuy],[TPN],[state],[flag]) values("); sql.Append("'" + dt.Rows[i]["inpatient_no"].ToString() + "Y" + dt.Rows[i]["parent_no"].ToString() + "Z" + dt.Rows[i]["act_order_no"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["act_order_no"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["parent_no"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["ward_code"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["wardname"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["bed_no"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["hospital_no"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["inpatient_no"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["patientname"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["sex"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["age"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["ageunit"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["birthday"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["avdp"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["doctor"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["doctor_name"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["drawer"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["drawername"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["freq_code"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["charge_code"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["drugname"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["specification"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["dose"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["dose_unit"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["quantity"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["pack_unit"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["drug_company"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["reportdate"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["start_time"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["end_time"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["remark"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["selfbuy"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["tpn"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["state"].ToString() + "'"); sql.Append(",0"); sql.Append(")"); sql.AppendLine(""); #endregion n = dbhelp.addAndUpdate(sql.ToString()); } else { CommonUtil.isCount(dt.Rows[i]["idupdate"].ToString().ToLower()); } } count += n; } if (count == dt.Rows.Count) { //标识同步数据完成 for (int j = 0; j < dt.Rows.Count; j++) { if (dt.Rows[j]["idupdate"].ToString().ToLower() == "delete") { countUpdate += 1; break; } string updateSql = "update [RecipeSync] set flag = 1 where [RecipeSync].[RecipeNo] = '" + dt.Rows[j]["act_order_no"].ToString() + "'"; countUpdate += dbhelp.addAndUpdate(updateSql); } } else { info = 7; throw new Exception(info.ToString()); } } catch (Exception ex) { msgs = PrintError.printErrMsg(ex.Message); writeContent.writeText(key + DateTime.Now.ToString("HHmmss") + msgs[0], msgs[0] + "\r\n" + msgs[1] + "\r\n" + ex.ToString() + "\r\nUUID:" + reqMsgSerial); } string p; if (0 != rows.Count) { if (rows[0].ContainsKey(key)) { val = rows[0][key].ToString(); } } p = MakeHeaders.makePayLoad(key, val, msgs); if (0 != info) { err = msgs[0]; } string result = MakeHeaders.responseHeader(reqMsgSerial, responseMsgCode, err, p); writeContent.writeOutLog("Recipe_" + DateTime.Now.ToString("HHmmss"), "HISLog", result); return result; }
protected void 提交Button_Click(object sender, EventArgs e) { if (选择题目TextField.Text == "") { X.Msg.Alert("Status", "请填写题目.").Show(); return; } if (选择期刊TextField.Text == "") { X.Msg.Alert("Status", "请填写期刊名.").Show(); return; } if (第一作者TextField.Text == "") { X.Msg.Alert("Status", "请填写第一作者.").Show(); return; } if (接收日期DateField.Text == "") { X.Msg.Alert("Status", "请填写日期.").Show(); return; } if (选择基金TextField.Text == "") { X.Msg.Alert("Status", "请填写基金.").Show(); return; } if (选择单位ComboBox.Text == "") { X.Msg.Alert("Status", "请填写单位.").Show(); return; } if (选择级别ComboBox.Text == "") { X.Msg.Alert("Status", "请填写级别.").Show(); return; } if (选择卷号TextField.Text == "") { PJuanNo = 0; } else { int num = 0; if (int.TryParse(选择卷号TextField.Text, System.Globalization.NumberStyles.Integer, null, out num)) { PJuanNo = Convert.ToInt32(选择卷号TextField.Text); } else { X.Msg.Alert("Status", "卷号应为数字.").Show(); return; } } if (选择期号TextField.Text == "") { PQiNo = 0; } else { int num = 0; if (int.TryParse(选择期号TextField.Text, System.Globalization.NumberStyles.Integer, null, out num)) { PQiNo = Convert.ToInt32(选择期号TextField.Text); } else { X.Msg.Alert("Status", "期号应为数字.").Show(); return; } } PId = Convert.ToInt32(选择编号TextField.Text); DBHelp db = new DBHelp(); SqlConnection mycon = db.MyCon; mycon.Open(); SqlCommand mycmd = mycon.CreateCommand(); string sel = "update PaperInfo Set PName='" + 选择题目TextField.Text + "',PJName='" + 选择期刊TextField.Text + "',PFirstName='" + 第一作者TextField.Text + "',PSecondName='" + 第二作者TextField.Text + "',PAcceptTime='" + 接收日期DateField.Text + "',PFundName='" + 选择基金TextField.Text + "',PJuanNo=" + PJuanNo + ",PQiNo=" + PQiNo + ",PDeptName='" + 选择单位ComboBox.SelectedItem.Text + "',PYeNo='" + 选择页号TextField.Text + "',PRank='" + 选择级别ComboBox.SelectedItem.Text + "',PRemark='" + 选择备注TextArea + "', PType='1' where PId=" + PId ; mycmd.CommandText = sel; mycmd.ExecuteNonQuery(); mycon.Close(); X.Msg.Alert("Status", "提交成功.").Show(); }
protected void GetCache() { string paperid = Session["PaperID"].ToString(); string UserId = Session["userID"].ToString(); DBHelp db = new DBHelp(); string sqlStr = "select * from UserCache where UserID='" + UserId + "' and PaperID=" + paperid; DataSet ds = db.GetDataSetSql(sqlStr); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) return; DataTable dt = ds.Tables[0]; int i = 0; foreach (RepeaterItem item in singleRep.Items) { switch (dt.Rows[i++]["UserAnswer"].ToString()) { case "A": ((RadioButton)item.FindControl("rbA")).Checked = true; break; case "B": ((RadioButton)item.FindControl("rbB")).Checked = true; break; case "C": ((RadioButton)item.FindControl("rbC")).Checked = true; break; case "D": ((RadioButton)item.FindControl("rbD")).Checked = true; break; } } foreach (RepeaterItem item in Repeater2.Items) { string str = dt.Rows[i++]["UserAnswer"].ToString(); if (str.IndexOf("A") >= 0) { ((CheckBox)item.FindControl("CheckBox1")).Checked = true; } if (str.IndexOf("B") >= 0) { ((CheckBox)item.FindControl("CheckBox2")).Checked = true; } if (str.IndexOf("C") >= 0) { ((CheckBox)item.FindControl("CheckBox3")).Checked = true; } if (str.IndexOf("D") >= 0) { ((CheckBox)item.FindControl("CheckBox4")).Checked = true; } } foreach (RepeaterItem item in Repeater3.Items) { switch (dt.Rows[i++]["UserAnswer"].ToString()) { case "True": ((RadioButton)item.FindControl("rbA")).Checked = true; break; case "False": ((RadioButton)item.FindControl("rbB")).Checked = true; break; } } foreach (RepeaterItem item in Repeater1.Items) { ((TextBox)item.FindControl("TextBox1")).Text = dt.Rows[i++]["UserAnswer"].ToString(); } foreach (RepeaterItem item in Repeater4.Items) { ((TextBox)item.FindControl("TextBox2")).Text = dt.Rows[i++]["UserAnswer"].ToString(); } }
protected void 已添加参与人Button_Click(object sender, EventArgs e) { if(编号TextField.Text=="") { X.Msg.Alert("Status", "请填写项目编号.").Show(); return; } DBHelp db = new DBHelp(); SqlConnection mycon = db.MyCon; mycon.Open(); SqlCommand mycmd = mycon.CreateCommand(); string selstr = "select * from XPInfo where XPXMNo='"+编号TextField.Text+"'"; mycmd.CommandText = selstr; SqlDataReader myreader = mycmd.ExecuteReader(); 参与人Store.DataSourceID = ""; 参与人Store.DataSource = myreader; 参与人Store.DataBind(); }
protected void 撤销审核Button_Click(object sender, EventArgs e) { int XMId; if (选择编号TextField.Text == "") { X.Msg.Alert("Status", "请选择要撤销审核的项目.").Show(); return; } XMId = Convert.ToInt32(选择编号TextField.Text); DBHelp db = new DBHelp(); SqlConnection mycon = db.MyCon; mycon.Open(); SqlCommand mycmd = mycon.CreateCommand(); try { string updateCinfo = "update XMInfo Set XVType='0' where XMId=" + XMId; mycmd.CommandText = updateCinfo; mycmd.ExecuteNonQuery(); X.Msg.Alert("Status", "项目已撤销.").Show(); return; } catch (Exception) { X.Msg.Alert("Status", "出错.").Show(); return; } finally { mycon.Close(); } }
protected void 保存Button_Click(object sender, EventArgs e) { if (名称TextField.Text == "") { X.Msg.Alert("Status", "请填写项目名称.").Show(); return; } if (编号TextField.Text == "") { X.Msg.Alert("Status", "请填写项目编号.").Show(); return; } if (项目类别ComboBox.SelectedItem.Text == "") { X.Msg.Alert("Status", "请填写项目类别.").Show(); return; } if (负责人TextField.Text == "") { X.Msg.Alert("Status", "请填写项目负责人名.").Show(); return; } if (立项日期DateField.Text == "") { X.Msg.Alert("Status", "请选择立项时间.").Show(); return; } if (结题时间DateField.Text == "") { X.Msg.Alert("Status", "请选择结题时间.").Show(); return; } if (项目金额TextField.Text == "") { XMMoney = 0; } else { int num = 0; if (int.TryParse(项目金额TextField.Text, System.Globalization.NumberStyles.Integer, null, out num)) { XMMoney = Convert.ToInt32(项目金额TextField.Text); } else { X.Msg.Alert("Status", "金额应为数字.").Show(); return; } } DBHelp db = new DBHelp(); if (db.CheckXM(编号TextField.Text) == 2) { SqlConnection mycon = db.MyCon; mycon.Open(); SqlCommand mycmd = mycon.CreateCommand(); string insel = "insert into XMInfo(XMName,XMNo,TNo,XMType,XMJtType,XMBegin,XMFzr,XMEnd,XMDeptName,XMMoney,XMFundDept,XMRemark,XType,XVType) values('"+名称TextField.Text+"','"+编号TextField.Text+"','"+Session["TNo"].ToString()+"','"+项目类别ComboBox.SelectedItem.Text+"','"+具体类型ComboBox.SelectedItem.Text+"','"+立项日期DateField.Text+"','"+负责人TextField.Text+"','"+结题时间DateField.Text+"','"+单位ComboBox.SelectedItem.Text+"','"+项目金额TextField.Text+"','"+资助单位TextField.Text+"','"+项目简介TextArea.Text+"','0','0')"; mycmd.CommandText = insel; mycmd.ExecuteNonQuery(); mycon.Close(); X.Msg.Alert("Status", "保存成功.").Show(); } else { X.Msg.Alert("Status", "该项目已保存.").Show(); } }
private void SetCache() { string Label = labSingle.Text;//单选分数 string paperid = Session["PaperID"].ToString(); string UserId = Session["userID"].ToString(); DBHelp db = new DBHelp(); string sqlStr = "select * from UserCache where UserID='" + UserId + "' and PaperID=" + paperid; DataSet ds = db.GetDataSetSql(sqlStr); bool insert = false; if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) insert = true; foreach (RepeaterItem item in singleRep.Items) { HiddenField titleId = item.FindControl("titleId") as HiddenField; string id = (string)titleId.Value; string str = ""; if (((RadioButton)item.FindControl("rbA")).Checked) { str = "A"; } else if (((RadioButton)item.FindControl("rbB")).Checked) { str = "B"; } else if (((RadioButton)item.FindControl("rbC")).Checked) { str = "C"; } else if (((RadioButton)item.FindControl("rbD")).Checked) { str = "D"; } if (insert) { string single = "insert into UserCache(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + UserId + "','" + paperid + "','单选题','" + id + "','" + Label + "','" + str + "','" + DateTime.Now.ToString() + "')"; db.Insert(single); } else { string single = "update UserCache set UserAnswer='" + str + "' where UserID='" + UserId + "' and PaperID=" + paperid + " and Type='单选题' and TitleID=" + id; db.Insert(single); } } string labeM = Label3.Text;//多选分数 foreach (RepeaterItem item in Repeater2.Items) { HiddenField titleId = item.FindControl("titleId") as HiddenField; string id = (string)titleId.Value; string str = ""; if (((CheckBox)item.FindControl("CheckBox1")).Checked) { str += "A"; } if (((CheckBox)item.FindControl("CheckBox2")).Checked) { str += "B"; } if (((CheckBox)item.FindControl("CheckBox3")).Checked) { str += "C"; } if (((CheckBox)item.FindControl("CheckBox4")).Checked) { str += "D"; } if (insert) { string Multi = "insert into UserCache(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + UserId + "','" + paperid + "','多选题','" + id + "','" + labeM + "','" + str + "','" + DateTime.Now.ToString() + "')"; db.Insert(Multi); } else { string Multi = "update UserCache set UserAnswer='" + str + "' where UserID='" + UserId + "' and PaperID=" + paperid + " and Type='多选题' and TitleID=" + id; db.Insert(Multi); } } string labeJ = Label4.Text;//判断分数 foreach (RepeaterItem item in Repeater3.Items) { HiddenField titleId = item.FindControl("titleId") as HiddenField; string id = (string)titleId.Value; string str = Convert.ToString(false); if (((RadioButton)item.FindControl("rbA")).Checked) { str = Convert.ToString(true); } else if (((RadioButton)item.FindControl("rbB")).Checked) { str = Convert.ToString(false); } if (insert) { string Judge = "insert into UserCache(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + UserId + "','" + paperid + "','判断题','" + id + "','" + labeJ + "','" + str + "','" + DateTime.Now.ToString() + "')"; db.Insert(Judge); } else { string Judge = "update UserCache set UserAnswer='" + str + "' where UserID='" + UserId + "' and PaperID=" + paperid + " and Type='判断题' and TitleID=" + id; db.Insert(Judge); } } string labeF = Label5.Text;//填空分数 foreach (RepeaterItem item in Repeater1.Items) { HiddenField titleId = item.FindControl("titleId") as HiddenField; string id = (string)titleId.Value; string str = ""; str = ((TextBox)item.FindControl("TextBox1")).Text.Trim(); if (insert) { string Fill = "insert into UserCache(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + UserId + "','" + paperid + "','填空题','" + id + "','" + labeF + "','" + str + "','" + DateTime.Now.ToString() + "')"; db.Insert(Fill); } else { string Fill = "update UserCache set UserAnswer='" + str + "' where UserID='" + UserId + "' and PaperID=" + paperid + " and Type='填空题' and TitleID=" + id; db.Insert(Fill); } } string labeQ = Label6.Text;//问答分数 foreach (RepeaterItem item in Repeater4.Items) { HiddenField titleId = item.FindControl("titleId") as HiddenField; string id = (string)titleId.Value; string str = ""; str = ((TextBox)item.FindControl("TextBox2")).Text.Trim(); if (insert) { string Que = "insert into UserCache(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + UserId + "','" + paperid + "','问答题','" + id + "','" + labeQ + "','" + str + "','" + DateTime.Now.ToString() + "')"; db.Insert(Que); } else { string Que = "update UserCache set UserAnswer='" + str + "' where UserID='" + UserId + "' and PaperID=" + paperid + " and Type='问答题' and TitleID=" + id; db.Insert(Que); } } // Session["Test"] = "eeee"; }
protected void 查询Button_Click(object sender, EventArgs e) { DBHelp db = new DBHelp(); SqlConnection mycon = db.MyCon; mycon.Open(); string selstr = ""; if (多项Radio.Checked) { if (院系ComboBox.SelectedItem.Text != "") { selstr = "select * from TInfo where TCollName='" + 院系ComboBox.SelectedItem.Text.Trim() + "'"; } } else if (单项Radio.Checked) { if (姓名TextField.Text != "") { selstr = "select * from TInfo where TName='" + 姓名TextField.Text.Trim() + "'"; } else { selstr = "select * from TInfo where TNo='" + 工号TextField.Text.Trim() + "'"; } } SqlCommand mycmd = mycon.CreateCommand(); mycmd.CommandText = selstr; SqlDataReader myread = mycmd.ExecuteReader(); 用户Store.DataSourceID = ""; 用户Store.DataSource = myread; 用户Store.DataBind(); mycon.Close(); }
private void GVbind() { string courseID = ddlCourse.SelectedValue; DBHelp db = new DBHelp();//创建DBHelp类对象 string GridView1Str = "select * from SingleProblem where CourseID=" + courseID;//根据参数设置查询单选题Sql语句 DataSet ds1 = db.GetDataSetSql(GridView1Str);//调用DBHelp类方法GetDataSetSql方法查询数据 GridView1.DataSource = ds1.Tables[0].DefaultView;//为单选题GridView控件指名数据源 GridView1.DataBind();//绑定数据 string GridView2Str = "select * from MultiProblem where CourseID=" + courseID;//根据参数设置查询多选题Sql语句 DataSet ds2 = db.GetDataSetSql(GridView2Str);//调用DBHelp类方法GetDataSetSql方法查询数据 GridView2.DataSource = ds2.Tables[0].DefaultView;//为多选题GridView控件指名数据源 GridView2.DataBind();//绑定数据 string GridView3Str = "select * from JudgeProblem where CourseID=" + courseID;//根据参数设置查询判断题Sql语句 DataSet ds3 = db.GetDataSetSql(GridView3Str);//调用DBHelp类方法GetDataSetSql方法查询数据 GridView3.DataSource = ds3.Tables[0].DefaultView;//为判断题GridView控件指名数据源 GridView3.DataBind();//绑定数据 string GridView4Str = "select * from FillBlankProblem where CourseID=" + courseID;//根据参数设置查询填空题Sql语句 DataSet ds4 = db.GetDataSetSql(GridView4Str);//调用DBHelp类方法GetDataSetSql方法查询数据 GridView4.DataSource = ds4.Tables[0].DefaultView;//为填空题GridView控件指名数据源 GridView4.DataBind();//绑定数据 string GridView5Str = "select * from QuestionProblem where CourseID=" + courseID;//根据参数设置查询问答题Sql语句 DataSet ds5 = db.GetDataSetSql(GridView5Str);//调用DBHelp类方法GetDataSetSql方法查询数据 GridView5.DataSource = ds5.Tables[0].DefaultView;//为问答题GridView控件指名数据源 GridView5.DataBind();//绑定数据 }
protected void 未审核查询Button_Click(object sender, EventArgs e) { DBHelp db = new DBHelp(); SqlConnection mycon = db.MyCon; mycon.Open(); string selstr = ""; selstr = "select * from PaperInfo where PVType='0'"; if (多项Radio.Checked) { if (院系ComboBox.SelectedItem.Text != "") { selstr = selstr+"and PDeptName='" + 院系ComboBox.SelectedItem.Text.Trim() + "'"; } /*else { X.Msg.Alert("Status", "请选择查询单位.").Show(); return; }*/ } else if (单项Radio.Checked) { if (题名TextField.Text != "") { selstr = selstr + "and PName='" + 题名TextField.Text.Trim() + "'"; } else if (工号TextField.Text != "") { selstr = selstr + "and TNo='" + 工号TextField.Text.Trim() + "'"; } else if (作者TextField.Text != "") { selstr = selstr + "and PFirstName like'%" + 作者TextField.Text.Trim() + "%'or PSecondName Like '%" + 作者TextField.Text.Trim() + "%'"; } /*else { X.Msg.Alert("Status", "请填写查询条件.").Show(); return; }*/ } SqlCommand mycmd = mycon.CreateCommand(); mycmd.CommandText = selstr; SqlDataReader myread = mycmd.ExecuteReader(); 论文Store.DataSourceID = ""; 论文Store.DataSource = myread; 论文Store.DataBind(); mycon.Close(); 审核Button.Disabled = false; 撤销审核Button.Disabled = true; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) {//第一次加载,则执行下面语句,单击提交按钮时,IsPostBack=true. 教工号TextField.ReadOnly = true; 教师姓名TextField.ReadOnly = true; 性别ComboBox.ReadOnly = true; 教师出生DateField.ReadOnly = true; 籍贯TextField.ReadOnly = true; 民族ComBox.ReadOnly = true; 院系TextField.ReadOnly = true; 教育程度TextField.ReadOnly = true; 政治面貌ComBox.ReadOnly = true; 邮箱TextField.ReadOnly = true; 民族Store.DataSource = new object[] { new object[]{"汉族"}, new object[]{"蒙古族"}, new object[]{"回族"},new object[]{"藏族"}, new object[]{"维吾尔族"},new object[]{"苗族"}, new object[]{"彝族"}, new object[]{"壮族"},new object[]{"布依族"},new object[]{"侗族"},new object[]{"瑶族"},new object[]{"白族"},new object[]{"土家族"},new object[]{"哈尼族"},new object[]{"哈萨克族"},new object[]{"傣族"},new object[]{"黎族"}, new object[]{"朝鲜族"},new object[]{"满族"},new object[]{"僳僳族"},new object[]{"佤族"},new object[]{"畲族"},new object[]{"高山族"},new object[]{"拉祜族"},new object[]{"水族"},new object[]{"东乡族"},new object[]{"纳西族"},new object[]{"景颇族"}, new object[]{"柯尔克孜族"},new object[]{"土族"},new object[]{"达斡尔族"},new object[]{"仫佬族"},new object[]{"羌族"},new object[]{"布朗族"},new object[]{"撒拉族"},new object[]{"锡伯族"},new object[]{"阿昌族"},new object[]{"普米族"},new object[]{"塔吉克族"}, new object[]{"怒族"},new object[]{"仡佬族"},new object[]{"毛南族"},new object[]{"乌孜别克族"},new object[]{"俄罗斯族"},new object[]{"鄂温克族"},new object[]{"德昂族"},new object[]{"保安族"},new object[]{"裕固族"},new object[]{"京族"},new object[]{"塔塔尔族"}, new object[]{"独龙族"},new object[]{"鄂伦春族"},new object[]{"赫哲族"},new object[]{"门巴族"},new object[]{"珞巴族"},new object[]{"基诺族"}, }; 民族Store.DataBind(); DataTable dt; if (Session["TNo"] != null) { Tno = Session["TNo"].ToString(); DBHelp db = new DBHelp(); dt = db.SelectTInfo(Tno); Tname = dt.Rows[0]["TName"].ToString(); Tsex = dt.Rows[0]["TSex"].ToString(); Tbith = dt.Rows[0]["TBith"].ToString(); Tjiguan = dt.Rows[0]["TJiGuan"].ToString(); Tnation = dt.Rows[0]["TNation"].ToString(); Tcollname = dt.Rows[0]["TCollName"].ToString(); Teduback = dt.Rows[0]["TEduBack"].ToString(); Tmianmao = dt.Rows[0]["TMianMao"].ToString(); Temail = dt.Rows[0]["TEmail"].ToString(); Tpaperno = dt.Rows[0]["TPaperNo"].ToString(); Tconferenceno = dt.Rows[0]["TConferenceNo"].ToString(); Thxxmno = dt.Rows[0]["THxxmNo"].ToString(); Tzxxmno = dt.Rows[0]["TZxxmNo"].ToString(); 教工号TextField.Text = Tno; 教师姓名TextField.Text = Tname; 性别ComboBox.Text = Tsex; 教师出生DateField.Text = Tbith; 籍贯TextField.Text = Tjiguan; 民族ComBox.Text = Tnation; 院系TextField.Text = Tcollname; 教育程度TextField.Text = Teduback; 政治面貌ComBox.Text = Tmianmao; 邮箱TextField.Text = Temail; 发表论文Label.Text += Tpaperno.ToString(); 参加会议Label.Text += Tconferenceno.ToString(); Label1.Text = (Convert.ToInt32(Thxxmno) + Convert.ToInt32(Tzxxmno)).ToString() + ";"; Label2.Text = Thxxmno.ToString() + ";"; Label3.Text = Tzxxmno.ToString(); } } }
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e) { DBHelp db = new DBHelp(); string insertpaper = "insert into Exercise(CourseID,ExerciseName,ExerciseState) values(" + int.Parse(ddlCourse.SelectedValue) + ",'" + txtExerciseName.Text + "',1) SELECT @@IDENTITY as id"; int afterID = GetIDInsert(insertpaper);//保存试卷,并返回自动生成的试卷编号 if (afterID > 0) { for (int i = 0; i < this.GridView1.Rows.Count; i++) { bool isChecked = ((CheckBox)GridView1.Rows[i].FindControl("chkSelect1")).Checked; if (isChecked) { string str1 = ((Label)GridView1.Rows[i].FindControl("Label3")).Text; string single = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'单选题'," + str1 + "," + int.Parse(txtSingleFen.Text) + ")"; db.Insert(single); } } for (int i = 0; i < this.GridView2.Rows.Count; i++) { bool isChecked = ((CheckBox)GridView2.Rows[i].FindControl("chkSelect2")).Checked; if (isChecked) { string str2 = ((Label)GridView2.Rows[i].FindControl("Label6")).Text; string multi = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'多选题'," + str2 + "," + int.Parse(txtMultiFen.Text) + ")"; db.Insert(multi); } } for (int i = 0; i < this.GridView3.Rows.Count; i++) { bool isChecked = ((CheckBox)GridView3.Rows[i].FindControl("chkSelect3")).Checked; if (isChecked) { string str3 = ((Label)GridView3.Rows[i].FindControl("Label7")).Text; string judge = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'判断题'," + str3 + "," + int.Parse(txtJudgeFen.Text) + ")"; db.Insert(judge); } } for (int i = 0; i < this.GridView4.Rows.Count; i++) { bool isChecked = ((CheckBox)GridView4.Rows[i].FindControl("chkSelect4")).Checked; if (isChecked) { string str4 = ((Label)GridView4.Rows[i].FindControl("Label8")).Text; string fill = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'填空题'," + str4 + "," + int.Parse(txtFillFen.Text) + ")"; db.Insert(fill); } } for (int i = 0; i < this.GridView5.Rows.Count; i++) { bool isChecked = ((CheckBox)GridView5.Rows[i].FindControl("chkSelect5")).Checked; if (isChecked) { string str5 = ((Label)GridView5.Rows[i].FindControl("Label23")).Text; string que = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'问答题'," + str5 + "," + int.Parse(txtQuestionFen.Text) + ")"; db.Insert(que); } } } Response.Write("<script language=javascript>alert('保存成功');location='ExerciseLists.aspx'</script>"); }
public static string saveQuantity(string jsonStr) { string key = "drugcode"; string val = "无法读取属性"; int info = 0; err = ""; DataTable dt = new DataTable(); #region 添加表字段 dt.Columns.Add("drugcode"); dt.Columns.Add("quantity"); dt.Columns.Add("idupdate"); #endregion string reqMsgSerial = "";//发送方报文流水号 List<string> msgs = PrintError.printErrMsg(info.ToString()); List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>(); try { rows = MakeJson.JsonToDataTable(jsonStr, out reqMsgSerial); //HIS所加字段判断同步的操作类型{insert|update|delete} foreach (var row in rows) { //Dictionary<string, object> data = (Dictionary<string, object>)row; dt.Rows.Add(new object[] { row["drugcode"].ToString(), row["quantity"].ToString(), row["idupdate"].ToString() }); } DBHelp dbhelp = new DBHelp("sqlConnection"); //统计数据执行条数 int count = 0; int countUpdate = 0; for (int i = 0; i < dt.Rows.Count; i++) { StringBuilder sql = new StringBuilder(); switch (dt.Rows[i]["idupdate"].ToString().ToLower()) { case "insert": sql.Append("insert into [Quantity]([drugcode],[quantity],[flag]) values("); sql.Append("'" + dt.Rows[i]["drugcode"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["quantity"].ToString() + "'"); sql.Append(",0"); sql.Append(")"); break; case "update": sql.Append("update [Quantity] set"); sql.Append(" [Quantity].[quantity] = '" + dt.Rows[i]["quantity"].ToString() + "'"); sql.Append(",[Quantity].[flag] = 0"); sql.Append(" where [Quantity].[drugcode] = '" + dt.Rows[i]["drugcode"].ToString() + "'"); break; case "delete": sql.Append("delete from [Quantity]"); sql.Append(" where [Quantity].[drugcode] = '" + dt.Rows[i]["drugcode"].ToString() + "'"); break; default: info = 3; throw new Exception(info.ToString()); } int n = dbhelp.addAndUpdate(sql.ToString()); if (n == 0) { if (dt.Rows[i]["idupdate"].ToString().ToLower() == "update") { sql.Append("insert into [Quantity]([drugcode],[quantity],[flag]) values("); sql.Append("'" + dt.Rows[i]["drugcode"].ToString() + "'"); sql.Append(",'" + dt.Rows[i]["quantity"].ToString() + "'"); sql.Append(",0"); sql.Append(")"); n = dbhelp.addAndUpdate(sql.ToString()); } else { CommonUtil.isCount(dt.Rows[i]["idupdate"].ToString().ToLower()); } } count += n; } if (count == dt.Rows.Count) { //标识同步数据完成 for (int j = 0; j < dt.Rows.Count; j++) { if (dt.Rows[j]["idupdate"].ToString().ToLower() == "delete") { countUpdate += 1; break; } string updateSql = "update [Quantity] set flag = 1 where [Quantity].[drugcode] = '" + dt.Rows[j]["drugcode"].ToString() + "'"; countUpdate += dbhelp.addAndUpdate(updateSql); } } else { info = 7; throw new Exception(info.ToString()); } } catch (Exception ex) { msgs = PrintError.printErrMsg(ex.Message); writeContent.writeText(DateTime.Now.ToString("HHmmss") + msgs[0], msgs[0] + "\r\n" + msgs[1] + "\r\n" + ex.ToString() + "\r\nUUID:" + reqMsgSerial); } string p; if (0 != rows.Count) { if (rows[0].ContainsKey(key)) { val = rows[0][key].ToString(); } } p = MakeHeaders.makePayLoad(key, val, msgs); if (0 != info) { err = msgs[0]; } string result = MakeHeaders.responseHeader(reqMsgSerial, responseMsgCode, err, p); writeContent.writeOutLog("Quantity_" + DateTime.Now.ToString("HHmmss"), "HISLog", result); return result; }
protected void 提交Button_Click(object sender, EventArgs e) { if (选择名称TextField.Text == "") { X.Msg.Alert("Status", "请填写项目名称.").Show(); return; } if (选择项目号TextField.Text == "") { X.Msg.Alert("Status", "请填写项目编号.").Show(); return; } if (选择类型ComboBox.SelectedItem.Text == "") { X.Msg.Alert("Status", "请填写项目类别.").Show(); return; } if (选择负责人TextField.Text == "") { X.Msg.Alert("Status", "请填写项目负责人名.").Show(); return; } if (选择立项日期DateField.Text == "") { X.Msg.Alert("Status", "请选择立项时间.").Show(); return; } if (选择结题DateField.Text == "") { X.Msg.Alert("Status", "请选择结题时间.").Show(); return; } if (选择金额TextField.Text == "") { XMMoney = 0; } else { int num = 0; if (int.TryParse(选择金额TextField.Text, System.Globalization.NumberStyles.Integer, null, out num)) { XMMoney = Convert.ToInt32(选择金额TextField.Text); } else { X.Msg.Alert("Status", "金额应为数字.").Show(); return; } } DBHelp db = new DBHelp(); XMId = Convert.ToInt32(选择编号TextField.Text); SqlConnection mycon = db.MyCon; mycon.Open(); SqlCommand mycmd = mycon.CreateCommand(); string sel = "update XMInfo Set XMName='" + 选择名称TextField.Text + "',XMNo='" + 选择项目号TextField.Text + "',XMType='" + 选择类型ComboBox.SelectedItem.Text + "',XMJtType='" + 具体类型ComboBox.SelectedItem.Text + "',XMBegin='" + 选择立项日期DateField.Text + "',XMFzr='" + 选择负责人TextField.Text + "',XMEnd='" + 选择结题DateField.Text + "',XMDeptName='" + 选择单位ComboBox.SelectedItem.Text + "',XMMoney='" + 选择金额TextField.Text + "',XMFundDept='" + 选择资助单位TextField.Text + "',XMRemark='" + 选择备注TextArea.Text + "', XType='1' where XMId=" + XMId; mycmd.CommandText = sel; mycmd.ExecuteNonQuery(); mycon.Close(); X.Msg.Alert("Status", "提交成功.").Show(); }