/// <summary> /// 获得数据列表(比DataSet效率高,推荐使用) /// </summary> public List <VAN_OA.Model.ReportForms.Tb_ExpInvsSumRep> GetListArray_Histroy(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Tb_ExpInv_View.* from Tb_ExpInv_View "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by Tb_ExpInv_View.InvName"); List <VAN_OA.Model.ReportForms.Tb_ExpInvsSumRep> list = new List <VAN_OA.Model.ReportForms.Tb_ExpInvsSumRep>(); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { while (dataReader.Read()) { VAN_OA.Model.ReportForms.Tb_ExpInvsSumRep model = new VAN_OA.Model.ReportForms.Tb_ExpInvsSumRep(); object ojb; ojb = dataReader["InvName"]; if (ojb != null && ojb != DBNull.Value) { model.InvName = Convert.ToString(ojb); } ojb = dataReader["ExpNum"]; if (ojb != null && ojb != DBNull.Value) { model.ExpNum = (decimal)ojb; } ojb = dataReader["Id"]; if (ojb != null && ojb != DBNull.Value) { model.Id = (int)ojb; } ojb = dataReader["InvId"]; if (ojb != null && ojb != DBNull.Value) { model.InvId = (int)ojb; } ojb = dataReader["InvNo"]; if (ojb != null && ojb != DBNull.Value) { model.InvNo = ojb.ToString(); } model.ExpUse = dataReader["ExpUse"].ToString(); model.ExpState = dataReader["ExpState"].ToString(); model.ExpRemark = dataReader["ExpRemark"].ToString(); ojb = dataReader["ReturnTime"]; if (ojb != null && ojb != DBNull.Value) { model.ReturnTime = (DateTime)ojb; } model.ProNo = dataReader["ProNo"].ToString(); model.ExpRemark = dataReader["ExpRemark"].ToString(); ojb = dataReader["ExpTime"]; if (ojb != null && ojb != DBNull.Value) { model.ExpTime = (DateTime)ojb; } ojb = dataReader["LoginName"]; if (ojb != null && ojb != DBNull.Value) { model.LoginName = ojb.ToString(); } ojb = dataReader["ExpInvState"]; if (ojb != null && ojb != DBNull.Value) { model.ExpInvState = ojb.ToString(); } list.Add(model); } } } return(list); }
/// <summary> /// 获得数据列表(比DataSet效率高,推荐使用) /// </summary> public List <VAN_OA.Model.ReportForms.Tb_ExpInvsSumRep> GetListArray_NoReurnInvs(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Tb_ExpInv_NoReurnInvView.*,Tb_Inventory.InvName as baseInvName,InvNo,Tb_Inventory.Id as baseInvId from Tb_Inventory left join Tb_ExpInv_NoReurnInvView"); strSql.Append(" on Tb_Inventory.Id=Tb_ExpInv_NoReurnInvView.InvId"); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by Tb_Inventory.InvName"); List <VAN_OA.Model.ReportForms.Tb_ExpInvsSumRep> list = new List <VAN_OA.Model.ReportForms.Tb_ExpInvsSumRep>(); System.Collections.Hashtable HsInvS = new System.Collections.Hashtable(); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { while (dataReader.Read()) { VAN_OA.Model.ReportForms.Tb_ExpInvsSumRep model = new VAN_OA.Model.ReportForms.Tb_ExpInvsSumRep(); object ojb; ojb = dataReader["baseInvName"]; if (ojb != null && ojb != DBNull.Value) { model.InvName = Convert.ToString(ojb); } ojb = dataReader["ExpNum"]; if (ojb != null && ojb != DBNull.Value) { model.ExpNum = (decimal)ojb; } if (!HsInvS.Contains(model.InvName)) { if (HsInvS.Keys.Count > 0) { foreach (string invName in HsInvS.Keys) { //decimal num = Convert.ToDecimal(HsInvS[invName]); VAN_OA.Model.ReportForms.Tb_ExpInvsSumRep modelTotal = new VAN_OA.Model.ReportForms.Tb_ExpInvsSumRep(); modelTotal.InvId = list[list.Count - 1].InvId; modelTotal.InvName = "小计"; //modelTotal.ExpNum = num; list.Add(modelTotal); } HsInvS.Clear(); } HsInvS.Add(model.InvName, ""); } //else //{ // decimal num = 0; // string key = ""; // foreach(string invName in HsInvS.Keys) // { // key = invName; // num=Convert.ToDecimal(HsInvS[invName]) + model.ExpNum; // } // HsInvS[key] = num; //} ojb = dataReader["Id"]; if (ojb != null && ojb != DBNull.Value) { model.Id = (int)ojb; } ojb = dataReader["baseInvId"]; if (ojb != null && ojb != DBNull.Value) { model.InvId = (int)ojb; } ojb = dataReader["InvNo"]; if (ojb != null && ojb != DBNull.Value) { model.InvNo = ojb.ToString(); } model.ExpUse = dataReader["ExpUse"].ToString(); model.ExpState = dataReader["ExpState"].ToString(); model.ExpRemark = dataReader["ExpRemark"].ToString(); ojb = dataReader["ReturnTime"]; if (ojb != null && ojb != DBNull.Value) { model.ReturnTime = (DateTime)ojb; } model.ProNo = dataReader["ProNo"].ToString(); ojb = dataReader["ExpTime"]; if (ojb != null && ojb != DBNull.Value) { model.ExpTime = (DateTime)ojb; } ojb = dataReader["LoginName"]; if (ojb != null && ojb != DBNull.Value) { model.LoginName = ojb.ToString(); } ojb = dataReader["ExpInvState"]; if (ojb != null && ojb != DBNull.Value) { model.ExpInvState = ojb.ToString(); } list.Add(model); } } } if (list.Count > 0) { if (HsInvS.Keys.Count > 0) { foreach (string invName in HsInvS.Keys) { VAN_OA.Model.ReportForms.Tb_ExpInvsSumRep modelTotal = new VAN_OA.Model.ReportForms.Tb_ExpInvsSumRep(); modelTotal.InvId = list[list.Count - 1].InvId; modelTotal.InvName = "小计"; list.Add(modelTotal); } HsInvS.Clear(); } } return(list); }