/// <summary>
/// 销售退货 到 采购退货
/// </summary>
public List <VAN_OA.Model.JXC.CAI_OrderOutHouses> GetListArray_SellInToCaiOut_Result(string proNO)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"select CAI_OrderOutHouse.ProNo,CAI_OrderOutHouse.Supplier,CAI_OrderOutHouse.PONo,CAI_OrderOutHouse.POName,Ids,CAI_OrderOutHouse.id,
GooId,GoodNum,GoodPrice,GoodRemark,GoodNo,GoodName,GoodSpec,GoodModel,GoodUnit,GoodTypeSmName,OrderCheckIds,QingGouPer
from CAI_OrderOutHouse left join CAI_OrderOutHouses on CAI_OrderOutHouse.id=CAI_OrderOutHouses.Id
left join TB_Good on TB_Good.GoodId=CAI_OrderOutHouses.GooId where Remark like '销售退货单号:{0}';", proNO);
List <VAN_OA.Model.JXC.CAI_OrderOutHouses> list = new List <VAN_OA.Model.JXC.CAI_OrderOutHouses>();
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn);
using (SqlDataReader dataReader = objCommand.ExecuteReader())
{
while (dataReader.Read())
{
CAI_OrderOutHouses model = ReaderBind_Out(dataReader);
object ojb;
ojb = dataReader["PONo"];
if (ojb != null && ojb != DBNull.Value)
{
model.PONo = Convert.ToString(ojb);
}
ojb = dataReader["POName"];
if (ojb != null && ojb != DBNull.Value)
{
model.POName = Convert.ToString(ojb);
}
ojb = dataReader["ProNo"];
if (ojb != null && ojb != DBNull.Value)
{
model.ProNo = Convert.ToString(ojb);
}
ojb = dataReader["Supplier"];
if (ojb != null && ojb != DBNull.Value)
{
model.Supplier = Convert.ToString(ojb);
}
list.Add(model);
}
}
}
return(list);
}
protected void gvList_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_OrderOutHouses model = e.Row.DataItem as CAI_OrderOutHouses;
SumOrders.Total += model.Total;
}
// 合计
if (e.Row.RowType == DataControlRowType.Footer)
{
setValue(e.Row.FindControl("lblGoodName") as Label, "合计"); //合计
setValue(e.Row.FindControl("lblTotal") as Label, SumOrders.Total.ToString()); //成本总额
}
}
/// <summary>
/// 销售退货 到 采购退货
/// </summary>
public List <VAN_OA.Model.JXC.CAI_OrderOutHouses> GetListArray_SellInToCaiOut(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" CaiLastTruePrice,CAI_OrderInHouse.ProNo,CAI_OrderInHouse.Supplier,CAI_OrderInHouse.PONo,CAI_OrderInHouse.POName,Ids,CAI_OrderInHouse.id,GooId,GoodNum,GoodPrice,GoodRemark,GoodNo,GoodName,GoodSpec,GoodModel,GoodUnit,GoodTypeSmName,OrderCheckIds,totalOrderNum,QingGouPer");
strSql.Append(" from Cai_POOrderInHouse_Cai_POOrderOutHouse_ListView left join CAI_OrderInHouse on Cai_POOrderInHouse_Cai_POOrderOutHouse_ListView.id=CAI_OrderInHouse.Id");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
List <VAN_OA.Model.JXC.CAI_OrderOutHouses> list = new List <VAN_OA.Model.JXC.CAI_OrderOutHouses>();
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn);
using (SqlDataReader dataReader = objCommand.ExecuteReader())
{
while (dataReader.Read())
{
CAI_OrderOutHouses model = ReaderBind_Out(dataReader);
object ojb;
ojb = dataReader["totalOrderNum"];
if (ojb != null && ojb != DBNull.Value)
{
model.GoodNum = model.GoodNum - Convert.ToDecimal(ojb);
}
ojb = dataReader["PONo"];
if (ojb != null && ojb != DBNull.Value)
{
model.PONo = Convert.ToString(ojb);
}
ojb = dataReader["POName"];
if (ojb != null && ojb != DBNull.Value)
{
model.POName = Convert.ToString(ojb);
}
ojb = dataReader["ProNo"];
if (ojb != null && ojb != DBNull.Value)
{
model.ProNo = Convert.ToString(ojb);
}
ojb = dataReader["Supplier"];
if (ojb != null && ojb != DBNull.Value)
{
model.Supplier = Convert.ToString(ojb);
}
ojb = dataReader["CaiLastTruePrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.CaiLastTruePrice = Convert.ToDecimal(ojb);
}
list.Add(model);
}
}
}
return(list);
}
