/// <summary>
/// 添加订单
/// </summary>
/// <param name="en">订单信息</param>
/// <returns></returns>
public int add(OrderInfo en)
{
string strSql = "insert into OrderInfo (contractID, orderID, costTargetID, roomNum, begintime, endtime, memo, makeTargetID, playReport, reportTime, mdate) "
+ "values (@contractID, @orderID, @costTargetID, @roomNum, @begintime, @endtime, @memo, @makeTargetID, @playReport, @reportTime, @mdate)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@contractID", en.contractID),
new SqlParameter("@orderID", en.orderID),
new SqlParameter("@costTargetID", en.costTargetID),
new SqlParameter("@roomNum", en.roomNum),
new SqlParameter("@begintime", en.begintime),
new SqlParameter("@endtime", en.endtime),
new SqlParameter("@memo", en.memo),
new SqlParameter("@makeTargetID", en.makeTargetID),
new SqlParameter("@playReport", System.DBNull.Value),
new SqlParameter("@reportTime", System.DBNull.Value),
new SqlParameter("@mdate", DateTime.Now)
};
int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param);
return result;
}
/// <summary>
/// 修改订单
/// </summary>
/// <param name="en">订单信息</param>
/// <returns></returns>
public int update(OrderInfo en)
{
string strSql = "update OrderInfo set orderID=@orderID, costTargetID=@costTargetID, makeTargetID=@makeTargetID, roomNum=@roomNum, begintime=@begintime, endtime=@endtime, memo=@memo where id=@id ";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@orderID", en.orderID),
new SqlParameter("@costTargetID", en.costTargetID),
new SqlParameter("@makeTargetID", en.makeTargetID),
new SqlParameter("@roomNum", en.roomNum),
new SqlParameter("@begintime", en.begintime),
new SqlParameter("@endtime", en.endtime),
new SqlParameter("@memo", en.memo),
new SqlParameter("@id", en.id)
};
int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param);
return result;
}
public JsonResult Order_edit(string id, string orderID, string adCost, string makeCost, string num, string begin, string end, string memo)
{
if (num.Trim() == "")
num = "0";
OrderInfo en = new OrderInfo();
en.id = Convert.ToInt32(id);
en.orderID = orderID;
en.costTargetID = Convert.ToInt32(adCost);
en.makeTargetID = Convert.ToInt32(makeCost);
en.roomNum = Convert.ToInt32(num);
en.begintime = Convert.ToDateTime(begin);
en.endtime = Convert.ToDateTime(end);
en.memo = memo;
DaOrderInfo dal = new DaOrderInfo();
var result = new CustomJsonResult();
result.Data = dal.update(en);
return result;
}