/// <summary> /// 得到一个对象实体 /// </summary> public DataService.Model.v_Order GetModel(int OrderID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 OrderID,OrderCode,UserID,Use_UserID,Buyer,ProName,Province,City,Area,Address,remarks1,remarks2,IntoDate,OrderDate,IsCheck,IsDel,AddTime,TotalNum,total from v_Order "); strSql.Append(" where OrderID=@OrderID "); SqlParameter[] parameters = { new SqlParameter("@OrderID", SqlDbType.Int, 4) }; parameters[0].Value = OrderID; DataService.Model.v_Order model = new DataService.Model.v_Order(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DataService.Model.v_Order DataRowToModel(DataRow row) { DataService.Model.v_Order model = new DataService.Model.v_Order(); if (row != null) { if (row["OrderID"] != null && row["OrderID"].ToString() != "") { model.OrderID = int.Parse(row["OrderID"].ToString()); } if (row["OrderCode"] != null) { model.OrderCode = row["OrderCode"].ToString(); } if (row["UserID"] != null && row["UserID"].ToString() != "") { model.UserID = int.Parse(row["UserID"].ToString()); } if (row["Use_UserID"] != null && row["Use_UserID"].ToString() != "") { model.Use_UserID = int.Parse(row["Use_UserID"].ToString()); } if (row["Buyer"] != null) { model.Buyer = row["Buyer"].ToString(); } if (row["ProName"] != null) { model.ProName = row["ProName"].ToString(); } if (row["Province"] != null) { model.Province = row["Province"].ToString(); } if (row["City"] != null) { model.City = row["City"].ToString(); } if (row["Area"] != null) { model.Area = row["Area"].ToString(); } if (row["Address"] != null) { model.Address = row["Address"].ToString(); } if (row["remarks1"] != null) { model.remarks1 = row["remarks1"].ToString(); } if (row["remarks2"] != null) { model.remarks2 = row["remarks2"].ToString(); } if (row["IntoDate"] != null && row["IntoDate"].ToString() != "") { model.IntoDate = DateTime.Parse(row["IntoDate"].ToString()); } if (row["OrderDate"] != null && row["OrderDate"].ToString() != "") { model.OrderDate = DateTime.Parse(row["OrderDate"].ToString()); } if (row["IsCheck"] != null && row["IsCheck"].ToString() != "") { if ((row["IsCheck"].ToString() == "1") || (row["IsCheck"].ToString().ToLower() == "true")) { model.IsCheck = true; } else { model.IsCheck = false; } } if (row["IsDel"] != null && row["IsDel"].ToString() != "") { if ((row["IsDel"].ToString() == "1") || (row["IsDel"].ToString().ToLower() == "true")) { model.IsDel = true; } else { model.IsDel = false; } } if (row["AddTime"] != null && row["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(row["AddTime"].ToString()); } if (row["TotalNum"] != null && row["TotalNum"].ToString() != "") { model.TotalNum = decimal.Parse(row["TotalNum"].ToString()); } if (row["total"] != null && row["total"].ToString() != "") { model.total = decimal.Parse(row["total"].ToString()); } } return(model); }