コード例 #1
0
        public int delMachineTypeByNames(string machineName)
        {
            string sql     = @"DELETE FROM machineTypes WHERE machineName ='" + machineName + "'";
            int    delRows = IEBOM_SqlHelper.ExecuteNonQuery(sql);

            return(delRows);
        }
コード例 #2
0
        public int saveLearningCurveName(string CurveName)
        {
            string sql = @"
                            INSERT INTO	dbo.CureNames
                            (
                               
                                modulusName,
                                isNewStyle,
                                isDel,
                                Remark
                            )
                            VALUES
                            (  
                                 @CurveName, 
                                0, 
                                0, 
                                N''
                                )  SELECT IDENT_CURRENT('CureNames')";

            SqlParameter[] ps =
            {
                new SqlParameter("CurveName", CurveName)
            };
            return(IEBOM_SqlHelper.ExcuteScalar <int>(sql, ps));
        }
コード例 #3
0
 public void cModulusNames(DataRow dr, StyleLearingCurve list)
 {
     list.id          = Convert.ToInt32(IEBOM_SqlHelper.FromDbValue(dr["id"]));
     list.modulusName = Convert.ToString(IEBOM_SqlHelper.FromDbValue(dr["modulusName"]));
     list.isNewStyle  = Convert.ToBoolean(IEBOM_SqlHelper.FromDbValue(dr["isNewStyle"]));
     list.remark      = Convert.ToString(IEBOM_SqlHelper.FromDbValue(dr["Remark"]));
 }
コード例 #4
0
 public void dataToMachines(DataRow dr, MODEL.Machines list)
 {
     list.machineClass     = Convert.ToString(IEBOM_SqlHelper.FromDbValue(dr["machineClass"]));    // 机器类别
     list.machineName      = Convert.ToString(IEBOM_SqlHelper.FromDbValue(dr["MachineName"]));     // 机器类别名称
     list.machineNameEN    = Convert.ToString(IEBOM_SqlHelper.FromDbValue(dr["machineNameEN"]));   // 机器类别名称英文
     list.MachinesMark     = Convert.ToString(IEBOM_SqlHelper.FromDbValue(dr["machinesMark"]));    // 机器备注
     list.isMachinesStatus = Convert.ToInt32(IEBOM_SqlHelper.FromDbValue(dr["isMachinesStatus"])); // 机器类别状态
     list.CreateDate       = Convert.ToDateTime(IEBOM_SqlHelper.FromDbValue(dr["CreateDate"]));    // 创建时间
     list.Creator          = Convert.ToString(IEBOM_SqlHelper.FromDbValue(dr["Creator"]));         // 创建者
     list.modify           = Convert.ToDateTime(IEBOM_SqlHelper.FromDbValue(dr["modify"]));        // 最后修改时间
     list.modifor          = Convert.ToString(IEBOM_SqlHelper.FromDbValue(dr["modifor"]));         //  最后修改者
 }
コード例 #5
0
        public int delStandardModulusByCurveNameID(int CurveNameID)
        {
            string sql = @"UPDATE dbo.StandardModulus SET isDel = 1 WHERE CureNamesID =@CurveNameID";


            SqlParameter[] ps =
            {
                new SqlParameter("CurveNameID", CurveNameID)
            };
            int result = IEBOM_SqlHelper.ExecuteNonQuery(sql, ps);

            return(result);
        }
コード例 #6
0
        public int getLearningByCurveName(string CurveName)
        {
            string sql     = @"SELECT id FROM CureNames WHERE modulusName =@CurveName";
            int    namesid = -1;

            SqlParameter[] ps =
            {
                new SqlParameter("CurveName", CurveName)
            };
            DataTable dt = IEBOM_SqlHelper.ExcuteTable(sql, ps);

            if (dt.Rows.Count > 0)
            {
                namesid = Convert.ToInt32(dt.Rows[0][0].ToString());
            }
            return(namesid);
        }
コード例 #7
0
        public List <string> getIEVersions(string styleNumber)
        {
            List <string> versions = new List <string>();
            string        sql      = @"SELECT IEBomVersion  FROM dbo.IEBomBase	 WHERE IEBomStyleName=@styleNumber";

            SqlParameter[] paras =
            {
                new SqlParameter("@styleNumber", styleNumber)
            };

            DataTable dt = IEBOM_SqlHelper.ExcuteTable(sql, paras);

            if (dt != null && dt.Rows.Count > 0)
            {
            }
            List <string> IEVersions

            return
        }
コード例 #8
0
        public DataTable getStandardModulusByCurveNameID(int CurveNameID)
        {
            string sql = @"SELECT 
                                   CureNamesID,
                                   CArea,
                                   Clevel,
                                   CsingleMinute,
                                   Cratio,
                                   COneday,
                                   CTwoDay,
                                   CThreeDay,
                                   CFourDay,
                                   CFiveDay,
                                   CSixDay,
                                   CSevenDay,
                                   CEightDay,
                                   CNineDay,
                                   CTenDay,
                                   CElevenDay,
                                   CTwelveDay,
                                   CThirteenDay,
                                   CFourteenDay,
                                   Creator,
                                   CreateDate,
                                   modiyDate,
                                   modiyed,
                                   isNewStyle,
                                   isDel
                            FROM dbo.StandardModulus
                            WHERE CureNamesID = @CurveNameID
                                  AND isdel IS NULL;";


            SqlParameter[] ps =
            {
                new SqlParameter("CurveNameID", CurveNameID)
            };
            DataTable dt = IEBOM_SqlHelper.ExcuteTable(sql, ps);

            return(dt);
        }
