FarmTrace/ashx/OrderProductionRecordDetail.ashx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using DataBaseLibrary.Utility;
using Model;
using Repository.impl;
using Repository.interfaces;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Text;
using DataBaseLibrary.DBUtility;

namespace FarmTrace.ashx
{
    /// <summary>
    /// BaseExpress 的摘要说明
    /// </summary>
    public class OrderProductionRecordDetail : IHttpHandler
    {

        #region 自定义变量
        ICommonRepository CommBll = new CommonRepository();
        OrderProductionRecordDetailModel model = new OrderProductionRecordDetailModel();
        ConvertJson ConJson = new ConvertJson();
        #endregion

        #region 自定义方法

        private void Add()
        {
            int OrderID = Common.GetQueryInt("OrderID");
            string strSheepIDs = Common.GetQueryString("strSheepIDs");
            if (OrderID > 0 && strSheepIDs != "")
            {
                StringBuilder strSQL = new StringBuilder();
                strSQL.Append(" insert into OrderProductionRecordDetail(SheepID , OrderProductionRecordID)");
                strSQL.Append(string.Format(" select SheepID , {0} from BaseSheep", OrderID.ToString()));
                strSQL.Append(string.Format(" where SheepID in ({0})", strSheepIDs));
                strSQL.Append(" and SheepID not in");
                strSQL.Append(string.Format(" (select SheepID from OrderProductionRecordDetail where OrderProductionRecordID = {0} and SheepID in ({1}))", OrderID.ToString(), strSheepIDs));

                DbHelperSQL.ExecuteSql(strSQL.ToString());
            }

        }

        #region 获取信息
        /// <summary>
        /// 获取信息
        /// </summary>
        /// <returns></returns>
        private string GetOrderProductionRecordDetail()
        {
            string result = string.Empty;
            int OrderProductionRecordID = Common.GetQueryInt("OrderProductionRecordID");
            ViewOrderProductionRecordDetailModel modelView = new ViewOrderProductionRecordDetailModel();
            DataTable dt = CommBll.GetList<ViewOrderProductionRecordDetailModel>(modelView, "OrderProductionRecordID = " + OrderProductionRecordID.ToString());
            if (dt != null)
            {
                result = ConJson.GetDataTableToDataGridJson(dt, dt.Rows.Count);