/// <summary>
/// 根据编号获取信息
/// </summary>
/// <param name="id">编号</param>
/// <returns></returns>
public ContractOrder getContractOrder(string id)
{
string strSql = "select a.id, a.contractID, b.name as contractName, a.orderID, "
+ "(select z.target from ADCostTarget z where z.id=a.costTargetID) as costTargetName, a.costTargetID, "
+ "b.customerID, (select z.name from CustomerInfo z where z.id=b.customerID) as customerName, "
+ "a.roomNum, a.begintime, a.endtime, a.memo, "
+ "(select z.target from MakeCostTarget z where z.id=a.makeTargetID) as makeTargetName, a.makeTargetID, "
+ "a.playReport, a.reportTime, a.mdate from OrderInfo a, ContractInfo b where a.contractID=b.contractID and a.orderID=@id";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@id", id)
};
IDataReader dr = SqlHelper.ExecuteReader(BaseHelper.DBConnStr, CommandType.Text, strSql, param);
IList <OrderInfo> list = DynamicBuilder <OrderInfo> .ConvertToList(dr);
if (list != null && list.Count > 0)
{
ContractOrder en = new ContractOrder();
en.order = list[0];
DaContractInfo dal = new DaContractInfo();
en.contract = dal.getEntity(list[0].contractID);
return(en);
}
else
{
return(null);
}
}
/// <summary>
/// 根据订单编号获取合同和订单的复合信息
/// </summary>
/// <returns></returns>
public JsonResult Order_getContractOrderInfo(string id)
{
DaOrderInfo dal = new DaOrderInfo();
ContractOrder en = dal.getContractOrder(id);
var result = new CustomJsonResult();
result.dateFormat = "yyyy-MM-dd";
result.Data = en;
return(result);
}