コード例 #9
0
        public DataTable getAllMachineTypes()
        {
            string sql = @"SELECT  
                                   machineClass,
                                   MachineName,
                                   machineNameEN,
                                   machinesMark,
                                   CreateDate,
                                   Creator,
                                   modify,
                                   modifor,
                                   ismachinesStatus
                            FROM machinetypes
                            ORDER BY ismachinesStatus,                                    
                                     machineClass; ";


            DataTable dt = IEBOM_SqlHelper.ExcuteTable(sql);

            return(dt);

            /*
             *
             * List<Machines> machinesLists = null;
             *
             * if (dt != null && dt.Rows.Count > 0)
             * {
             *  DataRow dr = dt.Rows[0];
             *  machinesLists = new List<Machines>();
             *  foreach (DataRow row in dt.Rows)
             *  {
             *      MODEL.Machines c = new MODEL.Machines();
             *      dataToMachines(row, c);
             *      machinesLists.Add(c);
             *  }
             * }
             *
             * return machinesLists;
             */
        }
コード例 #10
0
        public List <StyleLearingCurve> getCurveNames()
        {
            string sql = @"SELECT id,
                                   modulusName,
                                   isNewStyle,
                                   Remark
                            FROM dbo.CureNames
                            WHERE isDel = 0;";

            List <StyleLearingCurve> lists = new List <StyleLearingCurve>();
            DataTable modulusNames         = IEBOM_SqlHelper.ExcuteTable(sql);

            if (modulusNames.Rows.Count > 0)
            {
                foreach (DataRow row in modulusNames.Rows)
                {
                    StyleLearingCurve c = new StyleLearingCurve();
                    cModulusNames(row, c);
                    lists.Add(c);
                }
            }
            return(lists);
        }
コード例 #11
0
        public List <string> saveMachineTypes(DataTable machineDT)
        {
            List <string> results = new List <string>();

            DataTable newDt = new DataTable();

            //  newDt.Columns.Add(new DataColumn("machineID", typeof(int))); //
            newDt.Columns.Add(new DataColumn("machineClass", typeof(string)));  //机器类别
            newDt.Columns.Add(new DataColumn("MachineName", typeof(string)));   //机器类别名称
            newDt.Columns.Add(new DataColumn("machineNameEN", typeof(string))); //机器类别名称英文
            newDt.Columns.Add(new DataColumn("machinesMark", typeof(string)));  //机器备注
            newDt.Columns.Add(new DataColumn("isMachinesStatus", typeof(int))); //机器类别状态
            newDt.Columns.Add(new DataColumn("CreateDate", typeof(DateTime)));  // 创建时间
            newDt.Columns.Add(new DataColumn("Creator", typeof(string)));       // 创建者
            newDt.Columns.Add(new DataColumn("modify", typeof(DateTime)));      // 最后修改时间
            newDt.Columns.Add(new DataColumn("modifor", typeof(string)));       //  最后修改者


            for (int i = 0; i < machineDT.Rows.Count; i++)
            {
                DataRow dr = newDt.NewRow();
                dr["machineClass"]  = machineDT.Rows[i]["machineClass"];
                dr["MachineName"]   = machineDT.Rows[i]["MachineName"];
                dr["machineNameEN"] = machineDT.Rows[i]["machineNameEN"];
                dr["machinesMark"]  = machineDT.Rows[i]["machinesMark"];

                dr["isMachinesStatus"] = machineDT.Rows[i]["ismachinesStatus"];
                dr["CreateDate"]       = machineDT.Rows[i]["CreateDate"];
                dr["Creator"]          = machineDT.Rows[i]["Creator"];
                dr["modify"]           = machineDT.Rows[i]["modify"];
                dr["modifor"]          = machineDT.Rows[i]["modifor"];

                newDt.Rows.Add(dr);
            }

            // 清空临时表
            string empTmp = @"DELETE FROM machineTypes_tmp";

            IEBOM_SqlHelper.ExecuteNonQuery(empTmp);


            //写入临时表
            string result  = IEBOM_SqlHelper.SqlBulkCopyMachineTypes(newDt);
            int    newData = 0;


            // 写入成功 调用存储过程 失败返回原因
            if (result == "0")
            {
                string callStudent = @"exec get_NewMachines;";
                newData = IEBOM_SqlHelper.ExecuteNonQuery(callStudent);
                //  return newData.ToString();
                results.Add("0");
                results.Add(newData.ToString());
            }
            else
            {
                results.Add(result);
                results.Add("0");
            }

            return(results);
        }
コード例 #12
0
        public string saveLearningCurve(DataTable newDt)
        {
            string result = IEBOM_SqlHelper.SqlBulkCopy(newDt);

            return(result);
        }