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();
}
