/// <summary> /// 得到一个对象实体 /// </summary> public iRan.Model.ServiceOrder DataRowToModel(DataRow row) { iRan.Model.ServiceOrder model = new iRan.Model.ServiceOrder(); if (row != null) { if (row["Oid"] != null && row["Oid"].ToString() != "") { model.Oid = decimal.Parse(row["Oid"].ToString()); } if (row["Uid"] != null && row["Uid"].ToString() != "") { model.Uid = int.Parse(row["Uid"].ToString()); } if (row["esOrderCreateTime"] != null && row["esOrderCreateTime"].ToString() != "") { model.esOrderCreateTime = DateTime.Parse(row["esOrderCreateTime"].ToString()); } if (row["esOrderContent"] != null) { model.esOrderContent = row["esOrderContent"].ToString(); } if (row["esOrderTotalPrice"] != null && row["esOrderTotalPrice"].ToString() != "") { model.esOrderTotalPrice = decimal.Parse(row["esOrderTotalPrice"].ToString()); } if (row["esOrderStatus"] != null && row["esOrderStatus"].ToString() != "") { model.esOrderStatus = int.Parse(row["esOrderStatus"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(iRan.Model.ServiceOrder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ServiceOrder("); strSql.Append("Oid,Uid,esOrderCreateTime,esOrderContent,esOrderTotalPrice,esOrderStatus)"); strSql.Append(" values ("); strSql.Append("@Oid,@Uid,@esOrderCreateTime,@esOrderContent,@esOrderTotalPrice,@esOrderStatus)"); SqlParameter[] parameters = { new SqlParameter("@Oid", SqlDbType.Decimal, 9), new SqlParameter("@Uid", SqlDbType.Int, 4), new SqlParameter("@esOrderCreateTime", SqlDbType.DateTime), new SqlParameter("@esOrderContent", SqlDbType.VarChar, 512), new SqlParameter("@esOrderTotalPrice", SqlDbType.Float, 8), new SqlParameter("@esOrderStatus", SqlDbType.Int, 4) }; parameters[0].Value = model.Oid; parameters[1].Value = model.Uid; parameters[2].Value = model.esOrderCreateTime; parameters[3].Value = model.esOrderContent; parameters[4].Value = model.esOrderTotalPrice; parameters[5].Value = model.esOrderStatus; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(iRan.Model.ServiceOrder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ServiceOrder set "); strSql.Append("Uid=@Uid,"); strSql.Append("esOrderCreateTime=@esOrderCreateTime,"); strSql.Append("esOrderContent=@esOrderContent,"); strSql.Append("esOrderTotalPrice=@esOrderTotalPrice,"); strSql.Append("esOrderStatus=@esOrderStatus"); strSql.Append(" where Oid=@Oid "); SqlParameter[] parameters = { new SqlParameter("@Uid", SqlDbType.Int, 4), new SqlParameter("@esOrderCreateTime", SqlDbType.DateTime), new SqlParameter("@esOrderContent", SqlDbType.VarChar, 512), new SqlParameter("@esOrderTotalPrice", SqlDbType.Float, 8), new SqlParameter("@esOrderStatus", SqlDbType.Int, 4), new SqlParameter("@Oid", SqlDbType.Decimal, 9) }; parameters[0].Value = model.Uid; parameters[1].Value = model.esOrderCreateTime; parameters[2].Value = model.esOrderContent; parameters[3].Value = model.esOrderTotalPrice; parameters[4].Value = model.esOrderStatus; parameters[5].Value = model.Oid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public iRan.Model.ServiceOrder GetModel(decimal Oid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Oid,Uid,esOrderCreateTime,esOrderContent,esOrderTotalPrice,esOrderStatus from ServiceOrder "); strSql.Append(" where Oid=@Oid "); SqlParameter[] parameters = { new SqlParameter("@Oid", SqlDbType.Decimal, 9) }; parameters[0].Value = Oid; iRan.Model.ServiceOrder model = new iRan.Model.ServiceOrder(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }