/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.s3ShuHouFuZhu GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,sBianMa,bFuZhuHuaLiao,sZhouQi,sFangAn,sTiBiaoMianJi,sShiJiJiLiang,sWBC,sHb,sPLT,sBMI,sNRS2002,sECOG,bFuCha,sCT,sMRI,sNeiJing,sPET,bFuFa,sWeiZhi,sChuliFangShi,sjiLiang,sLiaoCheng,sLiaoXiaoPingFen,iUserID,sZhuYuanHao,bBaXiangYaoWu,sYaoWuPinZhong,sJianCeResult from s3ShuHouFuZhu "); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = ID; Maticsoft.Model.s3ShuHouFuZhu model = new Maticsoft.Model.s3ShuHouFuZhu(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.s3ShuHouFuZhu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into s3ShuHouFuZhu("); strSql.Append("sBianMa,bFuZhuHuaLiao,sZhouQi,sFangAn,sTiBiaoMianJi,sShiJiJiLiang,sWBC,sHb,sPLT,sBMI,sNRS2002,sECOG,bFuCha,sCT,sMRI,sNeiJing,sPET,bFuFa,sWeiZhi,sChuliFangShi,sjiLiang,sLiaoCheng,sLiaoXiaoPingFen,iUserID,sZhuYuanHao,bBaXiangYaoWu,sYaoWuPinZhong,sJianCeResult)"); strSql.Append(" values ("); strSql.Append("@sBianMa,@bFuZhuHuaLiao,@sZhouQi,@sFangAn,@sTiBiaoMianJi,@sShiJiJiLiang,@sWBC,@sHb,@sPLT,@sBMI,@sNRS2002,@sECOG,@bFuCha,@sCT,@sMRI,@sNeiJing,@sPET,@bFuFa,@sWeiZhi,@sChuliFangShi,@sjiLiang,@sLiaoCheng,@sLiaoXiaoPingFen,@iUserID,@sZhuYuanHao,@bBaXiangYaoWu,@sYaoWuPinZhong,@sJianCeResult)"); OleDbParameter[] parameters = { new OleDbParameter("@sBianMa", OleDbType.VarChar, 255), new OleDbParameter("@bFuZhuHuaLiao", OleDbType.Boolean, 1), new OleDbParameter("@sZhouQi", OleDbType.VarChar, 255), new OleDbParameter("@sFangAn", OleDbType.VarChar, 255), new OleDbParameter("@sTiBiaoMianJi", OleDbType.VarChar, 255), new OleDbParameter("@sShiJiJiLiang", OleDbType.VarChar, 255), new OleDbParameter("@sWBC", OleDbType.VarChar, 255), new OleDbParameter("@sHb", OleDbType.VarChar, 255), new OleDbParameter("@sPLT", OleDbType.VarChar, 255), new OleDbParameter("@sBMI", OleDbType.VarChar, 255), new OleDbParameter("@sNRS2002", OleDbType.VarChar, 255), new OleDbParameter("@sECOG", OleDbType.VarChar, 255), new OleDbParameter("@bFuCha", OleDbType.Boolean, 1), new OleDbParameter("@sCT", OleDbType.VarChar, 255), new OleDbParameter("@sMRI", OleDbType.VarChar, 255), new OleDbParameter("@sNeiJing", OleDbType.VarChar, 255), new OleDbParameter("@sPET", OleDbType.VarChar, 255), new OleDbParameter("@bFuFa", OleDbType.Boolean, 1), new OleDbParameter("@sWeiZhi", OleDbType.VarChar, 255), new OleDbParameter("@sChuliFangShi", OleDbType.VarChar, 255), new OleDbParameter("@sjiLiang", OleDbType.VarChar, 255), new OleDbParameter("@sLiaoCheng", OleDbType.VarChar, 255), new OleDbParameter("@sLiaoXiaoPingFen", OleDbType.VarChar, 255), new OleDbParameter("@iUserID", OleDbType.VarChar, 255), new OleDbParameter("@sZhuYuanHao", OleDbType.VarChar, 255), new OleDbParameter("@bBaXiangYaoWu", OleDbType.Boolean, 1), new OleDbParameter("@sYaoWuPinZhong", OleDbType.VarChar, 255), new OleDbParameter("@sJianCeResult", OleDbType.VarChar, 255) }; parameters[0].Value = model.sBianMa; parameters[1].Value = model.bFuZhuHuaLiao; parameters[2].Value = model.sZhouQi; parameters[3].Value = model.sFangAn; parameters[4].Value = model.sTiBiaoMianJi; parameters[5].Value = model.sShiJiJiLiang; parameters[6].Value = model.sWBC; parameters[7].Value = model.sHb; parameters[8].Value = model.sPLT; parameters[9].Value = model.sBMI; parameters[10].Value = model.sNRS2002; parameters[11].Value = model.sECOG; parameters[12].Value = model.bFuCha; parameters[13].Value = model.sCT; parameters[14].Value = model.sMRI; parameters[15].Value = model.sNeiJing; parameters[16].Value = model.sPET; parameters[17].Value = model.bFuFa; parameters[18].Value = model.sWeiZhi; parameters[19].Value = model.sChuliFangShi; parameters[20].Value = model.sjiLiang; parameters[21].Value = model.sLiaoCheng; parameters[22].Value = model.sLiaoXiaoPingFen; parameters[23].Value = model.iUserID; parameters[24].Value = model.sZhuYuanHao; parameters[25].Value = model.bBaXiangYaoWu; parameters[26].Value = model.sYaoWuPinZhong; parameters[27].Value = model.sJianCeResult; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.s3ShuHouFuZhu DataRowToModel(DataRow row) { Maticsoft.Model.s3ShuHouFuZhu model = new Maticsoft.Model.s3ShuHouFuZhu(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["sBianMa"] != null) { model.sBianMa = row["sBianMa"].ToString(); } if (row["bFuZhuHuaLiao"] != null && row["bFuZhuHuaLiao"].ToString() != "") { if ((row["bFuZhuHuaLiao"].ToString() == "1") || (row["bFuZhuHuaLiao"].ToString().ToLower() == "true")) { model.bFuZhuHuaLiao = true; } else { model.bFuZhuHuaLiao = false; } } if (row["sZhouQi"] != null) { model.sZhouQi = row["sZhouQi"].ToString(); } if (row["sFangAn"] != null) { model.sFangAn = row["sFangAn"].ToString(); } if (row["sTiBiaoMianJi"] != null) { model.sTiBiaoMianJi = row["sTiBiaoMianJi"].ToString(); } if (row["sShiJiJiLiang"] != null) { model.sShiJiJiLiang = row["sShiJiJiLiang"].ToString(); } if (row["sWBC"] != null) { model.sWBC = row["sWBC"].ToString(); } if (row["sHb"] != null) { model.sHb = row["sHb"].ToString(); } if (row["sPLT"] != null) { model.sPLT = row["sPLT"].ToString(); } if (row["sBMI"] != null) { model.sBMI = row["sBMI"].ToString(); } if (row["sNRS2002"] != null) { model.sNRS2002 = row["sNRS2002"].ToString(); } if (row["sECOG"] != null) { model.sECOG = row["sECOG"].ToString(); } if (row["bFuCha"] != null && row["bFuCha"].ToString() != "") { if ((row["bFuCha"].ToString() == "1") || (row["bFuCha"].ToString().ToLower() == "true")) { model.bFuCha = true; } else { model.bFuCha = false; } } if (row["sCT"] != null) { model.sCT = row["sCT"].ToString(); } if (row["sMRI"] != null) { model.sMRI = row["sMRI"].ToString(); } if (row["sNeiJing"] != null) { model.sNeiJing = row["sNeiJing"].ToString(); } if (row["sPET"] != null) { model.sPET = row["sPET"].ToString(); } if (row["bFuFa"] != null && row["bFuFa"].ToString() != "") { if ((row["bFuFa"].ToString() == "1") || (row["bFuFa"].ToString().ToLower() == "true")) { model.bFuFa = true; } else { model.bFuFa = false; } } if (row["sWeiZhi"] != null) { model.sWeiZhi = row["sWeiZhi"].ToString(); } if (row["sChuliFangShi"] != null) { model.sChuliFangShi = row["sChuliFangShi"].ToString(); } if (row["sjiLiang"] != null) { model.sjiLiang = row["sjiLiang"].ToString(); } if (row["sLiaoCheng"] != null) { model.sLiaoCheng = row["sLiaoCheng"].ToString(); } if (row["sLiaoXiaoPingFen"] != null) { model.sLiaoXiaoPingFen = row["sLiaoXiaoPingFen"].ToString(); } if (row["iUserID"] != null) { model.iUserID = row["iUserID"].ToString(); } if (row["sZhuYuanHao"] != null) { model.sZhuYuanHao = row["sZhuYuanHao"].ToString(); } if (row["bBaXiangYaoWu"] != null && row["bBaXiangYaoWu"].ToString() != "") { if ((row["bBaXiangYaoWu"].ToString() == "1") || (row["bBaXiangYaoWu"].ToString().ToLower() == "true")) { model.bBaXiangYaoWu = true; } else { model.bBaXiangYaoWu = false; } } if (row["sYaoWuPinZhong"] != null) { model.sYaoWuPinZhong = row["sYaoWuPinZhong"].ToString(); } if (row["sJianCeResult"] != null) { model.sJianCeResult = row["sJianCeResult"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.s3ShuHouFuZhu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update s3ShuHouFuZhu set "); strSql.Append("sBianMa=@sBianMa,"); strSql.Append("bFuZhuHuaLiao=@bFuZhuHuaLiao,"); strSql.Append("sZhouQi=@sZhouQi,"); strSql.Append("sFangAn=@sFangAn,"); strSql.Append("sTiBiaoMianJi=@sTiBiaoMianJi,"); strSql.Append("sShiJiJiLiang=@sShiJiJiLiang,"); strSql.Append("sWBC=@sWBC,"); strSql.Append("sHb=@sHb,"); strSql.Append("sPLT=@sPLT,"); strSql.Append("sBMI=@sBMI,"); strSql.Append("sNRS2002=@sNRS2002,"); strSql.Append("sECOG=@sECOG,"); strSql.Append("bFuCha=@bFuCha,"); strSql.Append("sCT=@sCT,"); strSql.Append("sMRI=@sMRI,"); strSql.Append("sNeiJing=@sNeiJing,"); strSql.Append("sPET=@sPET,"); strSql.Append("bFuFa=@bFuFa,"); strSql.Append("sWeiZhi=@sWeiZhi,"); strSql.Append("sChuliFangShi=@sChuliFangShi,"); strSql.Append("sjiLiang=@sjiLiang,"); strSql.Append("sLiaoCheng=@sLiaoCheng,"); strSql.Append("sLiaoXiaoPingFen=@sLiaoXiaoPingFen,"); strSql.Append("iUserID=@iUserID,"); strSql.Append("sZhuYuanHao=@sZhuYuanHao,"); strSql.Append("bBaXiangYaoWu=@bBaXiangYaoWu,"); strSql.Append("sYaoWuPinZhong=@sYaoWuPinZhong,"); strSql.Append("sJianCeResult=@sJianCeResult"); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@sBianMa", OleDbType.VarChar, 255), new OleDbParameter("@bFuZhuHuaLiao", OleDbType.Boolean, 1), new OleDbParameter("@sZhouQi", OleDbType.VarChar, 255), new OleDbParameter("@sFangAn", OleDbType.VarChar, 255), new OleDbParameter("@sTiBiaoMianJi", OleDbType.VarChar, 255), new OleDbParameter("@sShiJiJiLiang", OleDbType.VarChar, 255), new OleDbParameter("@sWBC", OleDbType.VarChar, 255), new OleDbParameter("@sHb", OleDbType.VarChar, 255), new OleDbParameter("@sPLT", OleDbType.VarChar, 255), new OleDbParameter("@sBMI", OleDbType.VarChar, 255), new OleDbParameter("@sNRS2002", OleDbType.VarChar, 255), new OleDbParameter("@sECOG", OleDbType.VarChar, 255), new OleDbParameter("@bFuCha", OleDbType.Boolean, 1), new OleDbParameter("@sCT", OleDbType.VarChar, 255), new OleDbParameter("@sMRI", OleDbType.VarChar, 255), new OleDbParameter("@sNeiJing", OleDbType.VarChar, 255), new OleDbParameter("@sPET", OleDbType.VarChar, 255), new OleDbParameter("@bFuFa", OleDbType.Boolean, 1), new OleDbParameter("@sWeiZhi", OleDbType.VarChar, 255), new OleDbParameter("@sChuliFangShi", OleDbType.VarChar, 255), new OleDbParameter("@sjiLiang", OleDbType.VarChar, 255), new OleDbParameter("@sLiaoCheng", OleDbType.VarChar, 255), new OleDbParameter("@sLiaoXiaoPingFen", OleDbType.VarChar, 255), new OleDbParameter("@iUserID", OleDbType.VarChar, 255), new OleDbParameter("@sZhuYuanHao", OleDbType.VarChar, 255), new OleDbParameter("@bBaXiangYaoWu", OleDbType.Boolean, 1), new OleDbParameter("@sYaoWuPinZhong", OleDbType.VarChar, 255), new OleDbParameter("@sJianCeResult", OleDbType.VarChar, 255), new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = model.sBianMa; parameters[1].Value = model.bFuZhuHuaLiao; parameters[2].Value = model.sZhouQi; parameters[3].Value = model.sFangAn; parameters[4].Value = model.sTiBiaoMianJi; parameters[5].Value = model.sShiJiJiLiang; parameters[6].Value = model.sWBC; parameters[7].Value = model.sHb; parameters[8].Value = model.sPLT; parameters[9].Value = model.sBMI; parameters[10].Value = model.sNRS2002; parameters[11].Value = model.sECOG; parameters[12].Value = model.bFuCha; parameters[13].Value = model.sCT; parameters[14].Value = model.sMRI; parameters[15].Value = model.sNeiJing; parameters[16].Value = model.sPET; parameters[17].Value = model.bFuFa; parameters[18].Value = model.sWeiZhi; parameters[19].Value = model.sChuliFangShi; parameters[20].Value = model.sjiLiang; parameters[21].Value = model.sLiaoCheng; parameters[22].Value = model.sLiaoXiaoPingFen; parameters[23].Value = model.iUserID; parameters[24].Value = model.sZhuYuanHao; parameters[25].Value = model.bBaXiangYaoWu; parameters[26].Value = model.sYaoWuPinZhong; parameters[27].Value = model.sJianCeResult; parameters[28].Value = model.ID; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }