/// <summary> /// 得到一个对象实体 /// </summary> public webs_YueyxShop.Model.OrderBase GetModel(int o_ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 o_ID,c_ID,m_ID,o_Code,o_CreateOn,o_Pric,o_Zhek,o_StatusCode,o_Mark,o_IsDel,pay_ID,st_ID,o_AlipayNo,o_LogisticsNo,o_Score from OrderBase "); strSql.Append(" where o_ID='"+o_ID+"'"); webs_YueyxShop.Model.OrderBase model=new webs_YueyxShop.Model.OrderBase(); DataSet ds=DbHelperSQL.Query(strSql.ToString()); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// 得到一个对象实体 /// </summary> public webs_YueyxShop.Model.OrderBase DataRowToModel2(DataRow row) { webs_YueyxShop.Model.OrderBase model = new webs_YueyxShop.Model.OrderBase(); if (row != null) { if (row["o_ID"] != null && row["o_ID"].ToString() != "") { model.o_ID = int.Parse(row["o_ID"].ToString()); } if (row["c_ID"] != null && row["c_ID"].ToString() != "") { model.c_ID = int.Parse(row["c_ID"].ToString()); } if (row["m_ID"] != null && row["m_ID"].ToString() != "") { model.m_ID = int.Parse(row["m_ID"].ToString()); } if (row["o_Code"] != null) { model.o_Code = row["o_Code"].ToString(); } if (row["o_CreateOn"] != null && row["o_CreateOn"].ToString() != "") { model.o_CreateOn = DateTime.Parse(row["o_CreateOn"].ToString()); } if (row["o_Pric"] != null && row["o_Pric"].ToString() != "") { model.o_Pric = decimal.Parse(row["o_Pric"].ToString()); } if (row["o_Zhek"] != null && row["o_Zhek"].ToString() != "") { model.o_Zhek = decimal.Parse(row["o_Zhek"].ToString()); } if (row["o_StatusCode"] != null && row["o_StatusCode"].ToString() != "") { model.o_StatusCode = int.Parse(row["o_StatusCode"].ToString()); } if (row["o_Mark"] != null) { model.o_Mark = row["o_Mark"].ToString(); } if (row["o_IsDel"] != null && row["o_IsDel"].ToString() != "") { if ((row["o_IsDel"].ToString() == "1") || (row["o_IsDel"].ToString().ToLower() == "true")) { model.o_IsDel = true; } else { model.o_IsDel = false; } } if (row["pay_ID"] != null && row["pay_ID"].ToString() != "") { model.pay_ID = int.Parse(row["pay_ID"].ToString()); } if (row["st_ID"] != null && row["st_ID"].ToString() != "") { model.st_ID = int.Parse(row["st_ID"].ToString()); } if (row["r_Status"] != null && row["r_Status"].ToString() != "" && row["r_Date"] != null && row["st_ID"].ToString() != "") { model.rejorder = new Model.RejectionBase { r_Status = int.Parse(row["r_Status"].ToString()), r_Date = DateTime.Parse(row["r_Date"].ToString()), r_Price = decimal.Parse(row["r_Price"].ToString()) }; } if (row["o_AlipayNo"] != null) { model.o_AlipayNo = row["o_AlipayNo"].ToString(); } if (row["o_LogisticsNo"] != null) { model.o_LogisticsNo = row["o_LogisticsNo"].ToString(); } if (row["o_Score"] != null && row["o_Score"].ToString() != "") { model.o_Score = int.Parse(row["o_Score"].ToString()); } } return model; }