예제 #1
0
        public bool Add()
        {
            string guid   = Guid.NewGuid().ToString();
            string strSql = "insert into TAB_Base_Site (strSiteGUID,strSiteNumber,strSiteName,nSiteEnable,strSiteIP,nSiteJob,strStationGUID,strAreaGUID,strWorkShopGUID,strTMIS)  " +
                            " values (@strSiteGUID,@strSiteNumber,@strSiteName,@nSiteEnable,@strSiteIP,@nSiteJob,@strStationGUID,@strAreaGUID,@strWorkShopGUID,@strTMIS);" +
                            "insert into TAB_Base_Site_Limit(strSiteGUID,nJobID,nJobLimit)(select @strSiteGUID,@nSiteJob,nLimitID from TAB_System_Job_Limit)";

            SqlParameter[] sqlParams =
            {
                new SqlParameter("strSiteGUID",     guid),
                new SqlParameter("strSiteNumber",   strSiteNumber),
                new SqlParameter("strSiteName",     strSiteName),
                new SqlParameter("nSiteEnable",     nSiteEnable),
                new SqlParameter("strSiteIP",       strSiteIP),
                new SqlParameter("nSiteJob",        nSiteJob),
                new SqlParameter("strStationGUID",  strStationGUID),
                new SqlParameter("strWorkShopGUID", strWorkShopGUID),
                new SqlParameter("strAreaGUID",     strAreaGUID),
                new SqlParameter("strTMIS",         strTMIS)
            };
            bool bflag = SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams) > 0;

            //更新管理端IP
            Base_Site_Additional.InsertOrUpdate(guid, strConfirmIP);
            return(bflag);
        }
예제 #2
0
        public bool Update()
        {
            string strSql = @"update TAB_Base_Site set strSiteNumber=@strSiteNumber,nSiteEnable=@nSiteEnable,strSiteName=@strSiteName,strSiteIP=@strSiteIP,
                nSiteJob=@nSiteJob,strStationGUID=@strStationGUID,strAreaGUID=@strAreaGUID,strWorkShopGUID=@strWorkShopGUID,strTMIS=@strTMIS  where strSiteGUID=@strSiteGUID";

            SqlParameter[] sqlParams =
            {
                new SqlParameter("strSiteGUID",     strSiteGUID),
                new SqlParameter("strSiteNumber",   strSiteNumber),
                new SqlParameter("strSiteName",     strSiteName),
                new SqlParameter("nSiteEnable",     nSiteEnable),
                new SqlParameter("strSiteIP",       strSiteIP),
                new SqlParameter("nSiteJob",        nSiteJob),
                new SqlParameter("strStationGUID",  strStationGUID),
                new SqlParameter("strWorkShopGUID", strWorkShopGUID),
                new SqlParameter("strAreaGUID",     strAreaGUID),
                new SqlParameter("strTMIS",         strTMIS)
            };
            bool bflag = (SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams) > 0);

            Base_Site_Additional.InsertOrUpdate(strSiteGUID, strConfirmIP);
            return(bflag);
        }