public List <ui.ReturnMerchandises> QuerySalesReturnInfoByID(string return_id) { List <ui.ReturnMerchandises> data_list = new List <ui.ReturnMerchandises>(); DataSet ds = ExecuteDataSet(@"select a.*,b.code,b.name,b.goods_id,b.units from goods_return a, goods b where return_id=@return_id and a.goods_id=b.goods_id", new MySqlParameter("@return_id", return_id)); if (null != ds && ds.Tables.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; ui.ReturnMerchandises data = BuildReturnMerchData(dr); data_list.Add(data); } } return(data_list); }
private ui.ReturnMerchandises BuildReturnMerchData(DataRow dr) { ui.ReturnMerchandises data = new ui.ReturnMerchandises(); data.ID = (string)dr["uuid"]; if (!string.IsNullOrEmpty(dr["return_id"].ToString())) { data.OrderID = (string)dr["return_id"]; } if (!string.IsNullOrEmpty(dr["code"].ToString())) { data.MerchID = (string)dr["code"]; } if (!string.IsNullOrEmpty(dr["name"].ToString())) { data.MerchName = (string)dr["name"]; } if (!string.IsNullOrEmpty(dr["units"].ToString())) { data.Uint = (string)dr["units"]; } if (!string.IsNullOrEmpty(dr["price"].ToString())) { data.UintPrice = (decimal)dr["price"]; } if (!string.IsNullOrEmpty(dr["num"].ToString())) { data.Amount = (float)dr["num"]; } if (!string.IsNullOrEmpty(dr["return_value"].ToString())) { data.TotalMoney = (decimal)dr["return_value"]; } if (!string.IsNullOrEmpty(dr["pledge"].ToString())) { data.TotalDeposit = (decimal)dr["pledge"]; } if (!string.IsNullOrEmpty(dr["goods_id"].ToString())) { data.GoodsID = (string)dr["goods_id"]; } return(data); }