/// <summary> /// 增加一条数据 /// </summary> public bool Add(ZIT.AppRouteServer.Model.ServiceQualityInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ServiceQualityInfo("); strSql.Append("LSH,CASEID,CCCC,CLID,TIMETAKEN,MONEY,KM,ADDTIME)"); strSql.Append(" values ("); strSql.Append(":LSH,:CASEID,:CCCC,:CLID,:TIMETAKEN,:MONEY,:KM,:ADDTIME)"); OracleParameter[] parameters = { new OracleParameter(":LSH", DBOpHelper.GetString(model.LSH)), new OracleParameter(":CASEID", DBOpHelper.GetString(model.CASEID)), new OracleParameter(":CCCC", DBOpHelper.GetNumber(model.CCCC)), new OracleParameter(":CLID", DBOpHelper.GetString(model.CLID)), new OracleParameter(":TIMETAKEN", DBOpHelper.GetNumber(model.TIMETAKEN)), new OracleParameter(":MONEY", DBOpHelper.GetNumber(model.MONEY)), new OracleParameter(":KM", DBOpHelper.GetNumber(model.KM)), new OracleParameter(":ADDTIME", DBOpHelper.GetDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))) }; int rows = DbHelperOra.ExecuteSql(SysParameters.DBConnectString, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ZIT.AppRouteServer.Model.ServiceQualityInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ServiceQualityInfo set "); strSql.Append("LSH=:LSH,"); strSql.Append("CASEID=:CASEID,"); strSql.Append("CCCC=:CCCC,"); strSql.Append("CLID=:CLID,"); strSql.Append("TIMETAKEN=:TIMETAKEN,"); strSql.Append("MONEY=:MONEY,"); strSql.Append("KM=:KM"); strSql.Append(" where "); OracleParameter[] parameters = { new OracleParameter(":LSH", OracleType.VarChar, 19), new OracleParameter(":CASEID", OracleType.VarChar, 50), new OracleParameter(":CCCC", OracleType.Number, 2), new OracleParameter(":CLID", OracleType.VarChar, 10), new OracleParameter(":TIMETAKEN", OracleType.Number, 4), new OracleParameter(":MONEY", OracleType.Number, 4), new OracleParameter(":KM", OracleType.Number, 4) }; parameters[0].Value = model.LSH; parameters[1].Value = model.CASEID; parameters[2].Value = model.CCCC; parameters[3].Value = model.CLID; parameters[4].Value = model.TIMETAKEN; parameters[5].Value = model.MONEY; parameters[6].Value = model.KM; int rows = DbHelperOra.ExecuteSql("", strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ZIT.AppRouteServer.Model.ServiceQualityInfo GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select LSH,CASEID,CCCC,CLID,TIMETAKEN,MONEY,KM from ServiceQualityInfo "); strSql.Append(" where "); OracleParameter[] parameters = { }; ZIT.AppRouteServer.Model.ServiceQualityInfo model = new ZIT.AppRouteServer.Model.ServiceQualityInfo(); DataSet ds = DbHelperOra.Query("", strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ZIT.AppRouteServer.Model.ServiceQualityInfo DataRowToModel(DataRow row) { ZIT.AppRouteServer.Model.ServiceQualityInfo model = new ZIT.AppRouteServer.Model.ServiceQualityInfo(); if (row != null) { if (row["LSH"] != null) { model.LSH = row["LSH"].ToString(); } if (row["CASEID"] != null) { model.CASEID = row["CASEID"].ToString(); } if (row["CCCC"] != null && row["CCCC"].ToString() != "") { model.CCCC = int.Parse(row["CCCC"].ToString()); } if (row["CLID"] != null) { model.CLID = row["CLID"].ToString(); } if (row["TIMETAKEN"] != null && row["TIMETAKEN"].ToString() != "") { model.TIMETAKEN = int.Parse(row["TIMETAKEN"].ToString()); } if (row["MONEY"] != null && row["MONEY"].ToString() != "") { model.MONEY = int.Parse(row["MONEY"].ToString()); } if (row["KM"] != null && row["KM"].ToString() != "") { model.KM = int.Parse(row["KM"].ToString()); } } return(model); }