/// <summary>
/// 获得数据列表（比DataSet效率高，推荐使用）
/// </summary>
public List <VAN_OA.Model.JXC.CAI_OrderOutHouse> GetListArray(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" CAI_OrderOutHouse.Id,CAI_OrderOutHouse.CreateUserId,CAI_OrderOutHouse.CreateTime,RuTime,Supplier,DoPer,HouseID,houseName,ChcekProNo,ProNo,PONo,POName,Remark ,tb_User.loginName as CreateName,Status,FPNo,DaiLi,GuestName,AE ");
strSql.Append(" from CAI_OrderOutHouse left join tb_User on tb_User.id=CAI_OrderOutHouse.CreateUserId left join TB_HouseInfo on CAI_OrderOutHouse.HouseID=TB_HouseInfo.id ");
strSql.Append(" left join (select AE,PONO as CGPONO,IsSpecial from CG_POOrder where IFZhui=0 and Status='通过') as tb on tb.CGPONO=CAI_OrderOutHouse.PONO ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by CAI_OrderOutHouse.Id desc");
List <VAN_OA.Model.JXC.CAI_OrderOutHouse> list = new List <VAN_OA.Model.JXC.CAI_OrderOutHouse>();
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn);
using (SqlDataReader dataReader = objCommand.ExecuteReader())
{
while (dataReader.Read())
{
CAI_OrderOutHouse model = ReaderBind(dataReader);
object ojb;
ojb = dataReader["houseName"];
if (ojb != null && ojb != DBNull.Value)
{
model.HouseName = ojb.ToString();
}
ojb = dataReader["AE"];
if (ojb != null && ojb != DBNull.Value)
{
model.AE = ojb.ToString();
}
list.Add(model);
}
}
}
return(list);
}
protected void gvMain_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#EAF1FD',this.style.fontWeight='';");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor,this.style.fontWeight='';");
CAI_OrderOutHouse model = e.Row.DataItem as CAI_OrderOutHouse;
if (CAIInfo_HanShui.ContainsKey(model.Id))
{
bool hanShui = CAIInfo_HanShui[model.Id];
System.Web.UI.WebControls.Label lblIsHanShui = e.Row.FindControl("lblIsHanShui") as System.Web.UI.WebControls.Label;
if (lblIsHanShui != null)
{
lblIsHanShui.Text = hanShui ? "含税" : "不含税";
}
if (hanShui == false)
{
e.Row.BackColor = System.Drawing.Color.LightGray;
}
}
}
}
/// <summary>
/// 获得数据列表（比DataSet效率高，推荐使用）
/// </summary>
public List <VAN_OA.Model.JXC.CAI_OrderOutHouse> GetListArray(string strWhere, out decimal sumTotal)
{
string sqlSum = @"select
isnull(SUM(CAI_OrderOutHouses.GoodNum*CAI_OrderOutHouses.GoodPrice),0)
from CAI_OrderOutHouse left join tb_User on tb_User.id=CAI_OrderOutHouse.CreateUserId left join TB_HouseInfo on CAI_OrderOutHouse.HouseID=TB_HouseInfo.id
left join (select AE,PONO as CGPONO,IsSpecial from CG_POOrder where IFZhui=0 and Status='通过') as tb on tb.CGPONO=CAI_OrderOutHouse.PONO
left join CAI_OrderOutHouses on CAI_OrderOutHouse.Id=CAI_OrderOutHouses.id
left join CAI_OrderInHouses on CAI_OrderOutHouses.OrderCheckIds=CAI_OrderInHouses.Ids
left join CAI_OrderChecks on CAI_OrderInHouses.OrderCheckIds=CAI_OrderChecks.Ids
left join CAI_POCai on CAI_POCai.Ids=CAI_OrderChecks.CaiId
left join CAI_POOrder on CAI_POCai.Id=CAI_POOrder.Id
left join TB_Good ON CAI_OrderOutHouses.GooId=TB_Good.GoodId";
if (strWhere.Trim() != "")
{
sqlSum += " where " + strWhere;
}
sumTotal = Convert.ToDecimal(DBHelp.ExeScalar(sqlSum));
StringBuilder strSql = new StringBuilder();
strSql.Append("select DISTINCT ");
strSql.Append(@" CAI_OrderOutHouse.Id,CAI_OrderOutHouse.CreateUserId,CAI_OrderOutHouse.CreateTime,RuTime,CAI_OrderOutHouse.Supplier,DoPer,HouseID,houseName,ChcekProNo,CAI_OrderOutHouse.ProNo,CAI_OrderOutHouse.PONo,CAI_OrderOutHouse.POName,Remark ,tb_User.loginName as CreateName,
CAI_OrderOutHouse.Status,FPNo,DaiLi,CAI_OrderOutHouse.GuestName,CAI_POOrder.AE ");
strSql.Append(" from CAI_OrderOutHouse left join tb_User on tb_User.id=CAI_OrderOutHouse.CreateUserId left join TB_HouseInfo on CAI_OrderOutHouse.HouseID=TB_HouseInfo.id ");
strSql.Append(" left join (select AE,PONO as CGPONO,IsSpecial from CG_POOrder where IFZhui=0 and Status='通过') as tb on tb.CGPONO=CAI_OrderOutHouse.PONO ");
strSql.Append(@" left join CAI_OrderOutHouses on CAI_OrderOutHouse.Id=CAI_OrderOutHouses.id
left join CAI_OrderInHouses on CAI_OrderOutHouses.OrderCheckIds=CAI_OrderInHouses.Ids
left join CAI_OrderChecks on CAI_OrderInHouses.OrderCheckIds=CAI_OrderChecks.Ids
left join CAI_POCai on CAI_POCai.Ids=CAI_OrderChecks.CaiId
left join CAI_POOrder on CAI_POCai.Id=CAI_POOrder.Id
left join TB_Good ON CAI_OrderOutHouses.GooId=TB_Good.GoodId");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by CAI_OrderOutHouse.Id desc");
List <VAN_OA.Model.JXC.CAI_OrderOutHouse> list = new List <VAN_OA.Model.JXC.CAI_OrderOutHouse>();
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn);
using (SqlDataReader dataReader = objCommand.ExecuteReader())
{
while (dataReader.Read())
{
CAI_OrderOutHouse model = ReaderBind(dataReader);
object ojb;
ojb = dataReader["houseName"];
if (ojb != null && ojb != DBNull.Value)
{
model.HouseName = ojb.ToString();
}
ojb = dataReader["AE"];
if (ojb != null && ojb != DBNull.Value)
{
model.AE = ojb.ToString();
}
list.Add(model);
}
}
}
return(list);
}
